MSSQL Read-Only MCP Server

claude mcp add mssql-read-only --env SERVER_NAME='<SERVER_NAME>' --env DATABASE_NAME='<DATABASE_NAME>' --env SQL_USER='<SQL_USER>' --env SQL_PASSWORD='<SQL_PASSWORD>' -- npx -y mssql-read-only-mcp

~/.codex/config.toml

[mcp_servers.mssql-read-only]
command = "npx"
args = ["-y", "mssql-read-only-mcp"]
env = { SERVER_NAME = "<SERVER_NAME>", DATABASE_NAME = "<DATABASE_NAME>", SQL_USER = "<SQL_USER>", SQL_PASSWORD = "<SQL_PASSWORD>" }

# codex mcp add mssql-read-only --env SERVER_NAME='<SERVER_NAME>' --env DATABASE_NAME='<DATABASE_NAME>' --env SQL_USER='<SQL_USER>' --env SQL_PASSWORD='<SQL_PASSWORD>' -- npx -y mssql-read-only-mcp

~/.cursor/mcp.json

{
  "mcpServers": {
    "mssql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "mssql-read-only-mcp"
      ],
      "env": {
        "SERVER_NAME": "<SERVER_NAME>",
        "DATABASE_NAME": "<DATABASE_NAME>",
        "SQL_USER": "<SQL_USER>",
        "SQL_PASSWORD": "<SQL_PASSWORD>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "mssql-read-only": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mssql-read-only-mcp"
      ],
      "env": {
        "SERVER_NAME": "<SERVER_NAME>",
        "DATABASE_NAME": "<DATABASE_NAME>",
        "SQL_USER": "<SQL_USER>",
        "SQL_PASSWORD": "<SQL_PASSWORD>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "mssql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "mssql-read-only-mcp"
      ],
      "env": {
        "SERVER_NAME": "<SERVER_NAME>",
        "DATABASE_NAME": "<DATABASE_NAME>",
        "SQL_USER": "<SQL_USER>",
        "SQL_PASSWORD": "<SQL_PASSWORD>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "mssql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "mssql-read-only-mcp"
      ],
      "env": {
        "SERVER_NAME": "<SERVER_NAME>",
        "DATABASE_NAME": "<DATABASE_NAME>",
        "SQL_USER": "<SQL_USER>",
        "SQL_PASSWORD": "<SQL_PASSWORD>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "mssql-read-only": {
      "command": "npx",
      "args": [
        "-y",
        "mssql-read-only-mcp"
      ],
      "env": {
        "SERVER_NAME": "<SERVER_NAME>",
        "DATABASE_NAME": "<DATABASE_NAME>",
        "SQL_USER": "<SQL_USER>",
        "SQL_PASSWORD": "<SQL_PASSWORD>"
      }
    }
  }
}