Skip to main content
Glama
enesjakozh

SQL Server Express MCP Server

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

SQL Server Express MCP 服务器

用于与 Microsoft SQL Server Express 交互的 MCP 服务器。支持 Windows 和 SQL Server 身份验证。

先决条件

  • Python 3.10 或更高版本
  • 适用于 SQL Server 的 Microsoft ODBC 驱动程序 18
  • 具有适当权限的 SQL Server 实例

安装

克隆此 repo

cd mcp-sqlexpress # Create and activate virtual environment uv venv .venv\Scripts\activate # Install dependencies uv pip install --editable .

与 Claude Desktop 一起使用

添加到您的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" ] } } }

身份验证选项

对于 Windows 身份验证：

  • 设置--auth windows
  • 设置--trusted-connection yes

对于 SQL Server 身份验证：

  • 设置--auth sql
  • 添加--username和--password

特征

工具

  • get_allowed_databases ：获取允许访问的数据库列表
  • read_query ：执行 SELECT 查询
  • write_query ：执行 INSERT/UPDATE/DELETE 查询
  • create_table ：创建新表
  • list_tables ：列出数据库中的所有表
  • describe_table ：显示表架构

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.

促进与 Microsoft SQL Server Express 的交互，支持通过自然语言 MCP 命令进行查询、表管理和模式检查等数据库操作。

  1. 先决条件
    1. 安装
      1. 与 Claude Desktop 一起使用
        1. 身份验证选项
      2. 特征
        1. 工具

      Related Resources

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

      • 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

      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