Skip to main content
Glama
enesjakozh

SQL Server Express MCP Server

by hanweg
GitHub
Python
MIT License
4
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

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
A
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.

  1. Prerrequisitos
    1. Instalación
      1. Uso con Claude Desktop
        1. Opciones de autenticación
      2. Características
        1. Herramientas

      Related Resources

      Related MCP Servers

      • 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 -

      • 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
        MIT License

      • MSSQL MCP Server

        NakiriYuuzu
        A
        security
        A
        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
        26
        MIT License
        • Linux
        • Apple

      • NLSQL MCP Server

        tushar-badhwar
        -
        security
        A
        license
        -
        quality
        An MCP (Model Context Protocol) server that exposes natural language to SQL functionality, allowing any MCP-compatible client to convert plain English questions into SQL queries for database interaction using AI.
        Last updated -
        1
        MIT License

      View all related MCP servers

      Appeared in Searches

      New MCP Servers

      MCP directory API

      We provide all the information about MCP servers via our MCP API.

      curl -X GET 'https://glama.ai/api/mcp/v1/servers/hanweg/mcp-sqlexpress'

      If you have feedback or need assistance with the MCP directory API, please join our Discord server