Postgres CDC connector is now in Public Beta

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.

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 and few minutes!

Flexible

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

Feature rich

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

Powered by PeerDB

The connector is powered by PeerDB, a leading open-source Postgres CDC provider, which ClickHouse acquired a few months ago. Since PeerDB is open source, there’s no vendor lock-in!

supports a wide range of Postgres data sources

What our customers are saying

ClickPipes for Postgres has made it incredibly easy for us to keep our billing data in Postgres synchronized with ClickHouse for efficient analytics. The CDC experience is blazing fast, ensuring data freshness within seconds while minimizing the load on our production Postgres database. An invaluable solution for seamlessly integrating Postgres with ClickHouse!

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.