duckdb/duckdb-skills
9 skills5k installs4.7k starsGitHub
Install
npx skills add https://github.com/duckdb/duckdb-skillsSkills in this repo
1Queryquery is a duckdb-skills module that resolves .duckdb-skills/state.sql session state or falls back to sandboxed ad-hoc mode against :memory: with allowed_paths locked to referenced files. It accepts raw SQL or natural language, generates Friendly SQL using idioms like FROM-first selects, GROUP BY ALL, SELECT * EXCLUDE, PIVOT, ASOF joins, and direct reads from CSV or Parquet globs. Before execution it estimates row counts, warns above 1M rows without LIMIT, and flags tables over 10 GB. A seven-step workflow installs DuckDB if missing, describes schemas with duckdb_tables(), runs duckdb -csv output, handles syntax and extension errors, and suggests LIMIT when results exceed 100 rows. Developers reach for query when probing attached analytics databases or local data files from Claude Code.809installs2Duckdb Docsduckdb-docs searches DuckDB and DuckLake documentation and blog posts using a locally cached full-text index, returning the most relevant doc chunks for a question or keyword. A solo builder reaches for it while writing DuckDB SQL to quickly find the right syntax or feature without leaving the terminal.765installs3Read Fileread-file uses DuckDB to read and profile any data file - CSV, JSON, Parquet, Avro, Excel, spatial, SQLite - or a remote S3/HTTPS URL, previewing contents and answering questions about the dataset. A solo builder reaches for it whenever they need to peek inside a data file or understand its schema without writing boilerplate loading code.743installs4Attach Dbattach-db attaches a DuckDB database file, explores its schema - tables, columns and row counts - and writes a SQL state file so subsequent queries can restore the session automatically. A solo builder reaches for it to quickly wire up a local DuckDB database and understand its structure before running analytical queries.617installs5Install Duckdbinstall-duckdb installs or updates DuckDB extensions - each argument being a core extension name or a name@repo like magic@community - with a --update flag to update rather than install. A solo builder reaches for it to add the DuckDB capabilities they need, such as spatial, httpfs or community extensions, before querying.540installs6Read Memoriesread-memories searches past Claude Code session logs to recall prior decisions, patterns and unresolved work, silently absorbing that context to continue with enriched understanding. A solo builder reaches for it when they say 'do you remember' or need to pick up where a previous session left off without re-explaining everything.456installs7Convert Fileconvert-file uses DuckDB to convert data files between formats - CSV, Parquet, JSON, Excel, GeoJSON and more - including binary formats Claude cannot produce natively. A solo builder reaches for it whenever they need to turn a dataset into another format, like exporting a CSV to Parquet or saving results as Excel.398installs8SpatialA DuckDB skill for answering spatial and geographic questions - it runs spatial joins, distance calculations, containment checks and density analysis, and converts between formats like GeoJSON, Shapefile, GeoPackage and GeoParquet. It taps Overture Maps' free global data on S3 with zero API keys. Reach for it when a solo builder needs to work with coordinates, addresses, maps or 'near/within/closest' queries without standing up a full GIS stack.368installs9S3 Explores3-explore uses DuckDB to explore and query data on S3, Cloudflare R2, GCS, MinIO or any S3-compatible storage - listing files and previewing remote Parquet, CSV or JSON, and reporting size, schema and row counts without downloading. A solo builder reaches for it to poke around a cloud bucket and query remote datasets directly from the terminal.350installs