execute_script
Run multiple SQL statements separated by semicolons, each in its own transaction. Returns per-statement status: OK or error.
Instructions
Execute multiple SQL statements separated by semicolons. Each runs in its own transaction. A failure on one statement does NOT roll back previously committed statements — there is no global rollback. Returns one status line per statement: 'OK: ...' or 'ERROR: on: ...'. For a single statement prefer execute_ddl or execute_dml.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database key from list_databases. | |
| sqlScript | Yes | Semicolon-separated DDL or DML statements. Each is trimmed and committed independently. WARNING: already-committed statements cannot be rolled back if a later one fails. |