PeerDB-io/peerdb

Health v2 · maintenance only

Adoption not part of the score

3252 stars · 209 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

PeerDB is an open-source ETL/CDC tool that streams data from Postgres to data warehouses, queues, and storage engines, with an actively maintained focus on Postgres-to-ClickHouse and Postgres-to-Postgres replication. It is controlled via SQL through a Postgres-compatible interface and supports log-based CDC, schema change propagation, TOAST columns, and parallel initial loads.

Use cases

• replicate postgres data to clickhouse in real time
• stream postgres changes to a data warehouse via cdc
• sync postgres to postgres replication
• set up etl from postgres using sql commands
• keep analytics warehouse in sync with production postgres
• migrate large postgres tables with parallel initial load

When to choose

• you run Postgres at the heart of your data stack and need fast, low-latency replication
• you need Postgres-native feature support like jsonb, arrays, geospatial types, and TOAST columns
• you want SQL-based ETL configuration and automatic schema change propagation
• you are targeting ClickHouse or another Postgres as the destination

When to avoid

• your destination is Snowflake, BigQuery, Kafka, S3, or other now-deprecated connectors without a maintenance commitment
• you need a broad matrix of source and destination connectors rather than Postgres-centric replication
• you require a fully managed turnkey solution without self-hosting Docker infrastructure
• you rely on QRep or XMIN mirror types, which are deprecated

Facets

service · maturity active

etl streaming database databases big-data analytics self-hosted cloud go rust postgres clickhouse change-data-capture data-replication data-warehouse sql-interface temporal cdc data-engineering docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="PeerDB-io/peerdb")