execute_sql
Run SQL statements against a guarded database under your own identity. Dangerous operations are blocked with a reason, and every statement is audited.
Instructions
Execute a SQL statement against the guarded database, under your own identity. Ordinary INSERT/UPDATE/DELETE/ALTER TABLE run and are audited. DROP TABLE, unapproved TRUNCATE, unapproved EXEC, and your own BEGIN/COMMIT/ROLLBACK TRAN statements are blocked before they ever reach the database - if blocked, the reason is returned so you can adjust and retry. A batch containing INSERT/UPDATE/DELETE runs in one transaction that is rolled back if any statement fails; DDL, TRUNCATE and EXEC run as they are and are not rolled back as part of a batch. When the server runs in read-only mode only queries are allowed and every other statement is blocked with a reason.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL statement to execute. |