Frustratingly simple data movement for Postgres

We are building a fast, simple and the most cost effective way to stream data from Postgres to Data Warehouses, Queues and Storage engines. If you are running Postgres at the heart of your data-stack and move data at scale from Postgres to any of the above targets, PeerDB can help.
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. Supports native features such as rich data types incl. PostGIS, JSONB, streaming partitioned tables, TOAST Columns and so on.
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
Blazing fast initial load.
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 and GCP.
check
1-click provisioning
check
Advance metrics and monitoring dashboards
check
In-place online upgrades
check
Scale up and down
check
Out of the box Auth
check
IP Whitelisting and VPC Peering
PeerDB

Enterprise

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