home / mcp / microsoft sql server

Microsoft SQL Server

This read-only MCP Server allows you to connect to Microsoft SQL Server data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-microsoft-sql-server-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/Salesforce.prp"
      ]
    }
  }
}

You can query live Microsoft SQL Server data through a read-only MCP Server that bridges the CData JDBC Driver to an MCP client. This enables natural language questions to access your SQL data without writing SQL, while keeping changes restricted to read operations.

How to use

Once the MCP Server is running, your MCP client can use the built-in tools to read data from Microsoft SQL Server. You don’t need to craft SQL queries yourself; simply ask questions about your data and the agent will retrieve relevant results. Examples include asking about data correlations, counts of records meeting certain criteria, or listing calendar events and other records you care about.

How to install

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

```
mvn clean install
```

```
# Download the CData JDBC Driver for Microsoft SQL Server from the vendor site
# Follow the on-screen instructions to install the driver on your machine
```

```
# License the CData JDBC Driver
# Windows: java -jar cdata.jdbc.sql.jar --license
# Mac/Linux:  java -jar cdata.jdbc.sql.jar --license
# Enter your name, email, and TRIAL (or your license key)
```

```
# Configure your connection using the JDBC Driver's Connection String utility
java -jar cdata.jdbc.sql.jar
# Test the connection and copy the resulting JDBC URL for later use
```

```
# Create a properties file for the JDBC connection (example: microsoft-sql-server.prp)
# Fill in your details as shown below
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=
```

```
# Run the MCP Server using the generated .prp file (example uses Salesforce.prp name only as a placeholder)
jav a -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

Additional steps you may need

The server is designed to run on the same machine as the MCP client when using the stdio configuration. Ensure you have Java installed and that the paths in your configuration point to the correct JARs and .prp file.

Available tools

sql_get_tables

Retrieves a list of tables available in the data source. Output is in CSV format with column headers on the first line.

sql_get_columns

Retrieves a list of columns for a specified table. Output is in CSV format with column headers on the first line.

sql_run_query

Executes a SQL SELECT query against the connected Microsoft SQL Server data source.