csv_query
Fetch CSV from a URL or raw text, then query it by selecting columns, filtering rows, sorting, and limiting results. Returns JSON or CSV.
Instructions
Fetch a CSV from a URL (or accept raw CSV text) and query it: select columns, filter rows, sort, and limit results. Provide exactly one of url or csv — not both. Returns a JSON array of objects (default) or CSV text when format=csv. Returns an error if the URL is unreachable, returns a non-2xx status, or the content cannot be parsed as CSV. Has no side effects. Use instead of loading the full CSV into your context — send only the data you need.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | No | Raw CSV text (alternative to url). | |
| url | No | URL of the CSV file to fetch (http/https). | |
| limit | No | Maximum number of rows to return (default 500, max 5000). | |
| filter | No | Row filter expression: 'column op value'. Operators: = != > >= < <= contains startswith endswith. E.g. 'age > 30' or 'country = US'. | |
| format | No | Output format: 'json' (default) or 'csv'. | |
| select | No | Comma-separated column names to include (e.g. 'name,age,country'). Omit to include all columns. | |
| sort_by | No | Column name to sort by. | |
| sort_dir | No | Sort direction: 'asc' (default) or 'desc'. |