PeerDB SQL Reference

PeerDB Docs: Setup your ETL in minutes with SQL.

Welcome to PeerDB docs. Here you'll find everything you need to get started with PeerDB.

PeerDB

Architecture Overview

Why choose PeerDB over other tools?

Get started with PeerDB in a few simple steps.

Quickstart Guide

Get started with PeerDB Streams for Kafka in a few simple steps.

PeerDB Streams for Kafka Quickstart Guide

SQL Quickstart Guide

Get started with PeerDB Cloud in a few simple steps.

PeerDB Cloud Quickstart Guide

Learn about how PeerDB Cloud ensures the security of your data.

PeerDB Cloud Security

PeerDB Cloud Pricing FAQ

Trust Center

Public IPs For PeerDB Cloud

AWS Private Link

Snowflake Setup Guide

BigQuery Setup Guide

GCS Setup Guide

S3 Setup Guide

Elasticsearch Setup Guide

Kafka Setup Guide

Confluent Cloud Setup Guide

PubSub Setup Guide

CDC Setup from Postgres to ClickHouse

CDC Setup from Supabase to ClickHouse

CDC Setup from Neon Postgres to ClickHouse

CDC Setup from Postgres to Bigquery

CDC Setup from Postgres to Snowflake

CDC Setup from Postgres to Postgres

CDC Setup from Postgres to Kafka

CDC Setup from Postgres to Elasticsearch

Streaming Query Replication of PostgreSQL To Snowflake

Pausing a CDC Mirror

Editing a CDC Mirror

Resyncing a CDC Mirror

Schema Changes Propagation Support

Postgres to ClickHouse: Data Modeling Tips

Heartbeat Table For CDC

Upgrading the PostgreSQL Peer Of An Ongoing CDC Mirror

Generated Columns: Gotchas and Best Practices

Postgres to ClickHouse: Handling TOAST Columns

Query Federation via PostgreSQL

Running Flow tests

Config Tuning for Change Data Capture (CDC)

Native Metrics

Creating Peers

Guide to creating synchronization jobs in PeerDB

Creating Mirrors

PeerDB API Reference

PeerDB Lua Scripting

PubSub

EventHubs

SQL Reference

API Reference

Lua Reference

GitHub

Changelog

Community

Get Started

RDS Postgres Source Setup Guide

Supabase Postgres Source Setup Guide on PeerDB Cloud

Supabase Postgres Source Setup Guide

Google CloudSQL Postgres Source Setup Guide

Azure Flexible Server Postgres Source Setup Guide

Crunchy Bridge Postgres Source Setup Guide

Neon Postgres Source Setup Guide

Generic PostgreSQL Source Setup Guide

Unsupported PostgreSQL Providers

ClickHouse Cloud Setup Guide

ClickHouse Setup Guide

Slack Alerting

Email Alerting

Overview

PostgreSQL To PostgreSQL

PostgreSQL to BigQuery

PostgreSQL To Snowflake

PostgreSQL To Azure Event Hubs

PostgreSQL To AWS S3 And Google Cloud Storage

PostgreSQL to PostgreSQL

PostgreSQL to S3

PostgreSQL to Snowflake

SQL Server to PostgreSQL

Create a Postgres peer

Create a ClickHouse peer

Create a Kafka peer

Create a Snowflake peer

SQL Commands