MCP server for querying SQL Server Analysis Services (SSAS) via DAX and MDX
Connect Ssas to Claude, Cursor or any other MCP client and it stops being a tab you switch to. MCP server for querying SQL Server Analysis Services (SSAS) via DAX and MDX. The ssas mcp server is what makes that connection.
A Model Context Protocol (MCP) 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.
ssas-mcp-server on PyPI is all you need. Most clients run it directly, so configuration is a few lines and a restart.
Configuration is passed through the environment: SSAS_SERVER, SSAS_DATABASE, ADOMD_DLL_PATH. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
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 The server auto-detects common install locations. If yourAmong the database access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes.
SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.
{
"mcpServers": {
"ssas": {
"command": "ssas-mcp-server",
"env": {
"SSAS_SERVER": "SERVER\\INSTANCE",
"SSAS_DATABASE": "My Cube"
}
}
}
}Configuration as documented by the project. Restart the client after saving.
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 The server auto-detects common install locations. If your| Variable | Description | Required |
|---|---|---|
| SSAS_SERVER | Configuration value read at startup. | Optional |
| SSAS_DATABASE | Configuration value read at startup. | Optional |
| ADOMD_DLL_PATH | Filesystem location the server is allowed to use. | Optional |
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.