# SSAS MCP Server

> SSAS MCP Server — dbdave-mssas-mcp-server. Use this tool when you need to query and analyze data from SQL Server Analysis Services, solving problems related to business intelligence and data analysis. It provides read-only access to multidimensional cubes via MDX and tabular models via DAX, using Windows Integrated Security for authentication. Ideal for use cases requiring secure and efficient data querying and reporting from SSAS models.

Canonical page: https://skillsregistry.net/skills/dbdave-mssas-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/dbdave-mssas-mcp-server

## Description

A read-only MCP server for querying SQL Server Analysis Services (multidimensional cubes via MDX and tabular models via DAX) using Windows Integrated Security.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **Last scanned:** 2026-09-03

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-03

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/afnmcu4564)
- **Repository:** <https://github.com/dbdave/mssas_mcp_server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "dbdave-mssas-mcp-server"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/dbdave-mssas-mcp-server` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/dbdave-mssas-mcp-server/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt
