SSAS MCP Server

Item: SSAS MCP Server
Rating: 71
Author: M8ven

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

→ dbdave/mssas_mcp_server · listed on glama

Is this your MCP?

Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find.

Install from

Glama

M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.

// key findings

✅

No credential exfiltration, no sensitive file access, no obfuscation

Static analysis found nothing flowing your secrets to unexpected places.

✅

Open source with a license and README

Anyone can audit the code, the license is declared, and the publisher documents what it does.

// required environment variables

This server reads these from process.env. You'll be asked to provide them before it can run.

configSSAS_ADOMD_DLL_DIR— no auto-detected Folder containing Microsoft.AnalysisServices.AdomdClient.dll

configSSAS_SERVER— yes — Host, host\instance, or an http(s)://.../msmdpump.dll URL

configSSAS_CATALOG— yes — SSAS database name

configSSAS_QUERY_TIMEOUT— no 60 Per-query timeout, seconds

configSSAS_ROW_LIMIT— no 10000 Hard cap on returned rows

configSSAS_DEFAULT_CUBE— no — Cube/model list_metadata uses when none is given

// full audit trail

The full breakdown of what we checked, the deductions that landed, the network hosts, the dependency advisories, and concrete fix guidance is available to verified publishers.

// improvement guidance — verified publishers only

We have 4 concrete improvements we can share with the publisher of this MCP. Each comes with specific guidance to raise the trust score.

// embed badge in your README

[![M8ven Score](https://m8ven.ai/badge/mcp/dbdave-mssas-mcp-server-1lf5p5)](https://m8ven.ai/mcp/dbdave-mssas-mcp-server-1lf5p5)

commit: ff2b1720e54f10c84fb55470c30029f3e1ee3a65

code hash: 67e970017b6c5c63dd2f0d816bbef598ebf7070ecef8301ea349c401d1562243

verified: 7/4/2026, 9:09:04 AM

view raw JSON →