MySQL Atomic Execute
mysql_transaction_executeExecute multiple SQL statements in a single atomic transaction, ensuring all succeed or all roll back.
Instructions
Execute multiple SQL statements atomically. All statements succeed or all are rolled back.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | Alias for statements | |
| level | No | Alias for isolationLevel | |
| query | No | Alias for statements | |
| queries | No | Alias for statements | |
| statements | No | SQL statements to execute atomically. Anti-Hallucination Hint: Pass an array of strings. You can also pass a single string or use the 'queries' or 'sql' alias. | |
| isolationLevel | No | Transaction isolation level. Expected one of: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE | |
| isolation_level | No | Alias for isolationLevel |
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) | |
| rolledBack | No | ||
| suggestion | No | Suggested fix for the error | |
| recoverable | No | Whether the error is recoverable |