広告掲載
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.

コメント

「データベース」の他のコンテンツ

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

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.

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

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

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K
広告掲載