Description
PG-Capture is a small open-source utility for schema-based change data capture (CDC) on Postgres. Ordinary CDC emits one event per changed row in one table, such as an INSERT on a book table. PG-Capture lets you write a schema describing the document your application actually needs, for example a book with its author's name joined in through a many-to-one relation, and then aggregates those low-level table events into high-level upsert and delete events for that document. This lets you keep Postgres as your primary database while keeping complex, denormalized views in sync with Elasticsearch, Algolia, Redis or another store, with eventual consistency. It does not capture events itself: you can feed it from any capture tool, such as Debezium or a WAL listener, and publish its output to any provider, such as RabbitMQ, Redis or Elasticsearch. It is published on npm and GitHub.…
Highlights
- Schema-based aggregation of Postgres change events
- Turns row-level events into document upserts and deletes
- Supports relations such as many-to-one
- Works with Debezium, WAL listeners and other capture tools
- Publishes to RabbitMQ, Redis, Elasticsearch and more
Ratings & Reviews
No ratings yet
Be the first to rate PG-Capture.
People also visit
PG Easy Replicate
Easily setup logical replication and switchover to new database
PG-Capture FAQ
What does PG-Capture do?
It takes table-level Postgres change events and, based on a schema you write, aggregates them into high-level events for the documents your application uses.
Why would I use it?
To keep Postgres as your main database while syncing complex schemas to stores like Elasticsearch, Algolia or Redis with eventual consistency.
Does it capture changes from Postgres itself?
No. It is agnostic: you capture events with any service, such as Debezium or a WAL listener, and it can publish to any provider such as RabbitMQ, Redis or Elasticsearch.
Where can I get it?
It is available on npm and its source is on GitHub at Tggl/pg-capture.
What are the best PG-Capture alternatives?
Popular alternatives to PG-Capture include Pgcapture, Sequin and PG Easy Replicate. See all PG-Capture alternatives






