Run SQL
fastero_run_sqlRun a read-only query against one of this organisation's connected databases — PostgreSQL, MySQL, SQL Server, Redshift, Snowflake, Oracle, BigQuery or Google Sheets, or an uploaded CSV or Excel file made queryable with fastero_create_file_connection (DuckDB) — in that connection's own SQL dialect, and return rows. One SELECT, WITH, EXPLAIN or SHOW statement; a statement that could change data is refused. It returns at most 500 rows and about 100 KB: a larger result comes back cut, with truncated: true and totalRows, so prefer a LIMIT or an aggregate. Where a question involves a business number (revenue, churn, active users…), fastero_get_definitions holds this organisation's own expression for it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| connectionId | Yes | A data connection’s id, from fastero_list_connections; fastero_create_file_connection makes one of an uploaded CSV or Excel file. |