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

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

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