Skip to main content
Glama
enesjakozh
hanweg

SQL Server Express MCP Server

by hanweg
OverviewSchemaRelated ServersScoreDiscussions
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: MSSQL MCP Server

インストール

このリポジトリをクローンする

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

A
license - permissive license
Not graded
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • MSSQL MCP Server

    jensenloke
    F
    license
    Not graded
    quality
    D
    maintenance
    A Model Context Protocol server that provides comprehensive access to Microsoft SQL Server databases, enabling Language Models to inspect schemas, execute queries, manage database objects, and perform advanced database operations.
    8

  • 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,043
    1

  • MCP SQL Server

    fabriciofs
    A
    license
    Not graded
    quality
    F
    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.
    10
    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.
    746
    MIT

View all related MCP servers

Related MCP Connectors

View all MCP Connectors

Appeared in Searches

Latest Blog Posts

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