Open-Source MCP Server Lets AI Agents Query SSAS Cubes via DAX and MDX
NexusAI Solutions has released an open-source, MIT-licensed MCP server that gives AI agents direct, read-only access to SQL Server Analysis Services (SSAS) cubes. The tool connects via ADOMD.NET, supports both DAX and MDX queries natively, and is compatible with popular MCP clients such as Claude Desktop, GitHub Copilot, and Cursor. Users can install it with a single pip command and configure it using environment variables pointing to their SSAS server and database. The server exposes six read-only tools covering query execution, catalog listing, table and column discovery, measure inspection, and model description, allowing analysts to ask plain-English questions and receive results in seconds. Currently limited to Windows due to ADOMD.NET's .NET Framework dependency, the project positions itself as a lightweight, free alternative to paid options like CData's SSAS MCP Server.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in