Query local CSV files with DuckDB and Claude Code
Watch Claude Code and the official DuckDB skills answer business questions in plain English from a folder of CSV files.
Who it's for: Data analysts, analytics engineers and BI folks with a CSV too big for Excel and no wish to stand up a warehouse.
The problem: Hundreds of thousands of rows can make Excel barely workable. A cloud data warehouse takes permissions and a manual upload, even for one question.
DuckDB is an in-process analytics database with no server and no import step, because the file is the table. With the duckdb-skills plugin, Claude Code turns a plain English question into SQL that DuckDB runs on your laptop.
Takeaways:
- Install the duckdb-skills plugin, which also sets up the DuckDB CLI.
- Use a glob to query a whole folder of files as one table.
- Read the generated SQL to quality check the answer and learn DuckDB syntax.