sql_execute
Execute SQL write statements (INSERT, UPDATE, DELETE) with built-in safety rails that block unsafe operations like missing WHERE clauses or DROP commands.
Instructions
Execute a write SQL statement (INSERT, UPDATE, DELETE) with safety rails.
Safety rules enforced by the engine:
DELETE/UPDATE without WHERE clause is BLOCKED
DROP TABLE/DATABASE/SCHEMA is BLOCKED
Use parameterized ? placeholders for values to prevent injection. For SELECT queries, use sql_query instead.
Examples: INSERT INTO tags (name, color) VALUES ('urgent', 'red') UPDATE documents SET source_type = 'markdown' WHERE doc_id = 'abc-123' DELETE FROM document_tags WHERE doc_id = 'abc-123' INSERT INTO metadata (key, value, doc_id) VALUES ('reviewer', 'alice', 'abc-123')
Args: statement: SQL write statement (INSERT, UPDATE, DELETE).
Returns: Dict with "affected_rows" count, or "error" if blocked.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| statement | Yes |