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

CData's Model Context Protocol (MCP) Server for Microsoft SQL Server

:heavy_exclamation_mark: This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Microsoft SQL Server (beta).

Purpose

We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data Microsoft SQL Server supported by the CData JDBC Driver for Microsoft SQL Server.

CData JDBC Driver connects to Microsoft SQL Server by exposing them as relational SQL models.

This server wraps that driver and makes Microsoft SQL Server data available through a simple MCP interface, so LLMs can retrieve live information by asking natural language questions — no SQL required.

Setup Guide

1. Clone the repository:

   git clone https://github.com/cdatasoftware/microsoft-sql-server-mcp-server-by-cdata.git
   cd microsoft-sql-server-mcp-server-by-cdata
   

2. Build the server:

   mvn clean install
   

   This creates the JAR file: CDataMCP-jar-with-dependencies.jar
3. Download and install the CData JDBC Driver for Microsoft SQL Server: https://www.cdata.com/drivers/sql/download/jdbc
4. License the CData JDBC Driver:
   • Navigate to the lib folder in the installation directory, typically:
     • (Windows) C:\Program Files\CData\CData JDBC Driver for Microsoft SQL Server\
     • (Mac/Linux) /Applications/CData JDBC Driver for Microsoft SQL Server/
   • Run the command java -jar cdata.jdbc.sql.jar --license
   • Enter your name, email, and "TRIAL" (or your license key).
5. Configure your connection to the data source (Salesforce as an example):

   • Run the command java -jar cdata.jdbc.sql.jar to open the Connection String utility.

     

   • Configure the connection string and click "Test Connection"

     Note: If the data sources uses OAuth, you will need to authenticate in your browser.

   • Once successful, copy the connection string for use later.

6. Create a .prp file for your JDBC connection (e.g. microsoft-sql-server.prp) using the following properties and format:
   • Prefix - a prefix to be used for the tools exposed
   • ServerName - a name for your server
   • ServerVersion - a version for your server
   • DriverPath - the full path to the JAR file for your JDBC driver
   • DriverClass - the name of the JDBC Driver Class (e.g. cdata.jdbc.sql.SQLDriver)
   • JdbcUrl - the JDBC connection string to use with the CData JDBC Driver to connect to your data (copied from above)
   • Tables - leave blank to access all data, otherwise you can explicitly declare the tables you wish to create access for

     Prefix=sql
     ServerName=CDataSQL
     ServerVersion=1.0
     DriverPath=PATH\TO\cdata.jdbc.sql.jar
     DriverClass=cdata.jdbc.sql.SQLDriver
     JdbcUrl=jdbc:sql:InitiateOAuth=GETANDREFRESH;
     Tables=
     

Using the Server with Claude Desktop

1. Create the config file for Claude Desktop ( claude_desktop_config.json) to add the new MCP server, using the format below. If the file already exists, add the entry to the mcpServers in the config file.

   Windows

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

   **Linux/

... View full README on GitHub