D
daobataotie/mssql-mcp
mssql mcp server
View on GitHub ↗Link checked 2026-11-12 · HTTP 200 · opens the vendor's own site
Install & config
Client config (built from the install command this repo gives)
{
"mcpServers": {
"daobataotie-mssql-mcp": {
"command": "npx",
"args": ["-y", "@modelcontextprotocol/inspector"]
}
}
}Parsed from the README we fetched on 2026-11-05; we have not executed it.
command/args come from the install command the repository states. When it is ambiguous, the project README wins.
VS Code (.vscode/mcp.json - the key is servers)
{
"servers": {
"daobataotie-mssql-mcp": {
"command": "npx",
"args": ["-y", "@modelcontextprotocol/inspector"]
}
}
}Same server, but VS Code keeps it under <code>servers</code>.
Claude Code (command line)
claude mcp add --transport stdio daobataotie-mssql-mcp -- npx -y @modelcontextprotocol/inspector
Claude Code does not read a config file; add the server with this command.
Key names differ by client: Clients & CLI
- Source
- collected from the abordage/awesome-mcp list · type: MCP server
- Harvest history
- first seen 2026-11-05 · last seen 2026-11-14 · seen 10× · listed by 10 sources
- Score
- score 1,003 · 10 sources · mcp
- Install
npx -y @modelcontextprotocol/inspector
FAQ (answers come from our records)
How do I install it?
The repository provides this install command:
npx -y @modelcontextprotocol/inspector. It comes from the repository itself; we cannot guarantee it runs as-is in your client.Who is it for?
We filed it under these tags: MCP 服务. The tags come from the entry itself, not a taxonomy we imposed.
Who maintains it?
first catalogued 2026-11-05；last seen 2026-11-14。There is no official certification or quality rating here — we record sources and dates only.
# 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
Listed badge (optional)
Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.
[](https://anclum.com/en/s/daobataotie-mssql-mcp/)
- Source
- awesome · https://github.com/daobataotie/mssql-mcp
- Browse by field
- MCP servers
- Listed by
- 10 independent sources
- added
- today
More like this
Filed under
Every tag opens the full list for that filter. Counts are the live catalogue figures.