analyze_impact
Preview the impact of DELETE, UPDATE, or DROP queries on a PostgreSQL database without executing them. Shows affected rows and rollback SQL to assess risk.
Instructions
Preview DELETE/UPDATE/DROP impact WITHOUT executing. Shows affected rows and rollback SQL.
LEVEL: Query (write operation preview - never executes)
USE FOR: previewing write impact, cascade effects, risk assessment. DO NOT USE FOR: reading data (execute_query), INSERT operations.
Examples: analyze_impact(query="DELETE FROM users WHERE status='inactive'", schema='public') analyze_impact(query="UPDATE orders SET status='cancelled' WHERE id=1", schema='shipment')
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL DELETE/UPDATE/DROP query to preview | |
| sample_limit | No | Sample rows to show | |
| timeout_ms | No | Timeout in ms (5 min default) | |
| schema | No | Schema containing the table. REQUIRED. Use get_schema() to list available schemas. | |
| format | No | Output format | json |
| url | No | Database URL |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |