ClickPipes for Postgres CDC

Replicate your Postgres data to ClickHouse Cloud in just a few clicks for blazing fast analytics. Eliminates the need for external ETL tools that are expensive, slow and not purpose-built for Postgres. Learn more.

Start a free cloud trial

Our postgres CDC connector is already Trusted by

Blazing fast

Achieve 10x faster initial loads with parallel snapshotting, transferring TBs in hours, and experience continuous replication latency of just a few seconds.

Simple

Easily replicate your Postgres databases to ClickHouse Cloud in just a few clicks, or programmatically via API or Terraform. Skip complex pipelines with multiple moving parts and failure points.

Flexible

Connect any Postgres database, hosted or on-prem, including RDS, Azure Flexible Server, CloudSQL, Supabase, Neon, Crunchy Bridge, Tembo, and more.

Feature rich

Purpose-built for Postgres and ClickHouse, supporting features like schema changes, partitioned tables, TOAST columns, customizable ordering keys, and more.

Enterprise-grade

Built to support enterprise-grade workloads with TBs of data, fully secured through AWS PrivateLink, GCP Private Service Connect, SSH tunneling, and IP-based access controls.

No vendor lock-in

The connector is powered by PeerDB, a leading open-source CDC framework maintained by ClickHouse. Except for the UI, all components extend directly from PeerDB.

supports a wide range of Postgres data sources

What our customers are saying

ClickHouse powers Ashby's customer-facing analytics, delivering lightning-fast, fully dynamic insights, while Postgres handles core transactions. With Postgres CDC via ClickPipes, we seamlessly replicate terabytes of data and speed up our real-time analytics without disrupting operations. Reports that once took minutes now finish within a second. Complementing Postgres with ClickHouse enables us to provide a lightning-fast and fully reliable experience and handle even larger data as we scale.

We are having an amazing experience using the Postgres CDC connector in ClickPipes. We seamlessly moved our 30TB Aurora database to ClickHouse Cloud and are continuously keeping it in sync. We did not expect any ETL tool to handle our load, especially after a bitter experience in the past. However, we were pleasantly surprised by how reliable and performant ClickPipes has been for us.

We already reduced our Postgres to ClickHouse snapshot times from 10+ hours down to 15 minutes with PeerDB. Combining ClickHouse’s powerful analytics natively with PeerDB’s real-time data capture capabilities will greatly simplify our data processing workflows. This integration will enable us to build analytical applications faster, giving us a competitive edge in the market.