index_local
Index local CSV, Excel, Parquet, or JSONL files by profiling columns, detecting types, computing statistics, and loading into SQLite for fast filtered queries. Avoids re-indexing unchanged files.
Instructions
Index a local data file (CSV, Excel, Parquet, or JSONL). Profiles all columns, detects types, computes statistics, and loads rows into SQLite for fast filtered retrieval. Set incremental=true (default) to skip re-indexing if file is unchanged. CSV, Excel, Parquet and JSONL only; any other format is rejected.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | Dataset identifier override (defaults to filename stem) | |
| path | Yes | Absolute path to data file (.csv, .tsv, .xlsx, .xls, .parquet, .jsonl, .ndjson) | |
| depth | No | Profiling depth (B7). 'shallow' caps at 100k rows for fast first-look; 'standard' is the full profile (default); 'deep' additionally precomputes correlations. | standard |
| sheet | No | Excel sheet name to index (default: first sheet) | |
| encoding | No | File encoding override (auto-detected if omitted) | |
| delimiter | No | CSV delimiter override (auto-detected if omitted) | |
| header_row | No | Row number containing column headers, 0-indexed (default 0) | |
| incremental | No | Skip re-index if file hash unchanged (default true) |