mcp-mssql

MCP server for MSSQL

0 stars PythonServers & Infrastructure Updated Mar 9, 2025

Documentation

GUIDE

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

bash

python3.10 -m venv venv

2. Activate the Virtual Environment:

bash

source venv/bin/activate

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

bash

python --version

4. Enter Connection String Details:

bash

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:

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"

Frequently asked questions

What is mcp-mssql?

mcp-mssql is MCP server for MSSQL

How do I install mcp-mssql?

Open the GitHub repository and follow its README. Most MCP servers are added to your client's MCP config, then called by your agent.

Is mcp-mssql open source?

Yes — it is hosted on GitHub at https://github.com/FarukNetworks/mcp-mssql.

Related MCP tools

damn-vulnerable-mcp-server

Damn Vulnerable MCP Server Python-based implementation. Trusted by 1200+ developers. Trusted by 1200+ developers. Trusted by 1200+ developers.

1,209 Python

mysql_mcp_server

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases Python-based implementation. Trusted by 900+ developers.

964 Python

aimcpmodel-context-protocol+1

supabase-mcp-server

Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning...

805 Python

cursormodel-context-protocolsupabase+1