Mssql Mcp Server

What is Mssql Mcp Server about?

Enables running SELECT, INSERT, UPDATE, DELETE statements against a MSSQL database, managing tables, and automatically generating business‑insight memos based on query results.

How to use Mssql Mcp Server?

1. Clone the repository and navigate to the project root.
2. Install dependencies with pip install -r requirements.txt (Python 3.x required).
3. Create a config.json next to server.py containing database connection details and server metadata.
4. Launch the MCP server, e.g., using the Model Context Protocol inspector:

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

5. Integrate the server with Claude Desktop, Windsurf, or Cursor by adding the appropriate path in their MCP configuration files.

Key Features

• read_query – Execute SELECT statements and return result sets.
• write_query – Perform INSERT, UPDATE, or DELETE operations.
• create_table – Create new tables on the fly.
• list_tables – Retrieve a list of all tables in the database.
• describe-table – Show schema details for a specific table.
• append_insight – Add generated business insights to a memo resource.

Use Cases

• Business analysts querying sales or operational data without writing SQL manually; the AI matches non‑standard column names automatically.
• Application back‑ends needing a lightweight REST‑like interface to execute ad‑hoc queries against MSSQL.
• Automated reporting pipelines that generate insight memos after each data extraction.

FAQ

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

Q: Can the server run on Windows and Linux? A: Yes, as long as Python 3.x and the appropriate ODBC driver are installed.

Q: How are SQL errors handled? A: Execution errors are caught and the server attempts self‑correction before returning a response.

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