DuckDB Analytics
Run fast in-process analytics with DuckDB. Queries CSV, Parquet, and JSON directly, converts between formats, joins local files, and writes performant SQL for ad-hoc analysis without a server.
Maintained by the DuckDB team, this skill makes Claude a DuckDB specialist. It queries CSV, Parquet, and JSON files directly, converts between formats, runs analytical SQL over local and remote data, and surfaces the right DuckDB and DuckLake documentation for functions, extensions, and performance tuning — all in-process with zero server setup.
duckdb analytics parquet sql olap
When to use
Use for ad-hoc SQL analysis over local files, converting CSV/Parquet/JSON, joining data without a warehouse, or tuning DuckDB query performance.
Examples
Query Parquet directly
Analyze files with no setup
Use DuckDB to read events.parquet and give me daily active users for the last 30 days
Convert CSV to Parquet
Reformat a dataset
Convert a directory of CSV exports to partitioned Parquet with DuckDB, compressing with zstd
Join local files
Combine CSV and JSON
Join users.csv with orders.json in DuckDB and show lifetime value per customer