db_query
Execute read-only SQL SELECT queries against configured sqlite or MySQL/MariaDB databases. Supports row caps, output format selection, and requires a read-only database connection.
Instructions
Read-only SQL against a configured database profile (sqlite or mysql/MariaDB). DDL/DML blocked. Requires connections add-db --read-only; secrets via env:/secret only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SELECT query | |
| repo | No | Repository name | |
| format | No | toon (default) | json | |
| max_rows | No | Row cap (default 100) | |
| connection | Yes | Database profile name |