Skip to content

PGSync Pro

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

See pricing See how it works

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

PGSync Pro data flow PostgreSQL streams changes through PGSync and PGSync Pro into Elasticsearch, in real time. REAL-TIME in lock-step PostgreSQL MySQL MariaDB your source of truth PGSync change data capture Elasticsearch OpenSearch search by meaning PGSync Pro embeddings · change-guard

What you get

  • Always fresh

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

  • The change-guard

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

  • Semantic + hybrid

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

  • Runs in your infra

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

  • Agent-ready (MCP)

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

  • Preflight checks

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

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

Next: see the whole pipeline animated, then the plans.

How it works See pricing