Mssql MCP

🚀 MSSQL MCP Server

The MSSQL MCP Server offers database interaction and business intelligence capabilities. This server supports running SQL queries, analyzing business data, and automatically generating business insight memos. Refer to the SQLite modification instructions in the official documentation to adapt to the MSSQL environment.

✨ Features

Components

• read_query
  • Execute SELECT queries to read data from the database.
• write_query
  • Perform INSERT, UPDATE, or DELETE operations.
• create_table
  • Create a new table in the database.
• list_tables
  • Get a list of all tables in the database.
• describe-table
  • View the schema information of a specific table.
• append_insight
  • Add new business insights to the memo resource.

Demo

The database table is shown below. Column names are not standardized, and the AI will match them automatically. Errors that occur during SQL execution will be automatically corrected.

Here is a demonstration:

📦 Installation

Runtime Environment

• Python 3.x
• Dependency Packages
  • pyodbc>=4.0.39
  • pydantic>=2.0.0
  • mcp>=0.1.0
• ODBC Driver 17 for SQL Server

Install Dependencies

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

Configuration

# Create a config.json in the same folder as server.py and add the following content:
{
    "database": {
        "driver": "ODBC Driver 17 for SQL Server",
        "server": "Server IP",
        "database": "Database Name",
        "username": "Username",
        "password": "Password",
        "trusted_connection": false
    },
    "server": {
        "name": "mssql-manager",
        "version": "0.1.0"
    }
}

Claude Desktop, Windsurf

# Add the following content to claude_desktop_config.json. Note: Use your own path.
{
    "mcpServers": {
        "mssql": {
            "command": "python",
            "args": [
                # Your path, e.g., "C:\\mssql-mcp\\src\\server.py"
                "~/server.py"
            ]
        }
    }
}

Cursor

# Note: Use your own path.
npx -y @modelcontextprotocol/inspector python C:\\mssql-mcp\\src\\server.py

📚 Documentation

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

This project is licensed under the MIT License.