index_local
Profile and index local data files (CSV, Excel, Parquet, JSONL) by detecting column types, computing statistics, and loading rows into SQLite for fast filtered retrieval. Skips unchanged files with incremental mode.
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.
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) |