DuckDB Skills

duckdb-skills

A Claude Code plugin that adds DuckDB-powered skills for data exploration and session memory.

Installation

From the Discover tab (coming soon)

We are working on submitting this plugin to the official Anthropic marketplace. Once listed, it will appear in the Discover tab when you run /plugin inside Claude Code.

From GitHub (available now)

Add the repository as a plugin source and install:

/plugin marketplace add duckdb/duckdb-skills

/plugin install duckdb-skills@duckdb-skills

This registers the GitHub repo as a marketplace and installs the plugin. Skills will be available as /duckdb-skills:<skill-name> in all future sessions.

Updating

To pull the latest version, update the marketplace first and then the plugin:

/plugin marketplace update duckdb-skills
/plugin update duckdb-skills@duckdb-skills

Skills

attach-db

Attach a DuckDB database file for interactive querying. Explores the schema (tables, columns, row counts) and writes a SQL state file so all other skills can restore the session automatically. You can choose to store state in the project directory (.duckdb-skills/state.sql) or in your home directory (~/.duckdb-skills/<project>/state.sql).

/duckdb-skills:attach-db my_analytics.duckdb

Supports multiple databases — running attach-db again can append to the existing state file.

query

Run SQL queries against attached databases or ad-hoc against files. Accepts raw SQL or natural language questions. Uses DuckDB's Friendly SQL dialect. Automatically picks up session state from attach-db.

/duckdb-skills:query FROM sales LIMIT 10
/duckdb-skills:query "what are the top 5 customers by revenue?"
/duckdb-skills:query FROM 'exports.csv' WHERE amount > 100

read-file

Read and explore any data file — CSV, JSON, Parquet, Avro, Excel, spatial, SQLite, Jupyter notebooks, and more — locally or from remote storage (S3, GCS, Azure, HTTPS). Auto-detects the format by file extension using a built-in read_any table macro. Suggests query for further exploration.

/duckdb-skills:read-file variants.parquet what columns does it have?
/duckdb-skills:read-file s3://my-bucket/data.parquet describe the schema
/duckdb-skills:read-file https://example.com/data.csv how many rows?