MsSqlMCP

MsSqlMCP is a Model Context Protocol server designed to query and retrieve information from SQL Server database schemas, enabling access to data structures such as tables, columns, and relationships. It is configured to work with Visual Studio Code and requires .NET 9 and SQL for operation.

MsSqlMCP

MCP to query SQL Server database schema, such as tables, columns, and relationships

Prerequisites:

.NET 9
SQL

Configuration

To configure Copilot in Visual Studio Code, add the MCP server configuration to the settings.json file:

"mcp": {
    "inputs": [],
    "servers": {
        "MsSqlMCP": {
            "type": "stdio",
            "command": "dotnet",
            "args": [
                "run",
                "--project",
                "c:\\{path of repository}\\MsSqlMCP\\MsSqlMCP.csproj"
            ]
        }
    }
}