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.

数据库分类下的更多 MCP 服务器

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.