---
title: "clickhousectl v0.2.0: Postgres, ClickPipes and more"
description: "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."
---

# clickhousectl v0.2.0: Postgres, ClickPipes and more

[Clickhouse](https://yomu.fyi/company/clickhouse) · Al Brown · May 20, 2026

**Type:** Announcement

## 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.

## Context

Cloud service querying no longer requires a local ClickHouse binary, and the release introduces output changes intended to make CLI results easier for agents and humans to read.

## Approach / What changed

The release adds Docker-backed local Postgres and managed Cloud Postgres commands, full ClickPipes lifecycle management, SQL-over-HTTP queries through service-bound Query Endpoints and API keys, Markdown-style table output, credential-resolution debugging, and the standalone typed async Rust crate clickhouse-cloud-api.

## Takeaways

- 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.
- ClickPipes support object-storage batch ingestion, Kafka-compatible and Kinesis streaming, Postgres and MySQL CDC, MongoDB CDC, and BigQuery snapshots.
- 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.

**Tags:** [Authentication](https://yomu.fyi/topic/authentication), [Developer Experience](https://yomu.fyi/topic/developer-experience), [Postgres](https://yomu.fyi/topic/postgres), [Rust](https://yomu.fyi/topic/rust), [Streaming](https://yomu.fyi/topic/streaming)

- Source: [Clickhouse](https://clickhouse.com/blog/clickhousectl-v0-2-0-postgres-clickpipes-more)
- Source URL: https://clickhouse.com/blog/clickhousectl-v0-2-0-postgres-clickpipes-more
- Ingested by Yomu: 2026-08-28T01:26:14.421Z

[Read original post](https://clickhouse.com/blog/clickhousectl-v0-2-0-postgres-clickpipes-more)