D
daobataotie/mssql-mcp
mssql mcp server
在 GitHub 查看 ↗链接已于 2026-11-12 核查 · HTTP 200 · 打开的是厂商自己的官网
安装与配置
客户端配置（取自该仓库的安装命令）
{
"mcpServers": {
"daobataotie-mssql-mcp": {
"command": "npx",
"args": ["-y", "@modelcontextprotocol/inspector"]
}
}
}解析自我们于 2026-11-05 抓取的该仓库 README；我们未执行过。
command/args 来自仓库写明的安装命令；不确定时请以该项目 README 为准。
VS Code（.vscode/mcp.json —— 键名是 servers）
{
"servers": {
"daobataotie-mssql-mcp": {
"command": "npx",
"args": ["-y", "@modelcontextprotocol/inspector"]
}
}
}VS Code 顶层键是 <code>servers</code>，其余与上面那份相同。
Claude Code（命令行）
claude mcp add --transport stdio daobataotie-mssql-mcp -- npx -y @modelcontextprotocol/inspector
Claude Code 不收 JSON 文件，用这条命令直接加。
配置项的键名以你的客户端为准：客户端与 CLI
- 来源明细
- 收录自 abordage/awesome-mcp 榜单（我们从中收集的条目之一） · 条目类型：MCP 服务
- 收录与活跃
- 收录于 2026-11-05 · 最近见到 2026-11-14 · 共见到 10 次 · 被 10 个来源列出
- 评分构成
- 综合分 1,003 · 10 个来源 · mcp
- 安装
npx -y @modelcontextprotocol/inspector
常见问题（答案都来自我们的记录）
怎么安装？
该仓库给出的安装命令是
npx -y @modelcontextprotocol/inspector。我们的记录里它是仓库自己提供的；不保证在你的客户端上直接可用。它适合谁 / 用来做什么？
我们把它归在这些标签下: MCP 服务。标签来自条目自身，不是我们强加的分类。
谁维护它、还在更新吗？
我们收录于 2026-11-05；最近见到 2026-11-14。这里没有"官方认证"或"质量评级"——我们只记录来源与时间。
# MSSQL MCP Server
以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →
English | 中文
## Overview
MSSQL MCP Server, provides database interaction and business intelligence capabilities. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Refer to the official website's SQLite for modifications to adapt to MSSQL.
Built on the official MCP Python SDK (FastMCP), supporting the MCP 2025-06-18 specification: structured tool output (structuredContent), tool annotations, resource templates, and elicitation-based write confirmation.
Highlights:
Multi-database — mount dev/staging/prod connections in one server; every tool takes an optional database parameter, each connection with its own readonly / querytimeout / maxrows / confirmwrites settings
Stored procedures — list signatures and execute procedures with full multi-result-set harvesting
Resource templates — schema://{database}/{schema}/{table} serves table structures on demand without burning tool-schema tokens every turn
Safety guardrails — SQL whitelisting, read-only mode, row limits, query timeouts, optional elicitation confirmation before writes
## Components
readquery
Execute SELECT / WITH queries with structured output (columns / rows / rowcount / truncated), limited by maxrows
writequery
Execute INSERT, UPDATE, DELETE or MERGE queries, returns affected row count
createtable
Create new tables in the database
listtables
Get a list of all tables in the database (schema + table name)
listviews
Get a list of all views in the database
describetable
View full schema for a specific table (type, nullable, default, primary key, identity, foreign keys, indexes)
listdatabases
List configured database connections (name, readonly, isdefault)
listprocedures
List stored procedures with parameter signatures
executeprocedure
Execute a stored procedure (supports multiple result sets)
appendinsight
Add new business insights to the memo resource
## Resources
memo://insights — a living business-insights memo, updated in real time via appendinsight
schema://{schema}/{table} — table structure of the default database (JSON: columns / PK / identity / FKs / indexes)
schema://{database}/{schema}/{table} — table structure of a named database connection
Resource templates are fetched on demand: unlike tool schemas they are not resent to the LLM every turn, which keeps long conversations lean.
## Security
All SQL goes through static validation before execution:
readquery only accepts a single SELECT / WITH statement and rejects any write or EXEC keyword (blocks e.g. WITH c AS (...) DELETE FROM t)
writequery uses a whitelist (INSERT / UPDATE / DELETE / MERGE only); EXEC, DROP, TRUNCATE, ALTER are rejected
Multi-statement batches (separated by ;) are rejected
trustedconnection: true switches to Windows integrated auth (the connection string uses TrustedConnection=yes, no username/password needed); false keeps the configured SQL account login
readonly: true disables all write operations, including stored procedures (they are black boxes that may write)
Stored procedure names are strictly validated as 1–3 dotted identifier parts before being embedded into {CALL ...}
Results are truncated at maxrows rows; queries are aborted after querytimeout seconds
## Overview
MSSQL MCP Server, provides database interaction and business intelligence capabilities. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Refer to the official website's SQLite for modifications to adapt to MSSQL.
Built on the official MCP Python SDK (FastMCP), supporting the MCP 2025-06-18 specification: structured tool output (structuredContent), tool annotations, resource templates, and elicitation-based write confirmation.
Highlights:
Multi-database — mount dev/staging/prod connections in one server; every tool takes an optional database parameter, each connection with its own readonly / querytimeout / maxrows / confirmwrites settings
Stored procedures — list signatures and execute procedures with full multi-result-set harvesting
Resource templates — schema://{database}/{schema}/{table} serves table structures on demand without burning tool-schema tokens every turn
Safety guardrails — SQL whitelisting, read-only mode, row limits, query timeouts, optional elicitation confirmation before writes
## Components
readquery
Execute SELECT / WITH queries with structured output (columns / rows / rowcount / truncated), limited by maxrows
writequery
Execute INSERT, UPDATE, DELETE or MERGE queries, returns affected row count
createtable
Create new tables in the database
listtables
Get a list of all tables in the database (schema + table name)
listviews
Get a list of all views in the database
describetable
View full schema for a specific table (type, nullable, default, primary key, identity, foreign keys, indexes)
listdatabases
List configured database connections (name, readonly, isdefault)
listprocedures
List stored procedures with parameter signatures
executeprocedure
Execute a stored procedure (supports multiple result sets)
appendinsight
Add new business insights to the memo resource
## Resources
memo://insights — a living business-insights memo, updated in real time via appendinsight
schema://{schema}/{table} — table structure of the default database (JSON: columns / PK / identity / FKs / indexes)
schema://{database}/{schema}/{table} — table structure of a named database connection
Resource templates are fetched on demand: unlike tool schemas they are not resent to the LLM every turn, which keeps long conversations lean.
## Security
All SQL goes through static validation before execution:
readquery only accepts a single SELECT / WITH statement and rejects any write or EXEC keyword (blocks e.g. WITH c AS (...) DELETE FROM t)
writequery uses a whitelist (INSERT / UPDATE / DELETE / MERGE only); EXEC, DROP, TRUNCATE, ALTER are rejected
Multi-statement batches (separated by ;) are rejected
trustedconnection: true switches to Windows integrated auth (the connection string uses TrustedConnection=yes, no username/password needed); false keeps the configured SQL account login
readonly: true disables all write operations, including stored procedures (they are black boxes that may write)
Stored procedure names are strictly validated as 1–3 dotted identifier parts before being embedded into {CALL ...}
Results are truncated at maxrows rows; queries are aborted after querytimeout seconds
收录徽章（可选）
想把收录标记放进 README 就复制这行，可选，不影响收录。
[](https://anclum.com/zh/s/daobataotie-mssql-mcp/)
- 来源
- awesome · https://github.com/daobataotie/mssql-mcp
- 按领域浏览
- MCP 服务
- 收录来源
- 10 个独立来源
- 收录于
- 今天
同类推荐
所属领域与标签
每个标签都能点进去看同类的全部条目。数字是当前库里的真实条数。