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

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

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

Related Resources

Reddit Discussion about this server

Related MCP Servers

MSSQL MCP Server
c0h1b4
A
security
A
license
A
quality
Enables execution of SQL queries and management of Microsoft SQL Server database connections through the Model Context Protocol.
Last updated -
29
121
14
TypeScript
MIT License
MCP SQL Server
dennismartis
-
security
F
license
-
quality
A FastMCP server that provides natural language interaction with MS SQL databases, enabling users to query data, list tables, describe structures, and execute database operations through a conversational AI interface.
Last updated -
Python
Jewei MSSQL MCP Server
jeweis
-
security
A
license
-
quality
A FastMCP-based server that enables executing Microsoft SQL Server data queries and table structure queries through a standardized MCP protocol interface.
Last updated -
3
Python
MIT License
MSSQL MCP Server
NakiriYuuzu
A
security
F
license
A
quality
Enables interaction with Microsoft SQL Server databases through a Model Context Protocol interface, supporting database connections, switching between databases, and executing secure SELECT queries.
Last updated -
8
3
JavaScript

View all related MCP servers

SQL Server Express MCP Server