SSAS Cube MCP
About
About MCP server for querying SQL Server Analysis Services (SSAS) via DAX and MDX. Connects AI agents like GitHub Copilot, Claude, and other MCP clients to your SSAS cubes.
Details
- Author
- nexusai-solutions
- Categories
- Other, AI
Jump to
Setup
Install SSAS Cube MCP in your MCP client (Claude Desktop, Cursor, Windsurf, and others).
Repository: https://github.com/nexusai-solutions/ssas-mcp-server
Follow the installation instructions in the repository README, then restart your MCP client.
Windows only
SSAS uses the ADOMD.NET client library, which requires .NET Framework on Windows.
ADOMD.NET client library
The DLLMicrosoft.AnalysisServices.AdomdClient.dllmust be present on the machine. It ships with any of these:
- SQL Server Management Studio (SSMS)
- Power BI Desktop
- The standaloneAMO/ADOMD client libraries
The server auto-detects common install locations. If your DLL is elsewhere, set theADOMD_DLL_PATHenvironment variable to the folder containing it.
After installation, the server can be started with:
git clone https://github.com/NexusAI-Solutions/ssas-mcp-server.git cd ssas-mcp-server pip install .
The server is configured through environment variables:
set SSAS_SERVER=SERVER\INSTANCE set SSAS_DATABASE=My Cube ssas-mcp-server
The server starts in stdio mode and waits for an MCP client to connect.
{ "servers": { "ssas": { "command": "ssas-mcp-server", "env": { "SSAS_SERVER": "SERVER\\INSTANCE", "SSAS_DATABASE": "My Cube" } } } }
Then set the environment variables in your shell before starting Claude Code, or pass them inline.
Add to yourclaude_desktop_config.json:
{ "mcpServers": { "ssas": { "command": "ssas-mcp-server", "env": { "SSAS_SERVER": "SERVER\\INSTANCE", "SSAS_DATABASE": "My Cube" } } } }
Once connected, you can ask your AI assistant things like:
- "List all tables in the SSAS model"
- "Show me the measures and their DAX expressions"
- "Run this DAX query:EVALUATE TOPN(10, 'Sales', [Revenue], DESC)"
- "Describe the data model"
- "What columns does the Customers table have?"
Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient'
The ADOMD.NET DLL was not found. Solutions:
- Install SSMS, Power BI Desktop, or the standalone AMO client libraries.
- SetADOMD_DLL_PATHto the folder containingMicrosoft.AnalysisServices.AdomdClient.dll.
where /r "C:\Program Files" Microsoft.AnalysisServices.AdomdClient.dll
- Verify the server name matches exactly what works in SSMS or Power BI.
- For named instances, use theSERVER\INSTANCEformat.
- Make sure the SQL Server Browser service is running if you are connecting by instance name.
An MCP server for AI video generation. MCP server for AI video generation. Lets Claude, ChatGPT, OpenClaw , Hermes & other agents create AI videos and publish them to YouTube, TikTok, Instagram etc..
HumanDesign.ai MCP is the official account-connected Human Design server for Claude, ChatGPT, Codex, Cursor, and VS Code.
A Model Context Protocol (MCP) server written in Go that wraps the APsystems OpenAPI, giving AI assistants like Claude direct access to your solar monitoring data. Includes an optional web dashboard for visual monitoring.
MCP server for interacting with the APVISO AI-powered penetration testing platform from Claude Code, Cursor, Windsurf, Codex, and other MCP-compatible tools.
AI-powered text-to-speech MCP server with instant voice cloning. Generate speech from Claude Desktop, Claude Code, or n8n using 5 built-in voices (English, German, French, Spanish) or clone any voice from a short audio sample. Runs fully local, no API keys, no cloud. Supports stdio, SSE, and HTTP transports.
Chess.com player, game, and daily-puzzle tools where each tool ships its own interactive React view — board replays and a playable puzzle widget, not just text. Built with Skybridge for ChatGPT & Claude.
Pre-indexed code knowledge graph, auto syncs on code changes, for Claude Code, Codex, Gemini, Cursor, OpenCode, AntiGravity, Kiro, and Hermes Agent — fewer tokens, fewer tool calls, 100% local
Live crypto technical analysis MCP server — EMA, RSI, MACD, ATR, Bollinger Bands, TSS scoring, and Claude AI bull/bear debate via CoinGecko free API
A high-performance trading system for Claude Desktop, providing real-time market data via Tiingo and optional Telegram alerts.
Ask Power BI in plain English, from Claude — charts + full ETL context.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.




