SSAS MCP Server: Let AI Agents Query Your Analysis Services Cubes

NexusAI Solutions has released an open-source MCP server that gives AI agents direct, read-only access to SQL Server Analysis Services (SSAS) cubes. The server supports both DAX and MDX queries, works with any MCP client, and includes six tools for querying and exploring cube metadata. It is designed to eliminate the bottleneck of requiring specialized DAX or MDX knowledge for ad-hoc data questions.

If you work with SSAS, you know the drill. The data is there, the cubes are well-modeled, but actually getting answers out of them requires someone who knows DAX or MDX. For most organizations that means a small group of people becomes the bottleneck for every ad-hoc question. We got tired of that pattern, so we built an MCP server that gives AI agents direct access to SSAS. It connects through ADOMD.NET, supports both DAX and MDX, and works with any MCP client Claude Desktop, GitHub Copilot, Cursor, Claude Code, whatever you prefer . It's open source, MIT licensed, and you can install it with pip. Repo: NexusAI-Solutions/ssas-mcp-server https://github.com/NexusAI-Solutions/ssas-mcp-server Six tools, all read-only: | Tool | What it does | |---|---| execute query | Run DAX or MDX queries | list catalogs | List databases on the instance | list tables | Tables, dimensions, measure groups | list columns | Columns for a specific table | list measures | All measures with their DAX expressions | describe model | Model overview with tables, measures, metadata | The AI agent uses these tools to figure out the model structure, write the appropriate query, run it, and return the results. You ask a question in plain English, it handles the rest. pip install ssas-mcp-server Environment variables: set SSAS SERVER=YOUR SERVER\INSTANCE set SSAS DATABASE=Your Cube Name claude desktop config.json : { "mcpServers": { "ssas": { "command": "python", "args": "-m", "ssas mcp server" , "env": { "SSAS SERVER": "YOUR SERVER\\INSTANCE", "SSAS DATABASE": "Your Cube Name" } } } } .vscode/mcp.json : { "servers": { "ssas": { "command": "python", "args": "-m", "ssas mcp server" , "env": { "SSAS SERVER": "YOUR SERVER\\INSTANCE", "SSAS DATABASE": "Your Cube Name" } } } } claude mcp add ssas -- python -m ssas mcp server Fair question. Here's the short version: | SSAS MCP Server | CData SSAS MCP | Power BI MCP Server | | |---|---|---|---| Data source | SSAS Tabular + Multidimensional | SSAS via JDBC | Power BI semantic models only | Queries | Native DAX + MDX | SQL translated | DAX via Copilot | License | MIT free | Commercial paid | Free | Runtime | Python | Java | Cloud / VS Code | Setup | pip install | JDBC driver + config | Microsoft ecosystem | CData requires a paid license and runs on Java. It translates queries to SQL instead of using native DAX/MDX, which limits what you can do analytically. Microsoft's Power BI MCP Server only works with Power BI semantic models. If your cubes run on standalone SSAS or Azure Analysis Services, it doesn't apply. This server fills the gap: lightweight, open source, direct SSAS connection, native query languages. Read-only by design. No network endpoint exposed runs via stdio . Authentication goes through your existing SSAS instance security, so whatever permissions the Windows user has, the AI agent inherits. Nothing more. The most common scenario we see: someone in a meeting needs a number that doesn't exist in any pre-built report. Normally that becomes a request that takes a day or two. With this, the analyst opens Claude and asks the question directly. Answer comes back in seconds, and you can see the actual DAX query it ran if you want to verify. Also useful for onboarding. New people on the team can ask "describe the data model" and get a structured overview instead of digging through documentation that's probably outdated anyway. Windows only, because ADOMD.NET requires .NET Framework. We're looking into cross-platform options but nothing concrete yet. If you run into issues or have feature requests, open an issue on GitHub. And if you need help integrating MCP servers into your BI stack, we do that too https://www.nexus-ai.nl/contact .