Servidor MCP de SQL Server Express

Un servidor MCP para interactuar con Microsoft SQL Server Express. Compatible con la autenticación de Windows y SQL Server.

Prerrequisitos

Python 3.10 o superior
Controlador ODBC 18 de Microsoft para SQL Server
Instancia de SQL Server con los permisos adecuados

Instalación

Clonar este repositorio

cd mcp-sqlexpress

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

# Install dependencies
uv pip install --editable .

Uso con Claude Desktop

Añade a tu 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"
            ]
        }
    }
}

Opciones de autenticación

Para la autenticación de Windows:

Establecer --auth windows
Establecer --trusted-connection yes

Para la autenticación de SQL Server:

Establecer --auth sql
Agregue --username y --password

Características

Herramientas

get_allowed_databases : Obtener la lista de bases de datos a las que se puede acceder
read_query : Ejecutar consultas SELECT
write_query : Ejecutar consultas INSERTAR/ACTUALIZAR/ELIMINAR
create_table : Crea nuevas tablas
list_tables : enumera todas las tablas de la base de datos
describe_table : Mostrar el esquema de la tabla

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.

Facilita la interacción con Microsoft SQL Server Express, soportando operaciones de base de datos como consultas, administración de tablas e inspección de esquemas a través de comandos MCP en lenguaje natural.

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