Skip to main content
Glama
enesjakozh

SQL Server Express MCP Server

by hanweg
OverviewInspectNewSchemaRelated ServersScore
Python
Remote
MIT License
4

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?

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 -
    5
    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
    2
    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 -
    3
    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