← ClaudeAtlas

duckdb-fileslisted

Read, preview, convert, and batch-ingest data files with DuckDB 2.0. Covers CSV, Parquet, JSON, Avro, Excel, SQLite, HTTP, object storage, rejected rows, partitioned writes, secrets, and asynchronous I/O. Use when the user points at a data file or an s3://, https://, gs://, or az:// URL, asks for parquet, csv, json, or xlsx output, or wants a repeatable batch load.
srimon12/duckdb-2-skills · ★ 1 · Data & Documents · score 65
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