query
Execute SQL across CSV, Postgres, and REST API data sources via DuckDB, with cross-source joins, pagination, and read-only SELECT for safe exploration.
Instructions
Execute a SQL query against a registered data source using DuckDB. Returns up to --max-rows rows (default 1000). In read-only mode (default), only SELECT statements are allowed. Use source='_all' to query across all CSV sources with cross-source joins. Supports limit and offset for pagination.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The SQL query to execute | |
| limit | No | Maximum number of rows to return (pagination) | |
| offset | No | Number of rows to skip before returning results (pagination) | |
| source | No | Name of the source to query, or '_all' for cross-source joins. Required if multiple sources are registered. | |
| sources | No | Array of source names for cross-source queries (alternative to source='_all') | |
| max_rows | No | Override the default max row limit for this query |