run_query
Execute read-only SELECT queries on Firebird databases using FlameRobin configurations. Returns results as row objects, with support for limiting rows and selecting specific columns.
Instructions
Execute a read-only SELECT query and return results as row objects. If unsure about column names or types, call describe_table or inspect_table first — do not guess schema. IMPORTANT Firebird SQL differences: use 'SELECT FIRST n' or 'ROWS n' to limit rows — 'LIMIT n' is invalid. String concatenation uses '||' not '+'. Returns [{column: value, ...}] per row.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database key from list_databases. | |
| sql | Yes | A SELECT statement in Firebird SQL. No trailing semicolon. Use 'SELECT FIRST n' or 'ROWS n' to cap rows at the SQL level. | |
| maxRows | No | Server-side row cap. Defaults to 100. Raise only when you genuinely need more rows. | |
| columns | No | Comma-separated column names to include. Omit to return all columns. Use to reduce output on wide tables. |