SQL Server Analysis Services MCP Server by CData

Name: SQL Server Analysis Services MCP Server by CData
Author: CDataSoftware

@CDataSoftware

About SQL Server Analysis Services MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for SQL Server Analysis Services (beta)](https://www.cdata.com/download/download.aspx?sku=FYZK-V&type=beta).

#sql-server #mcp-server #data-access

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\ssas.prp"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is SQL Server Analysis Services MCP Server by CData?

SQL Server Analysis Services MCP Server by CData is a read-only Model Context Protocol server that lets AI assistants like Claude Desktop query live data from SQL Server Analysis Services using natural language. It wraps the CData JDBC Driver for SQL Server Analysis Services and exposes the data as relational SQL models.

How to use SQL Server Analysis Services MCP Server by CData?

Clone the repository, build with mvn clean install, install and license the CData JDBC Driver for SQL Server Analysis Services, create a .prp file with your connection details, and configure the server in Claude Desktop’s claude_desktop_config.json. Run the server with java -jar CDataMCP-jar-with-dependencies.jar /path/to/ssas.prp. The server communicates via stdio and must run on the same machine as the client.

Key features of SQL Server Analysis Services MCP Server by CData

Read-only access to SQL Server Analysis Services data
Natural language querying via AI assistants
Built on the CData JDBC Driver for SSAS
Exposes SSAS cubes as relational tables
Tools: get_tables, get_columns, run_query
Uses stdio transport for local execution

Use cases of SQL Server Analysis Services MCP Server by CData

Ask "What is the correlation between closed won opportunities and account industry?"
Query “How many open tickets do I have in the SUPPORT project?”
Retrieve calendar events or sales data without writing SQL
Enable LLMs to explore SSAS cubes through natural language

FAQ from SQL Server Analysis Services MCP Server by CData

Is this server read-only or does it support write operations?

This server is read-only. For full read, write, update, and delete capabilities, use the free CData MCP Server for SQL Server Analysis Services (beta) linked in the README.

What are the runtime requirements?

You need Java (to run the JAR), the CData JDBC Driver for SQL Server Analysis Services (trial or licensed), and Maven to build the project.

Where does the data live and how is it accessed?

Data stays in the original SQL Server Analysis Services instance. The server connects live via the JDBC driver using the connection string you configure in the .prp file.

What transport does this server use?

It uses stdio transport, meaning it can only be used with clients running on the same machine as the server.

How do I license the CData JDBC Driver?

Navigate to the driver’s lib folder and run java -jar cdata.jdbc.ssas.jar --license. Enter your name, email, and “TRIAL” or a purchased license key.