mssql-mcp

Overview

mssql-mcp is a well-architected .NET implementation of the Model Context Protocol that enables AI agents to interact with Microsoft SQL Server databases. It uses Akka.NET for internal coordination and the official MCP C# SDK for protocol compliance. The server provides three core tools: execute_sql for running queries, list_tables for discovering tables, and list_schemas for exploring database structure. It features comprehensive error handling, table formatting for AI consumption, and Docker support for easy deployment.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• execute_sql

  Execute any SQL query against the database

  Try:Show me all the tables in the databaseTry:Find all users created in the last 30 daysTry:Create a new customer record
• list_tables

  List all tables with schema, name, type, and row count

  Try:Show me all the tables in the databaseTry:List all tables in the sales schemaTry:How many tables are in this database?
• list_schemas

  List all available schemas/databases in the SQL Server instance

  Try:List all available databasesTry:What schemas are available?Try:Show me all databases in this SQL Server instance

Comparable tools

Installation

dotnet publish --os linux --arch x64 /t:PublishContainer
docker run -it --rm -e MSSQL_CONNECTION_STRING="Server=host.docker.internal;Database=MyDB;Trusted_Connection=true;" mssql-mcp:latest

/path/to/mssql-mcp/src/MSSQL.MCP/bin/Release/net9.0/MSSQL.MCP

{
  "mcpServers": {
    "mssql": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "MSSQL_CONNECTION_STRING",
        "mssql-mcp:latest"
      ],
      "env": {
        "MSSQL_CONNECTION_STRING": "Server=host.docker.internal,1533; Database=MyDb; User Id=myUser; Password=My(!)Password;TrustServerCertificate=true;"
      }
    }
  }
}

FAQ

What SQL operations are supported?

The server supports SELECT, INSERT, UPDATE, DELETE, and DDL operations. It also provides schema discovery capabilities.

How do I handle Docker networking issues on different platforms?

On Windows and macOS, use 'host.docker.internal'. On Linux, either use '--network host' or add '--add-host=host.docker.internal:host-gateway'. The README provides detailed platform-specific guidance.

Compare mssql-mcp with