广告合作
MCP.so
登录
S

SQL Server Analysis Services MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 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

SQL Server Analysis Services MCP Server by CData 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

SQL Server Analysis Services MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

1

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.

2

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.

3

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.

4

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.

5

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.

评论

数据库 分类下的更多 MCP 服务器

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Elasticsearch MCP Server

elastic

685

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531
广告合作