Frustratingly simple ETL for Postgres

10x faster data movement from and to your Postgres database. Empower your data engineers to write scalable pipelines with ease, in minutes, with SQL.
Backed by
Y Combinator logo
Combinator
CREATE PEER postgres_peer
FROM postgres (...);

postgres connection validated and created peer
 
CREATE
PEER snowflake_peer
FROM snowflake (...);

snowflake connection validated and created peer

CREATE
MIRROR real_time_cdc
FROM postgres_peer
TO snowflake_peer
WITH TABLE MAPPING (transactions:transactions, users:users);

transactions and users table replicated in realtime from postgres to snowflake.

Total time: 2 sec

Benchmarks

PeerDB · 4.5 min
AirByte · 34 min
Fivetran · Not supported
PeerDB · 30 sec
AirByte · +1 hrs
Fivetran · 5 min
PeerDB · 4 min
AirByte · 28 min
Fivetran · Not supported
PeerDB · 33 sec
AirByte · +1 hrs
Fivetran · 5 min

Real-time CDC
from PostgreSQL

Data-freshness guarantees of less than 30s on target.
Link to docs

Real-time Streaming
of Query Results

Streaming ~100 million rows in 4.5 minutes.
Link to docs

Integrations

Get data in and out of Postgres from multiple connectors
Learn More

Offerings

PeerDB

Free and Open

Ideal for individuals
Open GitHub
check
Real-time CDC – Postgres to Kafka, Azure Event Hubs, Postgres, Snowflake and BigQuery
check
Streaming Query – Postgres to Snowflake, BigQuery, S3 and Postgres; SQL Server to Postgres
check
Query Layer – Snowflake, BigQuery and PostgreSQL.
check
Docker container to setup and install PeerDB
PeerDB

Cloud

Ideal for companies
Request Access
Everything in "PeerDB Open Source" plus...
check
Fully managed and hosted on AWS, Azure and GCP.
check
Blazing fast initial load.
check
Advance metrics and monitoring dashboards
check
High Availability
PeerDB

Enterprise

Ideal for teams
Contact us
Everything in "PeerDB Open Source", plus...
check
Blazing fast initial load.
check
Advance metrics and monitoring
check
Kubernetes Helm Chart
check
White-glove Implementation Support
check
24x7 support with enterprise-grade SLAs