mssql-mcp

MSSQL Server MCP implementation written in C#

GitHub Stars

110

User Rating

Not Rated

Favorites

0

Views

25

Forks

11

Issues

7

Installation
Difficulty
Beginner
Estimated Time
5-10 minutes

Installation

Installation

Prerequisites

Python: 3.x
pyodbc: 4.0.39 or higher
pydantic: 2.0.0 or higher
mcp: 0.1.0 or higher
ODBC Driver 17 for SQL Server

Installation Steps

1. Clone Repository

bash
git clone https://github.com/daobataotie/mssql-mcp
cd mssql-mcp

2. Install Dependencies

bash
pip install -r requirements.txt

3. Configure the Server

Create config.json and add the following content:
json
{
    "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"
    }
}

4. Start the Server

bash
python src/server.py

Troubleshooting

Common Issues

Issue: Server won't start Solution: Check Python version and dependencies.

Additional Resources