Technology1 min read

What's new in clickhousectl v0.6.0

By · Published by Everything Blog

In short

The CLI introduces Git-like project roots detected by a local folder or an environment variable, allowing commands to execute seamlessly across subdirectories while merging global and project settings. Remote operations are streamlined through passwordless cloud logins via web browsers or automated credential routing to local environment files. Furthermore, the update introduces operational safeguards for ClickHouse Managed Postgres, such as deletion protection and standby counts. Users upgrading their installations from earlier versions will need to initiate a fresh login for any saved OAuth sessions.

Key points

  • Engineering teams can now track database server configurations directly within their shar…: Engineering teams can now track database server configurations directly within their shared project code repositories.
  • Cloud database administration requires less manual credential management thanks to stream…: Cloud database administration requires less manual credential management thanks to streamlined browser logins and automated environment files.
  • Upgrading to this release mandates a fresh OAuth authentication step for users transition…: Upgrading to this release mandates a fresh OAuth authentication step for users transitioning from previous tool versions.

Sources checked by our analysis pipeline: 1

clickhousectl

(chctl

) is one CLI for ClickHouse and Postgres, both on your laptop and in ClickHouse Cloud. Locally it installs and switches ClickHouse versions, runs project-scoped ClickHouse servers and Docker-backed Postgres, and connects clients. In Cloud it covers the whole lifecycle of ClickHouse, ClickHouse Managed Postgres, ClickPipes, ClickStack, backups, keys and members.

v0.5.0 took UDFs from local to Cloud, added ClickHouse Managed Postgres observability and standardised the command surface. The highlights in v0.6.0:

- Projects that work like Git: run commands from any subdirectory of a project, pin the project root with an environment variable, and check server config into the repo.

- Cloud connections without a password:

cloud clickhouse client

signs you in through the browser, andcreate --dotenv

writes the one-time password to.env

and keeps it out of the terminal. search

, shell completions andfeedback

: find a command or flag by keyword, complete it with Tab, and tell us what the CLI couldn't do.- ClickHouse Managed Postgres: the service is now GA, and the CLI adds Postgres 19, AWS PrivateLink endpoints, standby counts and deletion protection.

-…

Technology