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

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.

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K
Advertise