mutation_preview
Preview INSERT, UPDATE, or DELETE effects without executing. Shows estimated rows affected and sample rows to verify impact before running destructive queries.
Instructions
Preview the effect of INSERT/UPDATE/DELETE without executing. Shows estimated rows affected and sample of rows that would be modified. Use this before running destructive queries to verify the impact. Optionally use server/database/schema params for one-time execution on a different server.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The INSERT, UPDATE, or DELETE statement to preview | |
| sampleSize | No | Number of sample rows to show (default: 5, max: 20) | |
| server | No | One-time server override. Execute on this server without changing main connection. | |
| database | No | One-time database override. Uses this database for execution. | |
| schema | No | One-time schema override. Sets search_path for this execution only. |