Build real‑time search indexes with Postgres change data capture (CDC) and Elasticsearch. Learn to keep your search indices in sync with your database.
Source configuration
insert
, update
, delete
) you care about.in_stock = true
to index only a subset of rows.Backfill existing rows
Transform rows to documents
_id
from the table’s primary key. Let us know if you need to use a different _id
field.Typical transform:record
unchanged.
See the Elasticsearch ingest best‑practices for mapping guidance.Delivery settings
http://host.docker.internal:9200
(or your cluster URL)products
api_key
<api-key>
Create the sink
products-elasticsearch
) and click Create sink. Sequin queues a backfill (if selected) and then starts streaming live changes.