[QUESTION] ClickHouse username and password

[q876625596]

Currently, the ClickHouse username and password are configured directly in config.yaml. For better security and flexibility—especially in containerized or CI/CD environments—it would be helpful to support setting these credentials via environment variables, such as:

CLICKHOUSE_USER=your_user
CLICKHOUSE_PASSWORD=your_password

This would allow sensitive information to be managed outside of static config files.

[q876625596]

Ideally, the following configuration fields could all be optionally set via environment variables:

mysql:
  host: 'localhost'
  port: 8306
  user: 'root'
  password: 'root'
  charset: 'utf8mb4'  # optional, default is utf8mb4 for full Unicode support

clickhouse:
  host: 'localhost'
  port: 8323
  user: 'default'
  password: 'default'

This would allow sensitive information to be managed outside of static config files and improve compatibility with secure deployment pipelines.

[bakwc]

Thanks for proposal, good idea, will add in a few days.

[bakwc]

done, env vars support added (in v0.1.4)