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

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

Salesforce MCP Server
tsmztech
A
security
A
license
A
quality
An MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.
Last updated -
7
87
15
TypeScript
MIT License
Salesforce MCP Server
SurajAdsul
A
security
A
license
A
quality
An MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.
Last updated -
7
18
4
TypeScript
MIT License
MSSQL MCP Server
daobataotie
-
security
A
license
-
quality
Provides database interaction and business intelligence capabilities, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos for Microsoft SQL Server databases.
Last updated -
29
Python
MIT License
Database Tools for Claude AI
elber-code
A
security
F
license
A
quality
MCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.
Last updated -
1
6
3
JavaScript

View all related MCP servers

SQL Server Express MCP Server