SQL & Data Schemas
Schema reference for parameterized query and gated write payloads with audit metadata.
Query request
`SqlQueryRequest` includes the prepared statement, parameters, schema hints, and budget thresholds.
- `timeout_ms` defaults to 10,000 but can be overridden per workspace.
- `result_format` toggles between table, JSON, or CSV outputs.
- `policy_context` enforces tenant-specific allowlists.
Execution proposal
`SqlExecutionProposal` lists the statement, sanitized preview, and estimated row impact. Approvers respond with `SqlExecutionDecision` objects that include rollback plans.
- `change_diff` uses data sampling to show before/after values.
- `impact_score` highlights risky operations for extra scrutiny.
- `notification_hooks` alert downstream systems when writes occur.