query
Execute one SQL statement against MySQL and return JSON columns, rows, and truncation status; writes include affected-row and insert-ID details, with read-only access by default.
Instructions
Run one SQL statement. Returns JSON {columns, rows, truncated}: at most MYSQL_MAX_ROWS rows,
truncated true when cut; writes return {rows_affected, last_insert_id}.
Read-only (SELECT/SHOW/DESCRIBE/EXPLAIN/WITH) unless the server runs with MYSQL_ALLOW_WRITE=true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| database | No |