Mcp Sqlserver

claude mcp add sqlserver --env SQLSERVER_HOST='<SQLSERVER_HOST>' --env SQLSERVER_DATABASE='<SQLSERVER_DATABASE>' --env SQLSERVER_USERNAME='<SQLSERVER_USERNAME>' --env SQLSERVER_PASSWORD='<SQLSERVER_PASSWORD>' -- npx -y @bilims/mcp-sqlserver

~/.codex/config.toml

[mcp_servers.sqlserver]
command = "npx"
args = ["-y", "@bilims/mcp-sqlserver"]
env = { SQLSERVER_HOST = "<SQLSERVER_HOST>", SQLSERVER_DATABASE = "<SQLSERVER_DATABASE>", SQLSERVER_USERNAME = "<SQLSERVER_USERNAME>", SQLSERVER_PASSWORD = "<SQLSERVER_PASSWORD>" }

# codex mcp add sqlserver --env SQLSERVER_HOST='<SQLSERVER_HOST>' --env SQLSERVER_DATABASE='<SQLSERVER_DATABASE>' --env SQLSERVER_USERNAME='<SQLSERVER_USERNAME>' --env SQLSERVER_PASSWORD='<SQLSERVER_PASSWORD>' -- npx -y @bilims/mcp-sqlserver

~/.cursor/mcp.json

{
  "mcpServers": {
    "sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "<SQLSERVER_HOST>",
        "SQLSERVER_DATABASE": "<SQLSERVER_DATABASE>",
        "SQLSERVER_USERNAME": "<SQLSERVER_USERNAME>",
        "SQLSERVER_PASSWORD": "<SQLSERVER_PASSWORD>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "sqlserver": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "<SQLSERVER_HOST>",
        "SQLSERVER_DATABASE": "<SQLSERVER_DATABASE>",
        "SQLSERVER_USERNAME": "<SQLSERVER_USERNAME>",
        "SQLSERVER_PASSWORD": "<SQLSERVER_PASSWORD>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "<SQLSERVER_HOST>",
        "SQLSERVER_DATABASE": "<SQLSERVER_DATABASE>",
        "SQLSERVER_USERNAME": "<SQLSERVER_USERNAME>",
        "SQLSERVER_PASSWORD": "<SQLSERVER_PASSWORD>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "<SQLSERVER_HOST>",
        "SQLSERVER_DATABASE": "<SQLSERVER_DATABASE>",
        "SQLSERVER_USERNAME": "<SQLSERVER_USERNAME>",
        "SQLSERVER_PASSWORD": "<SQLSERVER_PASSWORD>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "<SQLSERVER_HOST>",
        "SQLSERVER_DATABASE": "<SQLSERVER_DATABASE>",
        "SQLSERVER_USERNAME": "<SQLSERVER_USERNAME>",
        "SQLSERVER_PASSWORD": "<SQLSERVER_PASSWORD>"
      }
    }
  }
}