wal2json
« Back to VersTracker
Description:
Convert PostgreSQL changesets to JSON format
Type: Formula  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: postgresql json replication cdc database
Install: brew install wal2json
About:
Wal2json is a PostgreSQL logical decoding plugin that extracts changes from the write-ahead log (WAL) and converts them into a structured JSON format. It enables real-time data streaming and change capture without heavy database queries. This makes it ideal for building reactive applications, data pipelines, and external integrations.
Key Features:
  • Outputs changes as JSON objects
  • Supports multiple output formats (e.g., insert, update, delete)
  • Configurable filtering for tables and operations
  • Integrates with PostgreSQL logical replication
Use Cases:
  • Real-time data synchronization with external systems
  • Auditing and logging database changes
  • Building event-driven architectures
Alternatives:
  • pg_recvlogical – PostgreSQL's native tool for receiving WAL data, but outputs in a binary format requiring custom parsing.
Version History
Detected Version Rev Change Commit
Sep 15, 2025 4:20pm 0 VERSION_BUMP 348f913e
Sep 27, 2024 8:04pm 0 VERSION_BUMP 3c6b5337