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

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

@CDataSoftware

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

Basic information

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"
      ]
    }
  }
}

Tools

No tools detected

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)

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.