clickhousectl v0.2.0: Postgres, ClickPipes and more

Clickhousectl v0.2.0 now manages Postgres databases locally and in ClickHouse Cloud, alongside ClickHouse servers, with support for multiple Postgres versions 16 through 18. The update adds ClickPipes management for all supported sources, enables SQL queries over HTTP against ClickHouse Cloud services without a local ClickHouse binary, and introduces a standalone Rust client library for the ClickHouse Cloud API. The release also includes agent-friendly output improvements, including Markdown-style tables and a debug flag for credential resolution.

We're releasing clickhousectl v0.2.0. This release adds Postgres local and ClickHouse Cloud managed , ClickPipes management for the full set of supported sources, SQL over HTTP against Cloud services, a few agent-friendly output tweaks, and a standalone Rust client library for the ClickHouse Cloud API. If you already have clickhousectl installed, update with: clickhousectl now manages Postgres, too. Just like ClickHouse, you can use it locally Docker-backed and in ClickHouse Cloud managed Postgres . Develop locally, and go to Cloud when you're ready for prod. Postgres managed by ClickHouse gives you the fastest, enterprise-grade cloud Postgres, backed by NVMes, with HA, read replicas, and point-in-time restore. Local Postgres runs as a Docker container, keyed on name, major version . Data lives under .clickhouse/servers/<name -pg<major /data/, so a single name can host multiple Postgres majors with isolated state. Supported versions are 16, 17, and 18. Pre-pull an image optional; start pulls on demand clickhousectl local install postgres@16 Start a Postgres instance clickhousectl local postgres start --name dev --version 16 --port 5433 Connect with psql host psql if installed, otherwise docker exec clickhousectl local postgres client --name dev --query "SELECT 1" Write connection vars to .env clickhousectl local postgres dotenv --name dev Stop / remove clickhousectl local postgres stop dev clickhousectl local postgres remove dev ClickHouse and Postgres servers share server list, so you can see both engines side by side in a single command. Cloud-managed Postgres requires a ClickHouse Cloud account, and the CLI must be authenticated with API Keys. Querying ClickHouse services in ClickHouse Cloud Querying ClickHouse services in ClickHouse Cloud no longer requires a local ClickHouse binary to use as the client. The CLI now uses ClickHouse Cloud's Query Endpoints to send SQL over HTTP. cloud service create provisions a Query Endpoint on new services by default. A new API Key is created that is scoped only to the new service so it can't be used to go rogue , and the Query Endpoint itself is locked down to the new API Key. The CLI stores the new key alongside your existing API Key. cloud service query then runs SQL over HTTP using that key: clickhousectl cloud service query --name my-service --query "SELECT 1" clickhousectl cloud service query --id <service-id \ --query "SELECT count FROM system.tables" \ --format JSONEachRow echo "SELECT 1+1" | clickhousectl cloud service query --name my-service For existing services without a Query Endpoint or stored key, cloud service query provisions one lazily on first use. Pass --no-auto-enable to fail instead, or --no-enable-query on service create to skip the create-time hook. The query endpoint binding is created with role sql console admin, which grants read and write inside the bound service only. The API key itself has no org-level roles, so the binding is the only thing granting access: a stolen key can only hit the service it was minted for. cloud service delete removes the stored key from credentials.json. Two small changes that make a difference when an agent or a human is reading output. Lighter tables. Tabular output now uses Markdown-style tables with ASCII separators instead of rounded Unicode box-drawing characters. The result is friendlier to copy into a markdown file, a PR description, or a chat with an LLM, and uses fewer tokens when an agent is reading it. --debug for credential resolution. Pass --debug to any cloud command to print the resolved credential source and the API URL to stderr before the command runs. clickhousectl manages ClickHouse Cloud using the ClickHouse Cloud API. The Cloud API code is now its own crate, clickhouse-cloud-api, a typed async Rust client. The CLI is now a consumer of this crate like any other downstream user. clickhousectl is only 5 weeks old at the time of releasing v0.2.0, but already over 5000 ClickHouse developers are using it to build with ClickHouse locally and in Cloud. There's still lots of features to support: work is already underway for ClickStack the ClickHouse observability stack , and we're looking into local PeerDB support to mirror the Postgres< ClickHouse CDC capabilities that are already possible in Cloud. Outside of features, we're doing some exciting research into agentic experience AX and how we can better optimise the CLI, our APIs, MCP and other surface areas for agents. We're thinking about how we can improve an agent's ability to complete tasks, as well as their consistency, speed, tool calls, and cost. Expect some rapid iteration on the experience side.