mssql-mcp
If you are the rightful owner of mssql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MSSQL MCP Server provides database interaction and business intelligence capabilities, enabling SQL query execution, data analysis, and automatic business insight generation.
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.xPackages- 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
NoteοΌThe new version of cursor has also been changed to JSON configuration, please refer to the previous section
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
