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.
Recent system failures across critical infrastructure were driven by technical integration flaws rather than state-sponsored cyberattacks. The rapid emergence of vulnerabilities is forcing urgent software patching that frequently clashes with outdated legacy architecture. This growing wave of disruptions highlights the operational risks organizations face when bridging modern automation with decades-old networks.
The social technology giant is expanding entertainment capabilities on Quest 3 and Quest 3S headsets through a transaction-based catalog in its TV app. This digital storefront rollout aims to turn virtual reality hardware into dedicated personal cinemas ahead of new device launches planned for next spring.
Developers looking to master front-end workflows have a new resource covering end-to-end web deployment. The newly debuted publication guides readers through the practical steps of assembling and launching a functional project using modern tooling. This educational initiative aims to help learners move seamlessly from code construction to production.