Vertica MCP

claude mcp add vertica --env VERTICA_HOST='<VERTICA_HOST>' --env VERTICA_PORT='<VERTICA_PORT>' --env VERTICA_DATABASE='<VERTICA_DATABASE>' --env VERTICA_USER='<VERTICA_USER>' --env VERTICA_PASSWORD='<VERTICA_PASSWORD>' -- uvx mcp-vertica --host=localhost --db-port=5433 --database=VMart --user=dbadmin --password= --connection-limit=10

~/.codex/config.toml

[mcp_servers.vertica]
command = "uvx"
args = ["mcp-vertica", "--host=localhost", "--db-port=5433", "--database=VMart", "--user=dbadmin", "--password=", "--connection-limit=10"]
env = { VERTICA_HOST = "<VERTICA_HOST>", VERTICA_PORT = "<VERTICA_PORT>", VERTICA_DATABASE = "<VERTICA_DATABASE>", VERTICA_USER = "<VERTICA_USER>", VERTICA_PASSWORD = "<VERTICA_PASSWORD>" }

# codex mcp add vertica --env VERTICA_HOST='<VERTICA_HOST>' --env VERTICA_PORT='<VERTICA_PORT>' --env VERTICA_DATABASE='<VERTICA_DATABASE>' --env VERTICA_USER='<VERTICA_USER>' --env VERTICA_PASSWORD='<VERTICA_PASSWORD>' -- uvx mcp-vertica --host=localhost --db-port=5433 --database=VMart --user=dbadmin --password= --connection-limit=10

~/.cursor/mcp.json

{
  "mcpServers": {
    "vertica": {
      "command": "uvx",
      "args": [
        "mcp-vertica",
        "--host=localhost",
        "--db-port=5433",
        "--database=VMart",
        "--user=dbadmin",
        "--password=",
        "--connection-limit=10"
      ],
      "env": {
        "VERTICA_HOST": "<VERTICA_HOST>",
        "VERTICA_PORT": "<VERTICA_PORT>",
        "VERTICA_DATABASE": "<VERTICA_DATABASE>",
        "VERTICA_USER": "<VERTICA_USER>",
        "VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "vertica": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-vertica",
        "--host=localhost",
        "--db-port=5433",
        "--database=VMart",
        "--user=dbadmin",
        "--password=",
        "--connection-limit=10"
      ],
      "env": {
        "VERTICA_HOST": "<VERTICA_HOST>",
        "VERTICA_PORT": "<VERTICA_PORT>",
        "VERTICA_DATABASE": "<VERTICA_DATABASE>",
        "VERTICA_USER": "<VERTICA_USER>",
        "VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "vertica": {
      "command": "uvx",
      "args": [
        "mcp-vertica",
        "--host=localhost",
        "--db-port=5433",
        "--database=VMart",
        "--user=dbadmin",
        "--password=",
        "--connection-limit=10"
      ],
      "env": {
        "VERTICA_HOST": "<VERTICA_HOST>",
        "VERTICA_PORT": "<VERTICA_PORT>",
        "VERTICA_DATABASE": "<VERTICA_DATABASE>",
        "VERTICA_USER": "<VERTICA_USER>",
        "VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "vertica": {
      "command": "uvx",
      "args": [
        "mcp-vertica",
        "--host=localhost",
        "--db-port=5433",
        "--database=VMart",
        "--user=dbadmin",
        "--password=",
        "--connection-limit=10"
      ],
      "env": {
        "VERTICA_HOST": "<VERTICA_HOST>",
        "VERTICA_PORT": "<VERTICA_PORT>",
        "VERTICA_DATABASE": "<VERTICA_DATABASE>",
        "VERTICA_USER": "<VERTICA_USER>",
        "VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "vertica": {
      "command": "uvx",
      "args": [
        "mcp-vertica",
        "--host=localhost",
        "--db-port=5433",
        "--database=VMart",
        "--user=dbadmin",
        "--password=",
        "--connection-limit=10"
      ],
      "env": {
        "VERTICA_HOST": "<VERTICA_HOST>",
        "VERTICA_PORT": "<VERTICA_PORT>",
        "VERTICA_DATABASE": "<VERTICA_DATABASE>",
        "VERTICA_USER": "<VERTICA_USER>",
        "VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
      }
    }
  }
}