Mssql Mcp

What is Mssql Mcp about?

Mssql Mcp delivers a server that interacts with Microsoft SQL Server to run SELECT, INSERT, UPDATE, DELETE queries, manage tables, describe schemas, and append business insights to a memo resource. It integrates with Model Context Protocol clients to enable AI‑driven data analysis and insight generation.

How to use Mssql Mcp?

1. Install dependencies

   cd /d ~/mssql-mcp
   pip install -r requirements.txt
   

2. Create a config.json in the same directory as server.py with database connection details and server metadata.
3. Run the server (e.g., via the MCP inspector tool):

   npx -y @modelcontextprotocol/inspector python C:\mssql-mcp\src\server.py
   

4. Configure client integrations such as Claude Desktop, Windsurf, or Cursor by pointing them to the Python script path as shown in the README.

Key features of Mssql Mcp

• Execute read‑only (SELECT) queries.
• Perform write operations (INSERT, UPDATE, DELETE).
• Create new tables and list existing ones.
• Describe table schemas.
• Append automatically generated business insights to a memo resource.
• Self‑corrects SQL errors during execution.
• Compatible with MCP‑based AI tools (Claude Desktop, Windsurf, Cursor, MCP Inspector).

Use cases of Mssql Mcp

• Business intelligence dashboards: Retrieve and transform data on‑the‑fly for reporting.
• AI‑driven analytics: Let an LLM query the database and generate insight memos without manual SQL crafting.
• Rapid prototyping: developers can quickly test database operations via MCP clients.
• Data validation & cleanup: automated correction of malformed queries and schema introspection.

FAQ from the Mssql Mcp

Q: Which ODBC driver is required? A: ODBC Driver 17 for SQL Server.

Q: What Python version is supported? A: Python 3.x.

Q: Can I use Windows authentication? A: Yes, set "trusted_connection": true in config.json and omit username/password.

Q: How do I integrate with Cursor? A: Follow the illustrated configuration steps in the README and provide the path to server.py.

Q: Do I need an API key for the MCP server? A: No API key is required for the core Python server; only the optional inspector wrapper may need environment variables for external services.

MSSQL MCP Server

English | 中文

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  

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