ClickHouse

ClickHouse databases are found in containers by their image, and on the host by their process and config files (host scan).

Plan	Pro and Team
Default ports	8123, 9000
Credential hints from	CLICKHOUSE_USER, CLICKHOUSE_ADMIN_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_ADMIN_PASSWORD, CLICKHOUSE_DB
Data in the container	/var/lib/clickhouse, /bitnami/clickhouse
On the host (host scan)	clickhouse-server, clickhouse

What you can do

Browse tables (sorted by their sorting key), the SQL editor, exports. Always read-only: every request of a read-only session sends readonly=2.

A least-privilege user

Wharfbase works with any user; give it only what you want it to do.

Read only

CREATE USER wharfbase_ro IDENTIFIED BY '…' SETTINGS readonly = 1;
GRANT SELECT ON app.* TO wharfbase_ro;

For other features

• Live consumers: GRANT SELECT ON system.processes TO wharfbase_ro;