mcp sqlexpress

Local 2025-09-01 00:31:16 0
databases @hanweg/mcp-sqlexpress

Facilitates interaction with Microsoft SQL Server Express, supporting database operations such as querying, table management, and schema inspection via natural language MCP commands.

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
.venvScriptsactivate

# Install dependencies
uv pip install --editable .

Usage with Claude Desktop

Add to your claude_desktop_config.json:

{
    "mcpServers": {
        "sqlexpress": {
            "command": "uv",
            "args": [
                "--directory",
                "PATHTOPROJECTmcp-sqlexpress",
                "run",
                "mcp-server-sqlexpress",
                "--server",
                "serverinstance",
                "--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