clickhousectl v0.2.0: Postgres, ClickPipes and more

Summary

clickhousectl v0.2.0 expands the beta CLI with local and ClickHouse Cloud managed Postgres, ClickPipes, SQL over HTTP for Cloud services, agent-oriented output changes, and a standalone Rust client for the ClickHouse Cloud API. Local Postgres runs in Docker, is keyed by name and major version, stores isolated data under .clickhouse/servers/-pg/data/, and supports versions 16, 17, and 18. ClickPipes covers batch, streaming, CDC, and snapshot sources including object storage, Kafka-compatible systems, Kinesis, Postgres, MySQL, MongoDB, and BigQuery. Cloud queries use a provisioned or lazily enabled Query Endpoint and service-scoped API key, while the endpoint uses sql_console_admin and the key has no organization-level roles. The release also adds Markdown-style tables and credential debugging, with more than 5,000 users reported five weeks into the project.

Takeaways

1. 1

   Local Postgres instances are keyed by name and major version, with isolated data under .clickhouse/servers/-pg/data/; supported versions are 16, 17, and 18.

2. 2

   ClickPipes support object-storage batch ingestion, Kafka-compatible and Kinesis streaming, Postgres and MySQL CDC, MongoDB CDC, and BigQuery snapshots.

3. 3

   Cloud Query Endpoint access uses a service-scoped API key with no organization-level roles; the endpoint binding grants sql_console_admin within the bound service.