ClickHouse

Claude Code

claude mcp add --transport stdio --env "CLICKHOUSE_HOST=<clickhouse_host>" --env "CLICKHOUSE_USER=<clickhouse_user>" --env "CLICKHOUSE_PASSWORD=<clickhouse_password>" mcp-clickhouse -- uvx mcp-clickhouse==0.7.0

Codex, in ~/.codex/config.toml

[mcp_servers.mcp-clickhouse]
command = "uvx"
args = ["mcp-clickhouse==0.7.0"]

[mcp_servers.mcp-clickhouse.env]
CLICKHOUSE_HOST = "<clickhouse_host>"
CLICKHOUSE_USER = "<clickhouse_user>"
CLICKHOUSE_PASSWORD = "<clickhouse_password>"

Cursor, in .cursor/mcp.json

{
  "mcpServers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "command": "uvx",
      "env": {
        "CLICKHOUSE_HOST": "\u003cclickhouse_host\u003e",
        "CLICKHOUSE_PASSWORD": "\u003cclickhouse_password\u003e",
        "CLICKHOUSE_USER": "\u003cclickhouse_user\u003e"
      }
    }
  }
}

Claude Desktop, in claude_desktop_config.json

{
  "mcpServers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "command": "uvx",
      "env": {
        "CLICKHOUSE_HOST": "\u003cclickhouse_host\u003e",
        "CLICKHOUSE_PASSWORD": "\u003cclickhouse_password\u003e",
        "CLICKHOUSE_USER": "\u003cclickhouse_user\u003e"
      }
    }
  }
}

VS Code, in .vscode/mcp.json

{
  "servers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "command": "uvx",
      "env": {
        "CLICKHOUSE_HOST": "\u003cclickhouse_host\u003e",
        "CLICKHOUSE_PASSWORD": "\u003cclickhouse_password\u003e",
        "CLICKHOUSE_USER": "\u003cclickhouse_user\u003e"
      },
      "type": "stdio"
    }
  }
}