Azure Analysis Services MCP Server By Cdata

@CDataSoftware

代码仓库

基本信息

分类

云与基础设施

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 Azure 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 Azure Analysis Services (beta): https://www.cdata.com/download/download.aspx?sku=OAZK-V&type=beta

#azure #mcp-server #data-access

Azure 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\\azure-analysis-services.prp"
      ]
    }
  }
}

Azure Analysis Services MCP Server By Cdata 工具

工具列表暂未提供

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

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

概览

What is Azure Analysis Services Mcp Server By Cdata?

Azure Analysis Services Mcp Server By Cdata is a read-only MCP server that lets LLMs like Claude Desktop query live data from Azure Analysis Services using natural language. It wraps the CData JDBC Driver for Azure Analysis Services, which exposes Azure Analysis Services data as relational SQL models.

How to use Azure Analysis Services Mcp Server By Cdata?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Azure Analysis Services, create a .prp property file with your JDBC connection string, then configure your MCP client (e.g., Claude Desktop) to launch the JAR. The server uses stdio transport, so it must run on the same machine as the client.

Key features of Azure Analysis Services Mcp Server By Cdata

Read-only access to Azure Analysis Services data via MCP
Wraps the CData JDBC Driver for Azure Analysis Services
Exposes three tools: get_tables, get_columns, run_query
Allows LLMs to query data with natural language, no SQL required
MIT licensed and open-source

Use cases of Azure Analysis Services Mcp Server By Cdata

Let Claude Desktop answer business questions from Azure Analysis Services cubes
Analyze trends and correlations in Azure Analysis Services data without writing SQL
Retrieve live data from Azure Analysis Services for LLM‑powered assistants

常见问题

What does Azure Analysis Services Mcp Server By Cdata do?

It provides a read-only Model Context Protocol server that lets large language models query live data from Azure Analysis Services using natural language.

How is this different from the CData MCP Server for Azure Analysis Services (beta)?

This project is read-only and built from source. The free CData MCP Server (beta) supports full read, write, update, delete, and action capabilities with a simplified setup.

What are the runtime dependencies?

Java (to run the JAR), Maven (to build the project), and a licensed copy of the CData JDBC Driver for Azure Analysis Services. A trial license key (“TRIAL”) can be used for evaluation.

What transport does the server use?

It uses `stdio` transport, so the server must run on the same machine as the MCP client (e.g., Claude Desktop). No HTTP or WebSocket transport is available.

Where does the data live and what authentication is supported?

Data lives in Azure Analysis Services. The JDBC driver handles authentication (e.g., OAuth) via the connection string. The README shows using `InitiateOAuth=GETANDREFRESH` in the JDBC URL.