This guide explains how to connect to ClickHouse with Oxy. ClickHouse is an open-source column-oriented DBMS for real-time analytics.

​
Configuration Options

Add your ClickHouse configuration to config.yml. Here are all available parameters:

databases:
  - name: my_clickhouse_db    # Unique identifier for this connection
    type: clickhouse
    host: "localhost"         # ClickHouse server hostname or IP
    user: "default"          # Username for authentication
    password: <password>      # Direct password (not recommended)
    password_var: "CH_PWD"   # Environment variable containing password (recommended)
    database: "default"      # Database name to connect to

​
Example Configurations

1

Prepare password environment variable

Export the environment variable:

export CH_PWD=<your password>

Or put it in .env file:

echo CH_PWD=<your password> >> .env
2

Add ClickHouse configuration

databases:
  - name: local_ch
    type: clickhouse
    host: "localhost"
    user: "default"
    password_var: "CH_PWD"
    database: "analytics"

​
Troubleshooting

  • Verify server status: clickhouse-client --query "SELECT 1"
  • Check system logs: /var/log/clickhouse-server/
  • Common ports: 8123 (HTTP), 9000 (TCP), 9009 (replication)
  • Monitor server metrics: system.metrics table