GUIDE

1. Create the Virtual Environment: Run the following command to create a virtual environment named venv:

   python3.10 -m venv venv
   

2. Activate the Virtual Environment:

   • On macOS and Linux:

     source venv/bin/activate
     

3. Verify the Python Version: After activation, verify that the virtual environment is using Python 3.10 by running:

   python --version
   

4. 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
   

5. 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"
         }
       }
     }
   }
   

6. 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"