MCP server for querying SQL Server Analysis Services (SSAS) via DAX and MDX
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"ssas-mcp-server","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# SSAS MCP Server A [Model Context Protocol (MCP)](https://modelcontextprotocol.io/) server that connects AI agents to **SQL Server Analysis Services (SSAS)**. It lets tools like GitHub Copilot, Claude (via Codex or Claude Code), and other MCP clients run DAX and MDX queries, explore models, and list measures, all through natural language. > **Windows only** \ > SSAS uses the ADOMD.NET client library, which requires .NET Framework on Windows. ## Features | Tool | Description | | ----------------- | -------------------------------------------------------- | | `execute_query` | Run any DAX (`EVALUATE ...`) or MDX (`SELECT ...`) query | | `list_catalogs` | List all databases on the SSAS instance | | `list_tables` | List tables, dimensions, and measure groups | | `list_columns` | List columns for a specific table | | `list_measures` | List all visible measures with their DAX expressions | | `describe_model` | High-level summary: tables, measures, metadata | ## Prerequisites 1. **Python 3.10+** 2. **ADOMD.NET client library** \ The DLL `Microsoft.AnalysisServices.AdomdClient.dll` must be present on the machine. It ships with any of these: - SQL Server Management Studio (SSMS) - Power BI Desktop - The standalone [AMO/ADOMD client libraries](https://learn.microsoft.com/en-us/analysis-services/client-libraries) The server auto-detects common install locations. If your DLL is elsewhere, set the `ADOMD_DLL_PATH` environment variable to the folder containing it. ## Installation ```bash pip install ssas-mcp-server ``` After installation, the server can be started with: ```bash ssas-mcp-server ``` Or install from source: ```bash git clone https://github.com/NexusAI-Solutions/ssas-mcp-server.git cd ssas-mcp-server pip install . ``` ## Configuration The server is configured through environment variables: | Varia…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.