kyle-chalmers

Claude Code Duckdb — Development skill for Claude Code

Development community

Query a folder of CSVs in plain English with DuckDB + Claude Code.

How to install Claude Code Duckdb

This entry records only its repository, not the path inside it, so there is no exact command to give. Open kyle-chalmers/claude-code-duckdb and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

What Claude Code Duckdb does

Query a folder of CSVs in plain English with DuckDB + Claude Code. No warehouse to set up.

Alternatives in Development

Agent.Extras.Workdir Structure — File structure of working directory {{folder}} 19k ★
Agentic Stack — One brain, many harnesses 2.2k ★
Update Scaffold — Check for and apply myPKA scaffold framework updates safely 296 ★

README

Claude Code + DuckDB: Analyze Any CSV on Your Laptop

Query a folder of CSV files in plain English, with no warehouse to set up and no database to connect to. You ask the question, an AI agent writes the DuckDB SQL, and you read every line so you actually trust the answer.

This repo is the companion to the video on the [Kyle Chalmers Data Plus AI](https://www.youtube.com/@kylechalmersdataai) channel. It ships a realistic e-commerce dataset (900,000 orders split across six monthly files, plus customers and products) so you can follow along on your own machine.

![How it works: your laptop holds the data files, Claude Code writes the SQL, DuckDB runs it locally, and only the model call goes to the cloud](./images/diagram.png)

Why this exists

You have a pile of CSV files. A few hundred thousand rows each, the kind of size that turns Excel sluggish and makes pandas feel slow, and you just want to ask a question. The usual reflex is to stand up a cloud warehouse, which means an account, a login, and a bill you did not want.

DuckDB removes that step. It is an in-process analytical database (think SQLite, but built for analytics) that queries CSV, Parquet, and JSON files directly on your machine. There is no server to run and nothing to connect to. The file is the table.

Pair it with Claude Code and you describe what you want in plain English. The agent writes the SQL, runs it, and shows you both the query and the result. You stay in control by reading the SQL, not by memorizing DuckDB's dialect first.

Prerequisites

Tool	Version	Purpose
Claude Code	current	Writes and runs the SQL from plain-English prompts
`duckdb-skills` plugin	current	Official Claude Code plugin for DuckDB. The recommended way in, and it can install the DuckDB CLI for you
DuckDB CLI	1.5.x	Runs the SQL locally against the CSV files. The plugin instal