duckdb-fileslisted
Install: claude install-skill srimon12/duckdb-2-skills
# Data files
Execute DuckDB with `duckdb`. For Shapefile, GeoPackage, or FlatGeobuf, see `duckdb-spatial`. GeoJSON reads natively through `read_json`. For database catalogs and multi-database attachments, see `duckdb-session` or `duckdb-lakehouse`. For semi-structured `VARIANT` columns, see `duckdb-variant`.
Never build a single unified macro for all readers. A missing extension fails the entire statement. Pick the reader from the file path. When resolving a bare filename, search under the working tree and skip `.git`. In new SQL, write canonical names `read_csv`, `read_json`, and `read_parquet`. Names `read_csv_auto`, `read_json_auto`, and `parquet_scan` are separate registered overloads, not aliases.
## Reader dispatch
| Path | Statement |
| --- | --- |
| `.csv`, `.tsv` | `FROM read_csv('path')`; `.tsv` sniffs the tab delimiter |
| `.tab`, `.txt` | `FROM read_csv('path')`; bare paths do not dispatch |
| `.json` | `FROM read_json('path')`; auto-detects array or NDJSON |
| `.jsonl`, `.ndjson` | `FROM read_json('path', format = 'newline_delimited')` |
| `.parquet`, `.pq`, or directory | `FROM read_parquet('path')`; `.parquet` bare-reads, `.pq` requires explicit function |
| `.avro` | `FROM read_avro('path')`; autoloads `avro` |
| `.xlsx` | `FROM read_xlsx('path')`; autoloads `excel` |
| `.sqlite`, `.sqlite3` | `ATTACH 'path' AS s (TYPE sqlite);` then `SHOW TABLES` |
| `.db`, `.duckdb` | `FROM read_duckdb('path', table_name = '...')` or bare `FROM 'path'`. Bare reads requir