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.

Resources