MSSQL MCP Server
MSSQL MCP 服务器
概述
MSSQL MCP 服务器,提供数据库交互和商业智能功能。该服务器支持运行 SQL 查询、分析业务数据并自动生成业务洞察备忘录。
参考官网的SQLite进行修改,适配MSSQL
Related MCP server: SQLite MCP Server
成分
read_query执行 SELECT 查询以从数据库读取数据
write_query执行 INSERT、UPDATE 或 DELETE 查询
create_table在数据库中创建新表
list_tables获取数据库中所有表的列表
describe-table查看特定表的架构信息
append_insight向备忘录资源添加新的业务见解
演示
数据库表如下。列名非标准化,AI 会自行匹配。SQL 执行过程中的错误会自行纠正。

以下是演示。

操作环境
Python 3.xPackagespyodbc>=4.0.39
pydantic>=2.0.0
mcp>=0.1.0
ODBC Driver 17 for SQL Server
用法
安装软件包
CD /d ~/mssql-mcp
pip install -r requirements.txt 配置
#with server.py same folder create config.json,add:
{
"database": {
"driver": "ODBC Driver 17 for SQL Server",
"server": "server ip",
"database": "db name",
"username": "username",
"password": "password",
"trusted_connection": false
},
"server": {
"name": "mssql-manager",
"version": "0.1.0"
}
}Claude Desktop、Windsurf
# add to claude_desktop_config.json. Note:use your path
{
"mcpServers": {
"mssql": {
"command": "python",
"args": [
# your path,e.g.:"C:\\mssql-mcp\\src\\server.py"
"~/server.py"
]
}
}
}光标
# Add according to the following diagram Cursor MCP. Note:use your path 
注:新版cursor也改为JSON配置,请参考上一节
MCP 检查器
# Note:use your path
npx -y @modelcontextprotocol/inspector python C:\\mssql-mcp\\src\\server.py项目结构
mssql-mcp
├── .git
├── .gitignore
├── LICENSE
├── README.md
├── README_en.md
├── README_zh.md
├── imgs
│ ├── cursor_config.png
│ ├── table.png
│ └── demo.gif
├── requirements.txt
└── src
├── __init__.py
└── server.py执照
MIT 许可证
This server cannot be deployed
Maintenance
Related MCP Connectors
- RumboOAuthcom.rumboar
Securely query and analyze business data, dashboards, projections, alerts, and knowledge.
Ask questions in plain language, get answers from your business database. No SQL required.
Ask your databases questions in plain English, run read-only SQL and set up data alerts.
Ask business questions in plain English. Get instant answers from your database, no SQL needed.
Related MCP Servers
- -licenseNot gradedqualityAmaintenanceA Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.91,120MIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server that provides database interaction capabilities through SQLite, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos.19MIT
- AlicenseAqualityBmaintenanceEnables interaction with Microsoft SQL Server and Azure SQL databases through natural language, supporting queries, schema exploration, stored procedures, and complete database operations with connection pooling and security features.141,417 npm13MIT
- AlicenseBqualityFmaintenanceEnables users to analyze, query, and modernize Microsoft SQL Server databases through natural language, supporting multi-database connections, schema discovery, performance analysis, and legacy system migration planning.333,547 npm3MIT