Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/daobataotie/mssql-mcp below:

GitHub - daobataotie/mssql-mcp: mssql mcp server

English | 中文

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

• 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

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.

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

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

#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"
    }
}

# 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"
            ]
        }
    }
}

# 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

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

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

MIT License

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4