Learn how to create real-time Elasticsearch indexes from Postgres changes in minutes using Sequin.
Create directory and start services
Alternative: Download with curl
Alternative: Clone the repository
Verify services are running
docker ps
:Up
).Open the web console
Login with default credentials
sequin_playground
with a sample dataset in the public.products
table.Let’s take a look:Navigate to Databases
Select playground database
sequin-playground
database:View contents of the products table
products
table. Run the following command:psql
command.products
table:products
index that will receive documents.<api-key>
with the API key you copied earlier.Head back to the Sequin console and navigate to the Sinks tab
Select sink type
Verify source configuration
sequin_playground
database and the products
table pre‑selected. Leave the defaults.Add a transform
products-elasticsearch
and click Create transform.Select the transform
Configure a backfill
Configure Elasticsearch
http://host.docker.internal:9200
products
api_key
<api-key>
(copied earlier)Create the sink
products-elasticsearch
, and click Create Sink.Sequin will first backfill all rows from the products
table, then stream every change in real‑time.products
table into Elasticsearch. When it completes, you should see the sink health is green and the backfill card displays Processed 6 and ingested 6 records in 1s
.You can now query your data in Elasticsearch:Insert a product
Update a product's price
Change a product's name
Delete a product