MSSQL

Connects MSSQL databases to an MCP client for in-editor queries and automation.

typescript

0

GitHub Stars

typescript

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

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

The MSSQL MCP Server lets you connect your MSSQL database to an MCP client, enabling seamless commands, data queries, and automation through your editor. It acts as a bridge between your local MSSQL instance and the MCP ecosystem, so you can validate connections, run server-side MCP actions, and manage your data from your development environment.

How to use

You use the MSSQL MCP Server by running it as a local stdio server and connecting your MCP client through an editor. Start the server with the command provided in your setup, then switch your editor to AGENT mode to establish the connection. Once connected, you can issue MCP actions to interact with your MSSQL database, run queries, and perform common tasks directly from your editor interface.

How to install

Prerequisites: you need Python 3.10 installed on your system. You also should have an editor or environment that supports MCP and AGENT mode.

Step 1. Create a virtual environment for Python tools.

python3.10 -m venv venv

Step 2. Activate the virtual environment.

# macOS/Linux
source venv/bin/activate

Step 3. Verify you are using Python 3.10 inside the activated environment.

python --version

Step 4. Create a .env file to specify your MSSQL connection details.

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

Step 5. Define the MCP server connection for your editor by creating or editing the file .cursor/mcp.json with the MSSQL MCP server configuration.

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

Additional steps and checks

Step 6. In your editor, select AGENT mode to enable the MCP connection and try a basic check to verify the MSSQL MCP server is reachable from the editor.

Tip: You can prompt the editor to test the connection with a request like: Use MSSQL MCP server to check connection.