Skip to content

PGSync

PGSync

Coverage Package version Python versions

PGSync keeps PostgreSQL/MySQL/MariaDB as your source of truth and publishes denormalized documents to Elasticsearch/OpenSearch—continuously and transactionally.

GitHub PyPI Docker

What is PGSync?

PGSync is a lightweight middleware that captures changes from PostgreSQL/MySQL/MariaDB and writes structured documents to your search cluster. Describe your document schema once (in JSON) and PGSync takes care of change capture, ordering, and delivery—no custom ETL code.

  • Transactionally consistent output (only committed writes; commit order preserved)
  • Low overhead on PostgreSQL/MySQL/MariaDB
  • Flexible mapping from relational data to nested documents