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.

Table

The following is the demo.

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

Cursor config

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

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

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