toluaina/pgsync
Some data may be outdated — see provenance labels.
Postgres, MySQL, or MariaDB to Elasticsearch/OpenSearch sync observed · 2026-10-01
Health v2 · maintenance only
95/100
- Activity 96
- Release rhythm 90
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-10-21. Adoption (stars, forks) is never an input.
- gap_med: 20.5
- age_days: 2621
- days_rel: 68
- days_push: 29
- n_releases_24m: 19
Adoption not part of the score
1423 stars · 212 forks observed · 2026-10-01
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
PGSync is an open-source (MIT) change data capture tool that syncs PostgreSQL, MySQL, or MariaDB data to Elasticsearch or OpenSearch in real time via logical replication. Document schemas are defined declaratively in JSON, producing denormalized nested documents with no custom ETL code.
Use cases
- keep elasticsearch in sync with postgres in real time
- sync mysql database to opensearch
- build denormalized search documents from relational tables
- change data capture from postgres wal to search engine
- index nested related tables into elasticsearch without custom code
- resume elasticsearch indexing after crashes without data loss
When to choose
- you need real-time, transactionally consistent search indexing from a relational database
- you want declarative JSON schema-driven denormalization of nested relationships
- you need fault-tolerant CDC that resumes from checkpoints
- you prefer self-hosted sync middleware with no custom ETL code
When to avoid
- you need semantic/vector search out of the box - that requires the paid PGSync Pro tier
- you want to sync to ClickHouse - that is a separate paid product (free only for single-table mirror)
- your source database does not support logical replication or you cannot grant superuser/replication privileges
- you need a fully managed hosted sync service
Facets
service · maturity active
etl search-engine database streaming cli databases developer-tools python self-hosted cli change-data-capture elasticsearch opensearch postgresql mysql mariadb logical-replication denormalization open-core search data-engineering docker linux macos
10 sources
- readme: https://github.com/toluaina/pgsync · fetched 2026-10-01 · 243702c8e6ab
- homepage: https://pgsync.com · fetched 2026-08-29 · fe1483e0243f
- site_page: https://pgsync.com/features · fetched 2026-08-29 · 425ca1d9f3d0
- site_page: https://pgsync.com/getting-started/setup · fetched 2026-08-29 · ce5c38962257
- site_page: https://pgsync.com/getting-started/installation · fetched 2026-08-29 · 6c3d154dd6aa
- registry_pypi: https://pypi.org/pypi/pgsync/json · fetched 2026-08-29 · a623c9efdb00
- site_page: https://pgsync.com/pricing · fetched 2026-08-29 · c1ba7396d55d
- site_page: https://pgsync.com/pro/pricing · fetched 2026-08-29 · 1559cc6fc3d9
- site_page: https://pgsync.com/pro/faq · fetched 2026-08-29 · 2e485422f2a4
- site_page: https://pgsync.com/clickhouse/pricing · fetched 2026-08-29 · 7c9f107f3b44
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| toluaina/pgsync | main | 95 |
For agents
Data as of 2026-10-19T08:05:51.212177+00:00 · Report a problem