Cloud / Data ingestion

Postgres CDC connector in ClickPipes is now in Private Preview

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. Join the waitlist now.
insert
insert
update
delete
add col
Postgres
Loading form...
icon image

Blazing-fast

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

Simple

Easily replicate your Postgres databases to ClickHouse Cloud in just a few clicks and few minutes!
icon image

Flexible

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

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.
icon image

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!

What our customers are saying

Quote

PeerDB has been a game-changer for us, effortlessly migrating tens of terabytes from our Postgres warehouse into ClickHouse and keeping millions of daily orders synced with just seconds of latency. We're really excited about PeerDB's native integration into ClickHouse Cloud via ClickPipes and all of the opportunities it opens up for us.

Quote
Quote

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.

Quote
Quote

Clickpipes helps us reliably keep data from Postgres in sync with Clickhouse, while we rapidly improve our product. Clickhouse and Postgres are the peanut butter and chocolate of databases (they go well together!) and Clickpipes makes it easy to build that architechture at a fast-moving startup.

Quote

Easily add your Postgres source

Postgres can be running anywhere - cloud or on-prem
Secure the connection with SSH tunneling
Add Postgres Source

Customize incoming data

Table-level filtering
Column-level filtering
Column-level granular settings
Customize Incoming Data

Monitor your pipe

Number of rows per table / GB ingested
Native Postgres metrics, including slot size
Alerts for potential issues
Monitor Pipe

Edit pipe in-place

Add more tables in just a few clicks
Change replication settings, including data freshness
Blazing-fast resyncs
Edit Pipe In-Place
DotsDots

Get early access

Join the waitlist to get access to the Postgres CDC connector
Loading form...

Get started with ClickHouse Cloud for free

We’ll get you started on a 30 day trial and $300 credits to spend at your own pace.