Skip to main content
Glama
enesjakozh
hanweg

SQL Server Express MCP Server

by hanweg
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

SQL Server Express MCP 服务器

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

先决条件

  • Python 3.10 或更高版本

  • 适用于 SQL Server 的 Microsoft ODBC 驱动程序 18

  • 具有适当权限的 SQL Server 实例

Related MCP server: MCP 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 deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • MSSQL MCP Server

    Nirmal123K
    A
    license
    A
    quality
    Not graded
    maintenance
    Enables AI assistants to interact with both local SQL Server and Azure SQL Database through natural language, supporting queries, data manipulation, and schema operations with built-in security features.
    8
    3,879 npm
    1
    -

  • MCP SQL Server

    fabriciofs
    A
    license
    Not graded
    quality
    D
    maintenance
    An MCP server for Microsoft SQL Server integration that enables users to query, monitor, and analyze databases directly through Claude. It supports schema exploration, performance analysis, and optional write operations via natural language commands.
    5 npm
    1
    MIT

  • mssql-mcp

    av1choudharyy
    A
    license
    Not graded
    quality
    D
    maintenance
    An MCP server that enables interaction with Microsoft SQL Server instances using Windows or SQL Server authentication via native ODBC drivers. It allows users to execute SQL queries, list tables, and inspect schemas across multiple configured database environments through natural language.
    1,578 npm
    MIT

  • mcp-server-mssql

    TerraCo89
    A
    license
    B
    quality
    D
    maintenance
    Enables AI agents to interact with Microsoft SQL Server databases via MCP, supporting table listing, schema retrieval, and CRUD operations.
    3
    1
    MIT

Appeared in Searches