The query hit the database, but something moved between you and Postgres. A proxy. Silent, precise, built for evidence collection automation.
When you need to capture every byte without slowing the system, proxying the Postgres binary protocol is one of the most reliable approaches. It sits between client and server, decoding startup messages, queries, parameters, and results. This level of visibility makes it possible to record exact commands, timing, and responses with zero guesswork.
Evidence collection automation requires fidelity. Log scraping or statement logging in Postgres can miss details or introduce delay. A binary protocol proxy processes traffic in real time, both directions, without impacting upstream application logic. The proxy can filter, store, and forward the traffic while maintaining the wire format integrity for accurate replay or audit.
By working at the protocol layer, you can add rules for session authentication capture, transaction boundary detection, and batch analysis. You can route queries to storage for compliance, security audits, or anomaly detection workflows while still keeping connections open and responsive. Integrating this system with existing evidence pipelines allows automated ingestion into long-term archives or real-time alerting systems.
For automation, the proxy can tag session metadata such as source IP, application name, or TLS certificate fingerprint. Captured data can be transformed into structured JSON or binary blobs, indexed for fast lookups, or streamed to analysis engines. The automation layer can trigger actions on specific query patterns, errors, or DDL events without touching your application code.
Postgres binary protocol proxying lets you scale evidence collection without risking transaction integrity. The database sees clean, unaltered packets. Your systems see a complete and accurate record, automatically processed and archived.
Run it once, and you’ll never guess again at what your database actually saw. See how this works in production at hoop.dev — spin it up and watch it live in minutes.