mcp-sqlexpress

View on GitHub

MCP server for interacting with SQLExpress

4 stars PythonServers & Infrastructure Updated Jun 30, 2025

Documentation

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

powershell

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`:

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

Frequently asked questions

What is mcp-sqlexpress?

mcp-sqlexpress is MCP server for interacting with SQLExpress

How do I install mcp-sqlexpress?

Open the GitHub repository and follow its README. Most MCP servers are added to your client's MCP config, then called by your agent.

Is mcp-sqlexpress open source?

Yes — it is hosted on GitHub at https://github.com/hanweg/mcp-sqlexpress and has 4 stars.

Related MCP tools

damn-vulnerable-mcp-server

Damn Vulnerable MCP Server Python-based implementation. Trusted by 1200+ developers. Trusted by 1200+ developers. Trusted by 1200+ developers.

1,209 Python

mysql_mcp_server

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases Python-based implementation. Trusted by 900+ developers.

964 Python

aimcpmodel-context-protocol+1

supabase-mcp-server

Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning...

805 Python

cursormodel-context-protocolsupabase+1