Advertise
MCP.so
Sign In

Microsoft Sql Server MCP Server By Cdata

@CDataSoftware

Repository

Basic information

Category

Databases

License

MIT license

Transports

stdio

Author

CDataSoftware

Submitted by

Jerod Johnson

About 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 config

Add this server to your MCP-compatible client using the configuration below.

{
  "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 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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)

Frequently asked questions

1

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.

2

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.

3

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.

4

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.

5

Where does the data live and how is it accessed?

The server queries live data from Microsoft SQL Server in

Comments

More Databases MCP servers

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

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

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Advertise