Microsoft SQL Server MCP Server
by CData Software
This project builds a read-only MCP Server for Microsoft SQL Server, allowing LLMs to query live data. It leverages the CData JDBC Driver to expose Microsoft SQL Server as relational SQL models through a simple MCP interface.
Last updated: N/A
What is Microsoft SQL Server MCP Server?
The CData MCP Server for Microsoft SQL Server is a read-only server that enables Large Language Models (LLMs) like Claude Desktop to query live data from Microsoft SQL Server. It uses the CData JDBC Driver to expose Microsoft SQL Server data as relational SQL models and provides a simple MCP interface for LLMs to retrieve information using natural language questions.
How to use Microsoft SQL Server MCP Server?
To use the server, you need to clone the repository, build the server using Maven, download and license the CData JDBC Driver for Microsoft SQL Server, configure your connection to the data source using the Connection String utility, create a .prp file with connection properties, and configure your client (e.g., Claude Desktop) to use the new MCP server.
Key features of Microsoft SQL Server MCP Server
Read-only access to Microsoft SQL Server data
MCP interface for LLM integration
Leverages CData JDBC Driver for SQL Server
Allows querying data using natural language
Simple setup and configuration
Use cases of Microsoft SQL Server MCP Server
Enabling LLMs to answer questions about Microsoft SQL Server data
Integrating Microsoft SQL Server data into AI-powered applications
Providing a natural language interface to Microsoft SQL Server data
Automating data retrieval from Microsoft SQL Server using LLMs
FAQ from Microsoft SQL Server MCP Server
How do I configure the connection to my Microsoft SQL Server database?
How do I configure the connection to my Microsoft SQL Server database?
Use the CData JDBC Driver's Connection String utility to create a connection string and then add it to the .prp file.
What if I cannot see the CData MCP Server in Claude Desktop?
What if I cannot see the CData MCP Server in Claude Desktop?
Ensure that you have fully quit Claude Desktop and restarted it. Also, verify that the configuration file is correctly placed and formatted.
Can I use this server for write operations?
Can I use this server for write operations?
No, this is a read-only MCP server. For read, write, update, delete, and action capabilities, consider using the CData MCP Server for Microsoft SQL Server (beta).
What if Claude Desktop is unable to retrieve data?
What if Claude Desktop is unable to retrieve data?
Double-check your connection configuration and ensure that the connection string in the .prp file is correct.
Where can I get help if I'm having trouble connecting to my data source?
Where can I get help if I'm having trouble connecting to my data source?
Contact the CData Support Team or join the CData Community for assistance.