Mcp Sqlserver
What is Mcp Sqlserver
MCP-SqlServer is a C# implementation of a MCP Server designed for integrating Large Language Models (LLMs) with Microsoft SQL Server, tested specifically with Claude Desktop.
Use cases
Use cases include checking database connectivity, retrieving schema information, executing read queries, and performing database modifications through LLMs.
How to use
To use MCP-SqlServer, fill in the connection string for your SQL Server in the env.database file, compile the project, configure MCP settings in Claude Desktop, and restart the application.
Key features
Key features include HealthCheck for verifying database connections, GetTablesWithColumnsAndTypes for retrieving table schemas, and a Query tool for executing SQL queries and returning results in JSON format.
Where to use
MCP-SqlServer is suitable for applications that require interaction between LLMs and SQL databases, particularly in data analysis, reporting, and automated database management.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Sqlserver
MCP-SqlServer is a C# implementation of a MCP Server designed for integrating Large Language Models (LLMs) with Microsoft SQL Server, tested specifically with Claude Desktop.
Use cases
Use cases include checking database connectivity, retrieving schema information, executing read queries, and performing database modifications through LLMs.
How to use
To use MCP-SqlServer, fill in the connection string for your SQL Server in the env.database file, compile the project, configure MCP settings in Claude Desktop, and restart the application.
Key features
Key features include HealthCheck for verifying database connections, GetTablesWithColumnsAndTypes for retrieving table schemas, and a Query tool for executing SQL queries and returning results in JSON format.
Where to use
MCP-SqlServer is suitable for applications that require interaction between LLMs and SQL databases, particularly in data analysis, reporting, and automated database management.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
MCP-SqlServer
A MCP Server (STDIO) implementation in C# for LLM integration with SQL Server tested with Claude Desktop
The server register logs into a mcp_server.log file
Caution, the LLM can modify your database
Tools
List of tools provided to the LLM
- HealthCheck: Tests if the Microsoft SQL Server Database connection is good and alive.
- GetSchema: Get a list of all tables with their respective schema, columns and types.
- Query: Execute a query into the Microsoft SQL Server database and return the result as a JSON.
Setup with Claude
- Fill the env.database with the connection string from your SQL Server
- Compile the project
- In the Claude Destkop Go File->Configurations->Developer and edit the MCP configuration (claude_desktop_config.json)
- Paste the json as:
{
"mcpServers": {
"database": {
"command": "dotnet",
"args": [
"run",
"--project",
"C:\\Users\\{USER}\\Desktop\\MCP-SqlServer",
"--no-build"
]
}
}
}- Restart Claude Desktop
Testing
Open Claude Desktop and if everything is configured well you should be able to see this
Click on the icon and you should be able to see the tools
Asking for connection check
Asking for schema/table informations
Asking for read query
Asking for modifications
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
