Skip to main content
Glama
Sign In
enesjakozh

SQL Server Express MCP Server

by hanweg
GitHub
Python
MIT License
1
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

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

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

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

      • 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

      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