PGSync Pro - PGSync

Skip to content

Requirements

Getting started

Django integration

Environment variables

Command arguments

Schema definition

Tutorial - User Guide

Advanced - User Guide

Scaling

License

References

PGSync Pro¶

Real-time semantic & hybrid search for PostgreSQL — that only re-embeds<br>when meaning changes.

Demo<br>Pricing<br>How it works

Your database stays the source of truth — PGSync Pro keeps a fresh vector index<br>in lock-step, and only pays to embed when meaning actually changes. Built on<br>PGSync, which syncs PostgreSQL, MySQL and MariaDB to Elasticsearch /<br>OpenSearch.

PGSync Pro data flow<br>PostgreSQL streams changes through PGSync and PGSync Pro into Elasticsearch, in real time.

REAL-TIME<br>in lock-step

PostgreSQL<br>MySQL<br>MariaDB<br>your source of truth

PGSync<br>change data capture

Elasticsearch<br>OpenSearch<br>search by meaning

PGSync Pro<br>embeddings · change-guard

See it live — no signup

Type an idea, not keywords. On the live demo, searching “a rebellion<br>against a watchful state” returns Nineteen Eighty-Four — a book that<br>shares none of those words. That's the difference between matching words and<br>matching meaning, kept in sync with the database in real time.

Try the live demo

What you get&para;

Always fresh

Vectors stay in sync with your database via CDC. No nightly reindex jobs, no<br>stale search results.

The change-guard

Re-embed only when the embedded text changes. Unrelated column updates are<br>free — and easy on your embedding bill.

Semantic + hybrid

Vector kNN fused with keyword BM25 (reciprocal rank fusion) — the best of<br>meaning and exact match.

Runs in your infra

Local sentence-transformers embeddings mean text never leaves your<br>environment. OpenAI / Cohere / Voyage optional.

Agent-ready (MCP)

An MCP server exposes search to Claude Desktop, Claude Code, or your own<br>agent — retrieval over live data.

Preflight checks

pgsync-pro validate verifies your schema and connections before indexing —<br>catching mistakes with actionable errors.

PGSync and django-pgsync stay free and MIT forever. Pro adds the semantic layer<br>on top — the same schema.json and CLI, plus an embedding block.

Next: try the live demo, watch the pipeline animated, then pick a plan.

Try the live demo<br>How it works<br>See pricing

Back to top

Copyright &copy; 2026 Tolu Aina &middot; Terms &middot; Privacy