SQL Server Express Management Utility (MCP Server)

This specific MCP server implementation is engineered for seamless connectivity and operations against Microsoft SQL Server Express installations. It comprehensively supports both Windows Integrated Security and standard SQL Server username/password authentication methods.

Requirements Checklist

• A functional Python runtime environment (version 3.10 or newer).
• The requisite Microsoft ODBC Driver 18 specifically compiled for SQL Server.
• Access to a running SQL Server instance with necessary operational permissions granted.

Deployment Steps

Clone the repository source code.

cd mcp-sqlexpress

# Environment setup using 'uv'
uv venv
.venv\Scripts\activate

# Install package in editable mode
uv pip install --editable .

Integration with Claude Desktop Environment

Configure your claude_desktop_config.json as follows to enable the service:

{
    "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 Modalities

To utilize Windows Authentication: - Specify --auth windows - Mandate --trusted-connection yes

To utilize SQL Server Credential Authentication: - Specify --auth sql - Supply required --username and --password parameters.

Operational Capabilities

Exposed Functions

• get_allowed_databases: Retrieves the roster of accessible databases permitted by configuration.
• read_query: Facilitates the execution of read-only (SELECT) Structured Query Language statements.
• write_query: Permits transactional operations including INSERT, UPDATE, and DELETE commands.
• create_table: Functionality to instantiate new relational tables within the target database.
• list_tables: Provides an inventory of all existing tables within the active database context.
• describe_table: Renders the structural definition (schema) for a specified table.