mcp-mssql

by FarukNetworks

Data/Databases MSSQL Cursor Database Server Python

This guide provides instructions on setting up and using the MSSQL MCP (MCP stands for Model-Code Proxy) server. It details the steps for creating a virtual environment, configuring connection details, and integrating the server with the Cursor editor.

Last updated: N/A

GUIDE

Create the Virtual Environment: Run the following command to create a virtual environment named venv:
```
python3.10 -m venv venv
```
Activate the Virtual Environment:
- On macOS and Linux:
```
source venv/bin/activate
```
Verify the Python Version: After activation, verify that the virtual environment is using Python 3.10 by running:
```
python --version
```

Enter Connection String Details:

Create a .env file and add the following connection details:

MSSQL_SERVER=localhost
MSSQL_USER=SA
MSSQL_PASSWORD=YourStrong@Passw0rd
MSSQL_DATABASE=localdatabase
MSSQL_PORT=1433

Connect MSSQL MCP Server to Your Cursor Editor:

Create or edit the file in folder: .cursor/mcp.json

{
  "mcpServers": {
    "mssql": {
      "command": "uv",
      "args": [
        "--directory", 
        "path/to/mssql_mcp_server",
        "run",
        "mssql_mcp_server"
      ],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database"
      }
    }
  }
}

Select AGENT mode in your editor and check connection

you can prompt the Cursor with something like this "Use MSSQL MCP server to check connection"