SSAS Cube MCP

by nexusai-solutions

Not rated
GitHub

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

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.

AModel Context Protocol (MCP)server that connects AI agents toSQL 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.

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 standalone
AMO/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.

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.