eulerto/wal2json

Health v2 · maintenance only

Adoption not part of the score

1508 stars · 168 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

wal2json is a PostgreSQL logical decoding output plugin written in C that converts write-ahead log changes (INSERT, UPDATE, DELETE) into JSON. It supports streaming via logical replication slots or a SQL API, with two output formats (one JSON object per transaction or per tuple).

Use cases

• stream postgres changes as json for cdc
• capture database changes for event-driven pipelines
• replicate postgres data to kafka or other systems
• audit trail of row changes in postgresql
• consume logical replication slots as json

When to choose

• you need change data capture from PostgreSQL with JSON output
• you want to feed Postgres changes into Debezium, Kafka, or ETL pipelines
• you need access to old row versions on UPDATE/DELETE via replica identity

When to avoid

• you use a database other than PostgreSQL
• you need non-JSON output formats like Avro or Protobuf
• you run PostgreSQL older than 9.4

Facets

plugin · maturity stable

serialization database streaming databases developer-tools windows self-hosted postgresql logical-decoding cdc change-data-capture replication json c data-engineering linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="eulerto/wal2json")