Execute Read-Only SQL Query
unfour.db.query_readonlyExecute read-only SQL queries against a saved database connection. Run SELECT, WITH, SHOW, DESCRIBE, DESC, or EXPLAIN statements while write operations and multi-statement queries are rejected.
Instructions
Executes a read-only SQL query against a saved database connection through the Unfour command bus. Only SELECT, WITH, SHOW, DESCRIBE, DESC, and EXPLAIN statements are allowed. Write operations, DDL, and multi-statement queries are rejected. Optional catalog, schema, and timeoutMs match unfour.db.execute and unfour.db.explain.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Required SQL query. Only read-only statements are allowed. | |
| limit | No | Maximum number of rows to return (default 100, max 1000). | |
| schema | No | Optional schema to resolve unqualified names against. | |
| catalog | No | Optional catalog (database) to run the query against. | |
| timeoutMs | No | Optional per-statement timeout in milliseconds. | |
| workspaceId | No | Optional workspace ID. Uses the active workspace if omitted. | |
| connectionId | Yes | Required saved database connection ID. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ok | Yes | ||
| rows | No | ||
| source | Yes | ||
| columns | No | ||
| rowCount | No | ||
| truncated | No | ||
| durationMs | No | ||
| connectionId | Yes |