MySQL Write Query
mysql_write_queryExecute write SQL queries (INSERT, UPDATE, DELETE) on MySQL databases using prepared statements for secure data modification.
Instructions
Execute a write SQL query (INSERT, UPDATE, DELETE). Uses prepared statements for safety.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tx | No | Alias for transactionId | |
| sql | No | Alias for query | |
| txId | No | Alias for transactionId | |
| query | No | SQL INSERT/UPDATE/DELETE query to execute | |
| params | No | Query parameters for prepared statement | |
| transactionId | No | Optional transaction ID for executing within a transaction |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | No | Error code (e.g. VALIDATION_ERROR, QUERY_ERROR) | |
| data | No | ||
| error | No | Error message if operation failed | |
| details | No | Additional error context | |
| metrics | No | Token estimation metrics | |
| success | Yes | Whether the operation succeeded | |
| category | No | Error category (validation, query, connection, internal) | |
| suggestion | No | Suggested fix for the error | |
| recoverable | No | Whether the error is recoverable |