run_query
Execute read-only SELECT queries on Firebird databases using Firebird SQL syntax, with optional row limits and column filtering to reduce result noise.
Instructions
Execute a read-only SELECT query and return results as a list of row objects. database: key from list_databases. sql: a SELECT statement using Firebird SQL syntax — use 'SELECT FIRST n ...' or 'SELECT ... ROWS n' to limit rows, NOT 'LIMIT n' (which is not valid Firebird syntax). maxRows: server-side cap on rows returned (default 500). columns: optional comma-separated column names to include — useful to reduce noise from wide tables. Returns a list of row objects keyed by column name.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | ||
| sql | Yes | ||
| maxRows | No | ||
| columns | No |