MSSQL MCP Server

Name: MSSQL MCP Server
Author: JexinSam

@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 服务器

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

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