How do I install the ssas mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `SSAS_SERVER`, `SSAS_DATABASE`, `ADOMD_DLL_PATH` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Ssas MCP Server

MCP server for querying SQL Server Analysis Services (SSAS) via DAX and MDX

Local serverstdioPython

What is the Ssas MCP Server?

MCP server for querying SQL Server Analysis Services (SSAS) via DAX and MDX

What the server does

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.

Credentials and setup notes

Python 3.10+ 2. ADOMD.NET client library \ The DLL 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

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the Ssas MCP Server

{
  "mcpServers": {
    "ssas": {
      "command": "ssas-mcp-server",
      "env": {
        "SSAS_SERVER": "SERVER\\INSTANCE",
        "SSAS_DATABASE": "My Cube"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Python 3.10+ 2. ADOMD.NET client library \ The DLL 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	Declared in the maintainer’s client configuration.	Check documentation
SSAS_DATABASE	Declared in the maintainer’s client configuration.	Check documentation

Frequently asked questions

MCP server for querying SQL Server Analysis Services (SSAS) via DAX and MDX Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.