Setup & Installation
npx skills add https://github.com/duckdb/duckdb-skills --skill query
https://github.com/duckdb/duckdb-skills/tree/main/skills/query
View on GitHubWhat This Skill Does
Runs SQL queries against DuckDB databases or files like CSV and Parquet. Accepts raw SQL or natural language questions and translates them to DuckDB Friendly SQL. Handles schema inspection, result size estimation, and error recovery automatically.
DuckDB's Friendly SQL idioms like FROM-first queries, GROUP BY ALL, and direct file access reduce the boilerplate needed compared to writing standard SQL against a traditional database setup.
When to use it
- Querying a CSV file with natural language like 'show me top 10 sales by region'
- Running aggregations across multiple Parquet files using glob patterns
- Profiling an unknown dataset with SUMMARIZE before writing analysis queries
- Pivoting time-series data from long to wide format for reporting
- Checking row counts and schema before joining two large tables