Generate DuckDB SQL queries from plain English questions using asset schemas.
npx skills add https://github.com/robdmc/claude_skills --skill duckdb-sql
Please help me install this Agent Skill. Skill: duckdb-sql Source: https://github.com/robdmc/claude_skills/tree/main/duckdb_sql/code/duckdb-sql Command: npx skills add https://github.com/robdmc/claude_skills --skill duckdb-sql
This DuckDB Code skill helps you generate DuckDB SQL queries from natural language, understand data structures, and iteratively refine queries.
Start by asking for a DuckDB data task or attach assets. The skill will first present a query plan based on existing assets (without executing any queries) and wait for your approval before generating SQL.
High-intent search queries and answers about installing and using this skill.
DuckDB SQL generation converts plain English questions into executable DuckDB queries. This skill reads your data assets (tables_inventory.json, schema files, data dictionary) to build syntactically correct queries without executing them, letting you approve a query plan before SQL generation.
Yes. DuckDB queries work across databases, CSV files, and Parquet files. This skill generates SQL that accesses all three formats by discovering their structures from your asset documentation, enabling unified queries across mixed data sources.
You need a duckdb_sql_assets/ folder containing tables_inventory.json (table metadata), schema_*.sql files (column definitions), and data_dictionary.md (field documentation). These assets guide query generation without requiring live file access or query execution.
The skill supports iterative refinement through a two-way workflow: propose a query plan based on your question, wait for your approval, generate the SQL, then modify it based on your feedback—enabling collaborative query building without trial-and-error execution.
No. You describe your data task in English, and the skill generates syntactically correct DuckDB SQL. Knowledge of DuckDB syntax helps refine queries, but natural language input means you can start without prior SQL or DuckDB experience.
The skill relies on assets to produce syntactically correct queries. Missing or incomplete tables_inventory.json, schema files, or data dictionary may result in incomplete or inaccurate query generation, so ensure all documentation is current before requesting query plans.
D26FORWARDList database tables, inspect schemas, and map foreign key join paths.
darknetopencv-altAnalyze Excel and CSV files with DuckDB SQL queries and statistical summaries.
PovertyActionRun SQL queries and transform CSV, Parquet, JSON, and Excel files via the DuckDB CLI.
docaohieu2808Design schemas, write queries, and optimize MongoDB and PostgreSQL databases.
