SQL Server Express MCP Server

An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication.

Prerequisites

Python 3.10 or higher
Microsoft ODBC Driver 18 for SQL Server
SQL Server instance with appropriate permissions

Installation

Clone this repo

cd mcp-sqlexpress

# Create and activate virtual environment
uv venv
.venv\Scripts\activate

# Install dependencies
uv pip install --editable .

Usage with Claude Desktop

Add to your claude_desktop_config.json:

{
    "mcpServers": {
        "sqlexpress": {
            "command": "uv",
            "args": [
                "--directory",
                "PATH\\TO\\PROJECT\\mcp-sqlexpress",
                "run",
                "mcp-server-sqlexpress",
                "--server",
                "server\\instance",
                "--auth",
                "windows",
                "--trusted-connection",
                "yes",
                "--trust-server-certificate",
                "yes",
                "--allowed-databases",
                "database1,database2"
            ]
        }
    }
}

Authentication Options

For Windows Authentication:

Set --auth windows
Set --trusted-connection yes

For SQL Server Authentication:

Set --auth sql
Add --username and --password

Features

Tools

get_allowed_databases: Get list of databases that are allowed to be accessed
read_query: Execute SELECT queries
write_query: Execute INSERT/UPDATE/DELETE queries
create_table: Create new tables
list_tables: List all tables in database
describe_table: Show table schema