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

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

MySQL MCP Server

designcomputer

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

1.3K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

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.