PluginInstalls cleanly
Ask questions about CSV and Excel files
duckdb-skills
DuckDB's official skills let your assistant open CSV, Excel, JSON or Parquet files on your computer and answer questions about the data in plain words.
- Works with
- Claude Code
- Good for
- Daily work and research, Build an app
What it does
DuckDB is an open-source (MIT) database engine that runs on your own computer. It reads files such as CSV, Excel, JSON and Parquet directly. These are the official DuckDB skills for Claude Code, from the DuckDB Foundation. They teach your assistant to use DuckDB to answer questions about your data.
You point the assistant at a file and ask a question in normal words, for example "which five products made the most money?". The assistant writes the SQL (the database language) and runs it. You do not need to know SQL.
The repo has 9 skill folders (the README describes 6 of them):
read-fileandquery: look inside a file and ask questions about it.attach-db: open a DuckDB database file for later questions.convert-file: change a file from one format to another.s3-explore: look through files in cloud storage.spatial: work with map data.duckdb-docs: search the DuckDB documentation.read-memories: search your past Claude Code sessions for decisions and to-dos.install-duckdb: install or update DuckDB extensions (add-ons).
Commands look like /duckdb-skills:query. All skills share one settings file per project, called state.sql. You choose where it goes: .duckdb-skills/state.sql in the project, or ~/.duckdb-skills/<project>/state.sql in your home folder. It can hold secrets, so keep it out of shared folders and Git.
You need the DuckDB command-line program on your computer. The skills do not install it. If it is missing, install-duckdb stops and shows you the install command for your system.
A few things to know:
- Reading from S3, Google Cloud or Azure uses the cloud credentials already on your computer.
read-memoriessearches the session logs of all your projects unless you add--here. The skill tells the assistant not to describe this step, so you may not see it happen.duckdb-docsdownloads a copy of DuckDB's documentation index to~/.duckdb/docsand searches it on your computer. It downloads a new copy when the old one is more than 2 days old.- With
--update,install-duckdbcan upgrade DuckDB after you agree. On Linux this runs thecurl -fsSL https://install.duckdb.org | shscript. - We found no telemetry. The last code change is from April 2026.
Who it is for
People with spreadsheets, CSV exports or data files who want plain-English answers about them, such as totals, top ten lists or odd rows, without learning SQL first.
Example prompts
- "/duckdb-skills:read-file sales_2026.csv which five products made the most money?"
- "/duckdb-skills:query "how many orders came from Poland last month?""
- "/duckdb-skills:attach-db shop.duckdb"
- "Convert this CSV export into a Parquet file and tell me how much smaller it is."
- "/duckdb-skills:read-memories pricing --here"
How to install
/plugin marketplace add duckdb/duckdb-skills/plugin install duckdb-skills@duckdb-skillsHow to use it
Ask: /duckdb-skills:read-file sales.xlsx what columns does it have and how many rows? Or just ask a question about a data file in your folder.
Other assistants
The skills are built for Claude Code only. A pull request to add Codex support (#14) was closed without being merged, and there is no Gemini CLI route.
Check it works
- Run
/duckdb-skills:query SELECT 42. It should return 42. - If DuckDB is missing, install it with the command for your system, then try again:
brew install duckdb # macOS
curl -fsSL https://install.duckdb.org | sh # Linux
winget install DuckDB.cli # Windows- To update the plugin later, run
/plugin marketplace update duckdb-skillsand then/plugin update duckdb-skills@duckdb-skills.
Common problems
- The skills say DuckDB is not installed — "DuckDB is not installed. Install it first" — Install DuckDB yourself with the command above.
/duckdb-skills:install-duckdbinstalls extensions only, not DuckDB itself. - The first query on a .duckdb file fails —
Permission Error: Cannot access file ".../t.duckdb.wal" - file system operations are disabled by configuration— This is open issue #17. The reporter says the assistant usually recovers on a second try by also allowing the<file>.walpath. If it does not, ask it to do exactly that. - SQLite, Excel or map files fail in quick query mode —
Permission Error: Loading external extensions is disabled through configuration— A comment on issue #17 says it works when the extension is loaded before the safety settings. Install the extension first, for example/duckdb-skills:install-duckdb spatial, then ask again. This is a workaround from the issue, not an official fix. - The official-list install cannot find the plugin — Claude Code cannot find
duckdb-skills@claude-plugins-official— Claude Code adds Anthropic's official plugin list the first time you open an interactive session. On a new machine or in a script, runclaude plugin marketplace add anthropics/claude-plugins-officialfirst. Or use the two/plugincommands from DuckDB's own list. - Commands fail on Windows — paths or shell commands do not work — The README says Windows is not fully supported yet. Use macOS, Linux or WSL.
What to watch out for
- Needs the DuckDB command-line program; the skills do not install it, they show you how (Homebrew on macOS, a curl script on Linux, winget on Windows)
- Tested on macOS and Linux; the README says Windows is not fully supported yet
- Saves session settings, including any storage secrets you add, in a plain state.sql file; keep it out of shared folders and Git
- read-memories searches your past Claude Code session logs from all projects unless you add --here, and the skill tells the assistant not to show this step
- duckdb-docs downloads DuckDB's docs index to ~/.duckdb/docs (again when older than 2 days) and searches it on your computer
- install-duckdb --update can upgrade DuckDB after you agree; on Linux that runs curl -fsSL https://install.duckdb.org | sh
- Reading s3:// or other cloud paths uses the cloud credentials already on your computer (credential_chain)
Licence and author
- Licence
- MIT
- Author
- DuckDB Foundation
- Source code
- github.com/duckdb/duckdb-skills
How we tested it
We installed it on an empty test computer on 15 Oct 2026. Installed and started in a clean test system. Not yet used in a real AI session.
Not yet used on real work.
Technical details of the test
- Date
- 15 Oct 2026
- Method
- Intake sandbox run on 2026-10-15 in a clean container with no account: cloned the repository and checked its skill, agent and plugin files; installed duckdb-skills@duckdb-skills with the Claude Code command line.
Checked again on 16 Oct 2026
Alternatives
- MarkItDown MCP: turns documents such as PDF, Word and Excel into text for the assistant to read. It does not run database queries.
- Airtable Skills: works with data kept in Airtable online instead of files on your computer.
FAQ
Do I need to know SQL?
No. The query skill accepts plain questions as well as SQL.
Does my data leave my computer? DuckDB reads local files on your computer. What the assistant reads goes to your AI model, as with any file in a session. Cloud files come from your cloud storage.
Is it official?
Yes. The DuckDB Foundation publishes it. It is also in Anthropic's official plugin list as duckdb-skills@claude-plugins-official.
Sources
- github.com/duckdb/duckdb-skills
- raw.githubusercontent.com/duckdb/duckdb-skills/main/README.md
- raw.githubusercontent.com/duckdb/duckdb-skills/main/skills/install-duckdb/SKILL.md
- raw.githubusercontent.com/duckdb/duckdb-skills/main/skills/duckdb-docs/SKILL.md
- raw.githubusercontent.com/duckdb/duckdb-skills/main/skills/read-memories/SKILL.md
- github.com/duckdb/duckdb-skills/issues/17
- github.com/duckdb/duckdb-skills/pull/14
- raw.githubusercontent.com/anthropics/claude-plugins-official/main/.claude-plugin/marketplace.json