Microsoft Sql Server MCP Server By Cdata

@CDataSoftware

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

CDataSoftware

提交者

Jerod Johnson

关于 Microsoft Sql Server MCP Server By Cdata

This read-only MCP Server allows you to connect to Microsoft SQL Server data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at

Microsoft Sql Server MCP Server By Cdata 配置

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

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

Microsoft Sql Server MCP Server By Cdata 工具

工具列表暂未提供

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

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

概览

What is microsoft-sql-server-mcp-server-by-cdata?

A read-only MCP server built by CData that allows LLMs (like Claude Desktop) to query live Microsoft SQL Server data via the CData JDBC Driver for Microsoft SQL Server using natural language. It wraps the JDBC driver into a simple MCP interface, so users can retrieve live information without writing SQL.

How to use microsoft-sql-server-mcp-server-by-cdata?

Clone the repository, build with mvn clean install, download and install the CData JDBC Driver for Microsoft SQL Server, license the driver, and configure a .prp file with your JDBC connection string. Then add the server to your MCP client’s configuration (e.g., claude_desktop_config.json) using the built JAR and .prp file, and restart the client.

Key features of microsoft-sql-server-mcp-server-by-cdata

Read-only access to Microsoft SQL Server data via MCP
Powered by the CData JDBC Driver for Microsoft SQL Server
Exposes get_tables, get_columns, and run_query tools
No SQL needed — natural language queries only
Uses stdio transport (client must run on the same machine)

Use cases of microsoft-sql-server-mcp-server-by-cdata

Asking natural‑language questions about SQL Server data in Claude Desktop
Correlating business metrics (e.g., closed opportunities by account industry)
Checking operational counts (e.g., open tickets, calendar events)

常见问题

Is this server read‑only?

Yes. This project explicitly builds a read‑only MCP server. For full read, write, update, and delete support, CData offers a separate free beta MCP Server for Microsoft SQL Server.

What are the prerequisites?

Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Microsoft SQL Server (requires a license key or trial). The client must run on the same machine as the server because stdio transport is used.

How do I connect to Microsoft SQL Server?

You configure a `.prp` file with a JDBC connection string — obtained from the CData JDBC Driver’s connection‑string utility — along with the driver path, driver class, and a server prefix/name. An empty `Tables` field exposes all tables.

What tools does the server expose?

Three tools: `{servername}_get_tables` (list available tables), `{servername}_get_columns` (list columns for a table), and `{servername}_run_query` (execute a SQL SELECT query). All output is in CSV format.

Where does the data live and how is it accessed?

The server queries live data from Microsoft SQL Server in

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

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K