run_write
Run write SQL statements with a built-in safety mechanism: destructive operations first display a risk summary and require user approval before execution.
Instructions
Run a write SQL statement (INSERT, UPDATE, DELETE, TRUNCATE, DROP, ALTER). IMPORTANT: For destructive operations (DELETE, TRUNCATE, DROP, UPDATE without WHERE, ALTER TABLE ... DROP COLUMN) you MUST first call this tool WITHOUT confirm to get a risk summary, show it to the user and ask for explicit approval, then call again with confirm: true. Never pass confirm: true on the first call without user approval.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL statement to execute | |
| confirm | No | Set to true only after the user has explicitly approved the risk shown by a prior call to this tool | |
| connectionId | Yes | Connection ID from list_connections | |
| project_root | No | Absolute path to the current project directory (same value passed to list_connections) |