> ## Documentation Index
> Fetch the complete documentation index at: https://docs.peerdb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Feature matrix

<Warning>
  The actively-maintained destinations are **ClickHouse**, **ClickHouse Cloud**, and **Postgres**. Snowflake, ElasticSearch, Kafka (including the Confluent and Redpanda variants), Azure Event Hubs, Google Pub/Sub, S3, GCS, and BigQuery as a destination are deprecated and no longer actively maintained. They remain fully functional and no code is currently being removed. BigQuery is deprecated **only as a destination**; it remains a **supported source**.

  Query Based or Watermark Based Replication (QRep), including XMIN-based replication, is also a deprecated mirror type. We recommend [CDC (Change Data Capture)](/usecases/real-time-cdc/overview) as the actively-maintained mirror type for new mirrors.
</Warning>

# WAL or Change Data Capture (CDC) Based Replication

Below table shows supported features and features we are working on for WAL or CDC Based replication from **Postgres** to different targets.
✅ means supported. 🛠️ means **Work in Progress and Coming Soon!**.

## Warehouses

| Feature | Snowflake | BigQuery | Clickhouse | Postgres | S3/GCS |
| - | - | - | - | - | - |
| [Initial Snapshot - Parallelizable](https://blog.peerdb.io/parallelized-initial-load-for-cdc-based-streaming-from-postgres#heading-parallelized-initial-snapshot-for-cdc-based-streaming) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Incremental Sync (CDC) | ✅ | ✅ | ✅ | ✅ | ✅ |
| DML Support - INSERT, UPDATE and DELETE | ✅ | ✅ | ✅ | ✅ | ✅ |
| [Schema Changes](/features/schema-changes) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Soft Delete | ✅ | ✅ | 🛠️ | ✅ | ✅ |
| [Partitioned Tables](/features/replicating-partitioned-tables) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc. | ✅ | ✅ | ✅ | ✅ | ✅ |
| Advanced Monitoring - Lag, Throughput, Postgres Wait Events etc | ✅ | ✅ | ✅ | ✅ | ✅ |
| Resync Mirrors | ✅ | ✅ | ✅ | ✅ | ✅ |
| Column Exclusion | ✅ | ✅ | ✅ | ✅ | ✅ |
| Add Tables | ✅ | ✅ | ✅ | ✅ | ✅ |

## Queues

| Feature | EventHubs | Kafka | Redpanda | PubSub |
| - | - | - | - | - |
| [Initial Snapshot - Parallelizable](https://blog.peerdb.io/parallelized-initial-load-for-cdc-based-streaming-from-postgres#heading-parallelized-initial-snapshot-for-cdc-based-streaming) | 🛠️ | ✅ | ✅ | ✅ |
| Incremental Sync (CDC) | ✅ | ✅ | ✅ | ✅ |
| DML Support - INSERT, UPDATE and DELETE | ✅ | N/A | N/A | N/A |
| [Schema Changes](/features/schema-changes) | ✅ | 🛠️ | 🛠️ | 🛠️ |
| [Partitioned Tables](/features/replicating-partitioned-tables) | ✅ | ✅ | ✅ | ✅ |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc. | ✅ | ✅ | ✅ | ✅ |
| Advanced Monitoring - Lag, Throughput, Postgres Wait Events etc | ✅ | ✅ | ✅ | ✅ |
| Resync Mirrors | 🛠️ | N/A | N/A | N/A |
| Column Exclusion | ✅ | ✅ | ✅ | ✅ |

# Query Based or Watermark Based Replication

<Warning>
  Query Based or Watermark Based Replication (QRep), including XMIN-based replication, is a deprecated mirror type and no longer actively maintained. It remains fully functional and no code is currently being removed. We recommend [CDC (Change Data Capture)](/usecases/real-time-cdc/overview) as the actively-maintained mirror type for new mirrors.
</Warning>

Below table shows supported features and features we are working on for Query Based or Watermark Based Replication from **Postgres** to different targets.
✅ means supported. 🛠️ means **Work in Progress and Coming Soon!**.

| Feature | Snowflake | BigQuery | Postgres | S3/GCS |
| - | - | - | - | - |
| Initial Snapshot | ✅ | ✅ | ✅ | ✅ |
| Incremental Sync Based on Watermark | ✅ | ✅ | ✅ | ✅ |
| DML Support - INSERT, UPDATE (if updated\_at & primary key are present) | ✅ | ✅ | ✅ | ✅ |
| Schema Changes - ADD COLUMN | ✅ | 🛠️ | 🛠️ | 🛠️ |
| Resync Mirrors | ✅ | 🛠️ | 🛠️ | 🛠️ |
| Partitioned Tables | ✅ | ✅ | ✅ | ✅ |
| Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc. | ✅ | ✅ | ✅ | ✅ |
| Advanced Monitoring - Throughput, Postgres Wait Events etc | ✅ | ✅ | ✅ | ✅ |
| Column Exclusion | ✅ | ✅ | ✅ | ✅ |

# Transformations

Below table shows what targets we support transformations and their status

| Target | Status |
| - | - |
| EventHubs | ✅ |
| Kafka / Redpanda | ✅ |
| PubSub | ✅ |
| Snowflake | Private Preview |
| BigQuery | Private Preview |
| Clickhouse | Private Preview |
| Postgres | Private Preview |
| S3/GCS | Private Preview |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.