Azure Synapse MCP Server by CData

Name: Azure Synapse MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 Azure Synapse MCP Server by CData

This read-only MCP Server allows you to connect to Azure Synapse data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

#azure-synapse #mcp-server #data-access

基本信息

分类

云与基础设施

许可证

MIT

运行时

java

传输方式

stdio

发布者

CDataSoftware

提交者

Cameron Leblanc

配置

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

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

工具

未检测到工具

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

概览

What is Azure Synapse MCP Server by CData?

A read-only MCP server that allows LLMs (like Claude Desktop) to query live Azure Synapse data via natural language questions, powered by the CData JDBC Driver for Azure Synapse.

How to use Azure Synapse MCP Server by CData?

Clone the repo, build with Maven, install and license the CData JDBC Driver, create a .prp file with connection properties, then configure Claude Desktop’s claude_desktop_config.json to point to the built JAR and .prp file. Run or refresh Claude Desktop to use the tools.

Key features of Azure Synapse MCP Server by CData

Query live Azure Synapse data using natural language.
Provides tools: get_tables, get_columns, run_query.
Built on the CData JDBC Driver for Azure Synapse.
Local, read-only MCP server via stdio transport.
Supports all tables by default or explicit table selection.

Use cases of Azure Synapse MCP Server by CData

Ask LLMs about Azure Synapse data trends without writing SQL.
Retrieve table and column metadata for data exploration.
Run SQL SELECT queries through an AI assistant interface.

FAQ from Azure Synapse MCP Server by CData

Is this server read-only or does it support write/update/delete?

The README states this project builds a local, read-only MCP server. For full CRUD capabilities, see the CData MCP Server for Azure Synapse.

What runtime requirements are needed?

You need Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Azure Synapse (requires installation and licensing). The driver is not bundled.