MSSQL MCP Server

@JexinSam

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

JexinSam

MSSQL MCP Server について

A Model Context Protocol (MCP) server facilitating secure interactions with MSSQL databases.

MSSQL MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mssql_mcp_server": {
      "command": "python",
      "args": [
        "-m",
        "mssql_mcp_server"
      ]
    }
  }
}

MSSQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MSSQL MCP Server?

MSSQL MCP Server is a Model Context Protocol (MCP) server that enables AI assistants to securely and interact with Microsoft SQL Server databases. It provides controlled access to list tables, read table contents, and execute SQL queries with error handling and logging.

How to use MSSQL MCP Server?

Install via pip install mssql-mcp-server, then configure database access using environment variables (MSSQL_HOST, MSSQL_USER, MSSQL_PASSWORD, etc.). It can be run as a standalone server with python -m mssql_mcp_server or integrated with Claude Desktop by adding a configuration block to claude_desktop_config.json.

Key features of MSSQL MCP Server

Secure MSSQL database access via environment variables
Controlled SQL query execution with error handling
Table listing and data retrieval capabilities
Comprehensive logging for monitoring queries
Supports both standalone and Claude Desktop usage

Use cases of MSSQL MCP Server

AI assistants exploring database schemas and reading table data
Executing read-only SQL queries with enforced permissions
Integrating MSSQL database access into MCP‑compatible applications
Auditing database interactions through built‑in logging

よくある質問

How do I install MSSQL MCP Server?

Install it with `pip install mssql-mcp-server`. For development, clone the repository, set up a virtual environment, and install `requirements-dev.txt`.

What environment variables are required?

You must set `MSSQL_DRIVER`, `MSSQL_HOST`, `MSSQL_USER`, `MSSQL_PASSWORD`, and `MSSQL_DATABASE`. Optionally, `TrustServerCertificate` and `Trusted_Connection` can be set.

Is MSSQL MCP Server secure?

The README emphasizes security: use a dedicated MSSQL user with minimal privileges, never use root credentials, restrict database access to necessary operations, enable logging and auditing, and regularly review permissions. See the included Security Configuration Guide for details.

What runtime dependencies does it have?

It requires Python and the `mssql-mcp-server` package. For development, additional dependencies for testing (e.g., `pytest`) are listed in `requirements-dev.txt`.

How can I run MSSQL MCP Server with Claude Desktop?

Add an `mssql` entry to your `claude_desktop_config.json` under `mcpServers`, specifying the `uv` command with the path to the server directory and the required environment variables.

「データベース」の他のコンテンツ

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note