# PeerDB

> Self-hosted, open-source (AGPL-3.0) ETL tool streaming Postgres to ClickHouse and other warehouses via CDC, with a web UI and a Postgres-compatible SQL interface.

- **Category:** Data Pipeline
- **Licence:** AGPL-3.0
- **Latest version:** v0.37.14
- **Open source:** oss
- **Languages:** Typescript, Go
- **Platforms:** Docker Compose
- **Tags:** PostgreSQL, Clickhouse, Bigquery, Snowflake, Cloud Native, Streaming, SQL, Distributed Systems, Kafka, Temporal, ETL, Rust, S3, Minio, Realtime, Cdc, Data replication, Stream processing, Postgres, SQL Interface, Eventhubs

## Description

PeerDB is a Postgres-focused ETL/ELT tool for streaming data out of PostgreSQL into warehouses, queues and storage at scale. It supports log-based (CDC) replication as the actively maintained mode, with cursor-based Query Replication and XMIN kept functional but deprecated. The maintainers claim 10x faster CDC than general-purpose tools thanks to parallel initial load with transaction snapshotting and CTID scans, parallel reading of the replication slot, efficient handling of large TOAST columns, propagation of added columns, partitioned-table support, and slot-growth and connection alerts. Everything is driven through a Postgres-compatible SQL interface on port 9900, so psql, pgAdmin, or any BI tool can create and monitor peers and mirrors, alongside a web dashboard on port 3000; the Rust Nexus query layer also allows querying remote peers like a federated database. Operators deploy it with the repo's Docker Compose stack (bash ./run-peerdb.sh), which starts the peerdb-server, Flow API and workers, the UI, a Postgres catalog, Temporal for orchestration and fault tolerance, and MinIO used to stage files before loading. PeerDB Cloud and a native ClickHouse Cloud integration are offered as hosted alternatives, and several destination connectors (Snowflake, BigQuery, Elasticsearch, Kafka family, Event Hubs, Pub/Sub, S3) are deprecated for maintenance reasons while still working.

## Links

- [Homepage](https://github.com/peerdb-io/peerdb)
- [Website](https://peerdb.io)
- [Docker](ghcr.io/peerdb-io/peerdb-server)
- [PeerDB Community Slack](https://slack.peerdb.io)
- [PeerDB Documentation](https://docs.peerdb.io/introduction)
- [Quickstart Guide](https://docs.peerdb.io/quickstart/quickstart)
- [SQL Reference](https://docs.peerdb.io/sql/reference)
- [API Reference](https://docs.peerdb.io/peerdb-api/reference)
- [GitHub releases (changelog)](https://github.com/PeerDB-io/peerdb/releases)

---
Source: https://selfhost.directory/project/peerdb