Catalog-aware mapping
Aliases, casts, stars, and supported nested PostgREST selections resolve back to concrete schema columns.
Define sensitive columns with explicit schema, table, and column rules. Safe Boundary maps query output to the catalog and returns type-compatible masked values.
Why this exists
The current product does not sample arbitrary cell values or promise autonomous data discovery. Operators define the naming rules that identify protected columns; Safe Boundary applies those rules consistently to supported PostgreSQL, MCP, and PostgREST reads.
Masking is applied in the response path or through SQL-aware projection rewriting, depending on the surface. If protected output cannot be safely mapped or represented, enforce mode can refuse it instead of returning raw data.
What it does
Aliases, casts, stars, and supported nested PostgREST selections resolve back to concrete schema columns.
Masks preserve compatible JSON and database types so clients do not receive a string where a UUID, number, or boolean is expected.
Unknown or unredactable protected output is blocked in enforce mode instead of silently passing through.
Mask shape
| Decision | Configured field | Illustrative raw value | Illustrative masked value |
|---|---|---|---|
| alice@example.com | masked@example.invalid | ||
| account_id | 9f1c… | 0000… | |
| amount / boolean | Type-specific source value | Compatible typed output |
How it works
Define schema, table, and column patterns for data that must not leave raw.
Run representative traffic and review would-mask decisions.
Adjust rules for aliases, data types, and intentionally public fields.
Turn on masking and fail-closed behavior for protected output.
Protected when
Important boundaries
Continue the story
Mask PostgREST responses and stop filters from becoming inference oracles.
See the supported projection rewrite boundary.
Understand trust boundaries, credentials, identity, and bypass conditions.
Start in observe mode and validate the policy against representative traffic before you enforce it. That gives the team evidence for each decision, along with explicit bypass controls for the cases that need a deliberate exception.