jexinsam/mssql_mcp_server

开发工具

本页由 AI 翻译，技术细节请以原文为准。查看原文

60 stars 29 forks 质量 83 趋势 21MIT

Repository Install

jexinsam/mssql_mcp_server 是一个从 https://github.com/jexinsam/mssql_mcp_server. 导入的 MCP 服务器候选

概览

jexinsam/mssql_mcp_server 是一个从 https://github.com/jexinsam/mssql_mcp_server. 导入的 MCP 服务器候选

概述（AI 翻译）

MSSQL MCP 服务器是一个模型上下文协议（MCP）服务器，能够与**Microsoft SQL Server（MSSQL）**数据库进行安全且结构化的交互。它允许AI助手：

列出可用表格
阅读表格内容
以受控访问方式执行SQL查询

基于 MCP SDK v2（2026-07-28 规范），支持 stdio 和 可流式 HTTP 传输。

特色

通过环境变量保护MSSQL数据库访问
SQL注入保护带标识符验证
只读写工具，带有相应的MCP注释
通过可信连接支持Windows认证
双重传输 — stdio（默认）和HTTP
Docker 支持，使用预配置的 ODBC 驱动程序
用于监控查询和操作的全面日志

安装

配置

设置以下环境变量以配置数据库访问：

可用工具

工具	说明	注释
`list_tables`	列出数据库中的所有表	只读，幂等
`query_sql`	执行只读SELECT查询	唯读，幂等

本页由 AI 翻译，技术细节请以原文为准。

README

以下为原文 README 节选，完整内容请查看原文。

MSSQL MCP Server

MSSQL MCP Server is a Model Context Protocol (MCP) server that enables secure and structured interaction with Microsoft SQL Server (MSSQL) databases. It allows AI assistants to:

List available tables
Read table contents
Execute SQL queries with controlled access

Built on MCP SDK v2 (2026-07-28 spec) with support for both stdio and Streamable HTTP transports.

Features

Secure MSSQL Database Access through environment variables
SQL Injection Protection with identifier validation
Read-Only & Write Tools with appropriate MCP annotations
Windows Authentication support via Trusted Connection
Dual Transport — stdio (default) and HTTP
Docker Support with pre-configured ODBC drivers
Comprehensive Logging for monitoring queries and operations

Installation

pip install mssql-mcp-server

Configuration

Set the following environment variables to configure database access:

# Required
MSSQL_DATABASE=your_database

# Authentication (choose one):
# Option 1: SQL Server Authentication
MSSQL_USER=your_username
MSSQL_PASSWORD=your_password

# Option 2: Windows / Kerberos Authentication
Trusted_Connection=yes

# Optional
MSSQL_HOST=localhost           # or use MSSQL_SERVER
MSSQL_DRIVER=SQL Server        # default driver
TrustServerCertificate=no      # default: no (set to yes for self-signed certs)
MCP_TRANSPORT=stdio            # or "streamable-http" for Streamable HTTP

Available Tools

Tool	Description	Annotations
`list_tables`	List all tables in the database	Read-only, Idempotent
`query_sql`	Execute read-only SELECT queries	Read-only, Idempotent
`execute_sql`	Execute any SQL statement (SELECT, INSERT, UPDATE, DELETE, DDL)	Destructive

Usage

With Claude Desktop

Add this configuration to claude_desktop_config.json:

{
  "mcpServers": {
    "mssql": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/mssql_mcp_server",
        "run",
        "mssql_mcp_server"
      ],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database"
      }
    }
  }
}

With Cursor IDE

Add this to your .cursor/mcp.json:

{
  "mcpServers": {
    "mssql": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/mssql_mcp_server",
        "run",
        "mssql_mcp_server"
      ],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database"
      }
    }
  }
}

With pip install (global)

{
  "mcpServers": {
    "mssql": {
      "command": "mssql_mcp_server",
      "env": {

在 GitHub 查看完整 README

安装

docker run -e MSSQL_HOST=host.docker.internal \

新手？先看 mcpskill.org 教程 →

配置

{
  "mcpServers": {
    "mssql": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/mssql_mcp_server",
        "run",
        "mssql_mcp_server"
      ],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database"
      }
    }
  }
}