MCP-SqlServer
3.3
If you are the rightful owner of MCP-SqlServer and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A MCP Server (STDIO) implementation in C# for LLM integration with SQL Server tested with Claude Desktop.
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
