What you need to know
SQL Server MCP server providing database interaction and business intelligence. Tools for read/write queries, table creation/listing, schema description and appending business insight memos. Python with pyodbc and ODBC Driver 17 for SQL Server.
Install
pip install -r requirements.txt Create config.json with database driver, server, database, username, password
Usage
- •Add to claude_desktop_config.json: python ~/server.py
- •Cursor MCP JSON configuration
- •npx -y @modelcontextprotocol/inspector python C:\mssql-mcp\src\server.py
Key features
- ✓read_query, write_query, create_table, list_tables, describe-table, append_insight
- ✓AI self-corrects on SQL execution errors
- ✓Business insight memo generation
Best for
Querying SQL Server databases and generating business insights from AI agents
Caveats
- ⚠Requires Python 3.x and ODBC Driver 17 for SQL Server
- ⚠Simple configuration via config.json file
Clients: Claude Desktop · Windsurf · Cursor
Documentation ↗Reviewed 2026-08-11
Topics
- Stars
- 39★
- Forks
- 11
- Language
- Python
- License
- MIT
- Created
- 2025-03-13
- Last push
- 2025-06-05