Execute Read-Only SQL
execute_sqlExecute a read-only SQL SELECT query against the Compabase database. Use when dedicated tools are not enough (aggregations, joins, custom analysis). Returns at most row_limit rows per call depending on the plan (Free 100, Pro 500, Scale 1000); if truncated is true, aggregate inside SQL (GROUP BY, COUNT, AVG, percentile_cont) instead of listing raw rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | A read-only SQL SELECT or WITH…SELECT statement. |