Microsoft SQL Server MCP Server (v2)

A Model Context Protocol (MCP) server for secure SQL Server database access through Claude Desktop.

This is a fork of RichardHan/mssql_mcp_server (original copyright Dana K. Williams, MIT licensed), ported to the mcp 2.x on_*-handler server API and republished under a new package name so it can be installed independently of the original. See Credits below. No changes have been proposed back to the upstream repo.

Features

• 🔍 List database tables
• 📊 Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
• 🔐 Multiple authentication methods (SQL, Windows, Azure AD)
• 🏢 LocalDB and Azure SQL support
• 🔌 Custom port configuration

Quick Start

Install with Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "mssql": {
      "command": "uvx",
      "args": ["--from", "mssql-mcp-server-v2", "mssql_mcp_server"],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password"
      }
    }
  }
}

--from is required because the PyPI package name (mssql-mcp-server-v2) is different from the command it provides (mssql_mcp_server) — without it, uvx tries to fetch a package literally named mssql_mcp_server, which doesn't exist.

On Windows, use mssql_mcp_server.exe (with the .exe suffix) as the last arg instead of mssql_mcp_server:

"args": ["--from", "mssql-mcp-server-v2", "mssql_mcp_server.exe"],

Configuration

Basic SQL Authentication

MSSQL_SERVER=localhost          # Required
MSSQL_DATABASE=your_database    # Required
MSSQL_USER=your_username        # Required for SQL auth
MSSQL_PASSWORD=your_password    # Required for SQL auth

Windows Authentication

MSSQL_SERVER=localhost
MSSQL_DATABASE=your_database
MSSQL_WINDOWS_AUTH=true         # Use Windows credentials

Azure SQL Database

MSSQL_SERVER=your-server.database.windows.net
MSSQL_DATABASE=your_database
MSSQL_USER=your_username
MSSQL_PASSWORD=your_password
# Encryption is automatic for Azure

Optional Settings

MSSQL_PORT=1433                 # Custom port (default: 1433)
MSSQL_ENCRYPT=true              # Force encryption

Alternative Installation Methods

Using pip

pip install mssql-mcp-server-v2

Then in claude_desktop_config.json:

{
  "mcpServers": {
    "mssql": {
      "command": "python",
      "args": ["-m", "mssql_mcp_server"],
      "env": { ... }
    }
  }
}

Development

git clone https://github.com/SL33PiNg/mssql_mcp_server.git
cd mssql_mcp_server
pip install -e .

Requirements

Requires mcp>=2.0.0, which uses the constructor on_*-handler Server API (no @app.list_resources()-style decorators). If you're pinned to mcp<2 for another server, install this package in an isolated environment (e.g. via uvx --from mssql-mcp-server-v2 mssql_mcp_server, as above) rather than the same venv.

Security

• Create a dedicated SQL user with minimal permissions
• Never use admin/sa accounts
• Use Windows Authentication when possible
• Enable encryption for sensitive data

Credits

This project is a fork of RichardHan/mssql_mcp_server, originally licensed MIT under copyright Dana K. Williams (see LICENSE). All credit for the original design and implementation goes to them. This fork exists solely to port the server to the mcp 2.x server API and publish it under a distinct package name (mssql-mcp-server-v2) independent of the original, since the original package still targets mcp 1.x.

License

MIT