Query CSV (SQL-like)
query_csvRun SQL-like SELECT queries on a CSV file: choose columns, filter rows with numeric-aware WHERE, sort with ORDER BY, and use DISTINCT, LIMIT, or OFFSET. Returns up to 1000 rows.
Instructions
SQL-like SELECT over a CSV: choose columns, WHERE conditions, ORDER BY, DISTINCT, LIMIT/OFFSET. Numeric-aware comparisons. Returns at most 1000 rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | CSV path relative to the allowed directory (CSV_INSIGHTS_DIR), e.g. 'sales/2026-q3.csv' | |
| limit | No | Default 100 | |
| where | No | Row filters, all must match (AND) | |
| offset | No | ||
| select | No | Columns to return (default all) | |
| distinct | No | ||
| order_by | No |