MCP.so
ログイン

MSSQL MCP Server

@JexinSam

リポジトリ

MSSQL MCP Server について

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

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

JexinSam

設定

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

{
  "mcpServers": {
    "mssql_mcp_server": {
      "command": "python",
      "args": [
        "-m",
        "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

FAQ from MSSQL MCP Server

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.

コメント

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

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

Snowflake MCP Server

isaacwasserman

185

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569