propose_write
Propose INSERT, UPDATE, DELETE, or DDL statements for review: validates SQL, previews affected-row diffs, and returns an approval token without executing immediately.
Instructions
Propose an INSERT, UPDATE, DELETE, or DDL statement. Validates SQL AST, shows preview diff of affected rows, and generates an approval token. NEVER executes immediately.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sql": "<sql>"
},
"name": "propose_write"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL statement (UPDATE/DELETE require a WHERE clause). | |
| params | No | Optional parameterized values. | |
| database | No | Optional database name. | |
| confirmBulk | No | Set to true if modifying more rows than the bulk threshold. |