Execute non-production MySQL statement
mysql_executeRun one parameterized DML or DDL statement on a non-production MySQL connection, with production writes blocked and DDL or unfiltered updates/deletes requiring explicit opt-in.
Instructions
Execute one parameterized DML or DDL statement on a non-production connection. Never runs against a connection marked prod. Use mysql_execute_transaction for atomic multi-statement DML; run DDL separately because MySQL may implicitly commit it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Exactly one non-read SQL statement. Prod connections and explicit transaction/session-control statements are rejected. | |
| allow_all | No | Explicitly permit UPDATE or DELETE without WHERE. | |
| allow_ddl | No | Explicitly permit DDL, which may implicitly commit and cannot reliably be rolled back. | |
| parameters | No | Positional values for SQL ? placeholders. Values may be string, finite number, boolean, or null. | |
| timeout_ms | No | Client-side query timeout in milliseconds, from 1000 through 120000. | |
| connection_id | Yes | Configured connection ID, for example prod-main or test-main. | |
| response_format | No | Response rendering: markdown for humans or json for programmatic processing. | markdown |