microsoft-sql-server-mcp-server-by-cdata

Name: microsoft-sql-server-mcp-server-by-cdata
Author: CDataSoftware

@CDataSoftware

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

基本信息

分类

数据库

许可证

MIT license

运行时

java

传输方式

stdio

发布者

CDataSoftware

提交者

Jerod Johnson

配置

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

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

工具

未检测到工具

工具是从 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)

FAQ from microsoft-sql-server-mcp-server-by-cdata

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 服务器

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245