Protocol-aware
Handles PostgreSQL startup, TLS, authentication, simple queries, prepared statements, and common driver behavior on the wire.
Place Safe Boundary between an application, ORM, psql session, or database tool and PostgreSQL. It understands the wire protocol and SQL structure, then blocks or rewrites requests before they reach the database.
TARGETPOSTGRESQLWhy this exists
In default passthrough mode, PostgreSQL authentication is relayed and the database still sees the caller’s upstream role. Existing grants and row-level security stay in force.
Observe mode records what policy would do while forwarding unchanged traffic. Enforce mode activates read-only blocking, masking rewrites, dangerous-function denial, and fail-closed handling.
What it does
Handles PostgreSQL startup, TLS, authentication, simple queries, prepared statements, and common driver behavior on the wire.
Passthrough authentication preserves the PostgreSQL role, so grants and RLS remain authoritative for row access.
Syntax errors, non-read-only statements, unsafe functions, and unredactable protected output are refused in enforce mode.
How it works
Run the proxy beside the workload or in the same private network as PostgreSQL.
Change host and port while retaining the upstream database identity.
Exercise real traffic and inspect would-block and would-mask events.
Activate policy after the rules match the intended access path.
Protected when
Important boundaries
Continue the story
See how the three enforcement surfaces share policy and audit semantics.
Understand trust boundaries, credentials, identity, and bypass conditions.
See which paths keep database row policy intact.
Start in observe mode, validate the policy against representative traffic, and move to enforcement with explicit bypass controls.