MCP Sqlexpress

🚀 Microsoft SQL Server Express MCP Server

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

🚀 Quick Start

This MCP server facilitates interaction with Microsoft SQL Server Express, offering support for both Windows and SQL Server authentication methods.

✨ Features

Tools

• get_allowed_databases: Retrieve the list of allowed databases.
• read_query: Execute SELECT queries.
• write_query: Execute INSERT/UPDATE/DELETE queries.
• create_table: Create a new table.
• list_tables: List all tables in the database.
• describe_table: Display the table structure.

📦 Installation

Prerequisites

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

Steps

Clone this repository:

cd mcp-sqlexpress

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

# Install dependencies
uv pip install --editable .

💻 Usage Examples

Using with Claude Desktop

Add the following content to 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

Windows Authentication

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

SQL Server Authentication

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