
MSSQL-MCP
MSSQL MCP服务器
1
Github Watches
5
Github Forks
20
Github Stars
MSSQL MCP Server
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
Components
-
read_query
- Execute SELECT queries to read data from the database
-
write_query
- Execute INSERT, UPDATE, or DELETE queries
-
create_table
- Create new tables in the database
-
list_tables
- Get a list of all tables in the database
-
describe-table
- View schema information for a specific table
-
append_insight
- Add new business insights to the memo resource
Demo
The database table is as follows. The column names are not standardized, and AI will match them on its own. Errors during SQL execution will self correct.
The following is the demo.
Operating environment
-
Python 3.x
-
Packages
- pyodbc>=4.0.39
- pydantic>=2.0.0
- mcp>=0.1.0
-
ODBC Driver 17 for SQL Server
Usage
Install packages
CD /d ~/mssql-mcp
pip install -r requirements.txt
config
#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"
]
}
}
}
Cursor
# Add according to the following diagram Cursor MCP. Note:use your path
MCP Inspector
# Note:use your path
npx -y @modelcontextprotocol/inspector python C:\\mssql-mcp\\src\\server.py
Project Structure
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
License
MIT License
相关推荐
Confidential guide on numerology and astrology, based of GG33 Public information
Take an adjectivised noun, and create images making it progressively more adjective!
Embark on a thrilling diplomatic quest across a galaxy on the brink of war. Navigate complex politics and alien cultures to forge peace and avert catastrophe in this immersive interstellar adventure.
Reviews

user_SZ7DIniQ
As a dedicated user of mssql-mcp by daobataotie, I can confidently say it is a superb tool for managing MSSQL databases. The seamless integration and efficient management features have significantly improved my workflow. Highly recommended for any database administrator seeking reliability and ease of use. Check it out on GitHub!