Section
Configure
Server settings from YAML and environment variables, the secrets they need, and the ClickHouse connections you manage.
YAML configurationConfigure the server with a grouped YAML file via CHOUSE_CONFIG_PATH — precedence rules and a full example.Environment variablesEvery setting the server reads, with its default, YAML key and what it does — checked against the code.Secrets generationGenerate JWT secrets and AES-256 encryption keys/salts with openssl, and what each secret protects.ConnectionsAdd and manage multiple ClickHouse servers, connection presets, encrypted credentials and quick switching.Connection kinds and the role ceilingLimit each person to a ClickHouse role: the empty login, the role map, the system role, the checks CHouse UI runs, and how to switch a connection.Personal connectionsRun each person's statements as their own ClickHouse user: which builds qualify, the two roles, links between accounts and ClickHouse users, and what changes.ClickHouse privilegesWhat a connection's ClickHouse user needs for every feature, how Test and Save check it, and a ready-made GRANT script — generated from the server.