MCP-SqlServer

by RodrigoPAml

16 stars
104 downloads
Not rated
GitHub

About

A MCP Server implementation in C# for LLM integration with SQL Server tested with Claude Desktop

Details

Author
RodrigoPAml
GitHub stars
16
Downloads
104
Categories
Database, AI

- HealthCheck tool to test SQL Server connectivity.
- GetSchema tool to list tables, schemas, columns, and types.
- Query tool to execute SQL queries and return JSON results.
- Logs server activity to mcp_server.log.
- Caution: the LLM can modify your database.
- Written in C# for .NET.

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name MCP-SqlServer
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Configure the connection string in the _env.database file, compile the project, then add the MCP server to your Claude Desktop configuration using dotnet run --project --no-build. Restart Claude Desktop to see the tools.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "mcp-sqlserver": {
            "database": {
                "command": "dotnet",
                "args": [
                    "run",
                    "--project",
                    "C:\\Users\\{USER}\\Desktop\\MCP-SqlServer",
                    "--no-build"
                ]
            }
        }
    }
}

McpServers

{
    "database": {
        "command": "dotnet",
        "args": [
            "run",
            "--project",
            "C:\\Users\\{USER}\\Desktop\\MCP-SqlServer",
            "--no-build"
        ]
    }
}

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

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.