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"
            ]
        }
    }
}