a year ago
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
Overview
What is Microsoft SQL Server MCP Server By CData?
Microsoft SQL Server MCP Server By CData is a read-only Model Context Protocol (MCP) server designed to allow large language models (LLMs) to query live data from Microsoft SQL Server using natural language, without the need for SQL queries.
How to use Microsoft SQL Server MCP Server?
To use the MCP Server, clone the repository, build the server, install the CData JDBC Driver for Microsoft SQL Server, configure your connection, and create a configuration file for your AI client (e.g., Claude Desktop).
Key features of Microsoft SQL Server MCP Server?
- Provides a read-only interface for querying Microsoft SQL Server data.
- Allows LLMs to retrieve live information using natural language questions.
- Simplifies data access without requiring SQL knowledge.
Use cases of Microsoft SQL Server MCP Server?
- Querying live data from Microsoft SQL Server using natural language.
- Integrating with AI clients like Claude Desktop for data retrieval.
- Enabling data-driven decision-making through natural language queries.
FAQ from Microsoft SQL Server MCP Server?
- Can I write data using this MCP Server?
No, this server is read-only and does not support write operations.
- Is there a trial version available for the CData JDBC Driver?
Yes, a trial version of the CData JDBC Driver is available for download.
- What types of queries can I run?
You can ask natural language questions about the underlying data, and the server will interpret and execute the appropriate queries.
Server Config
{
"mcpServers": {
"sql": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
"PATH\\TO\\microsoft-sql-server.prp"
]
}
}
}