duckdb-sql

What problem does it solve?

This DuckDB Code skill helps you generate DuckDB SQL queries from natural language, understand data structures, and iteratively refine queries.

Core Features & Use Cases

• Discovery-first SQL generation: Build queries from English questions using documented asset schemas.
• Asset-driven context: Reads duckdb_sql_assets/* assets (tables_inventory.json, schema_*.sql, data_dictionary.md) to guide query construction without touching live files.
• Two-way workflow: Propose query plans, then generate and refine SQL with user approval.
• Use Case: You want to answer “show me orders by month” by generating a DuckDB SQL plan and a ready-to-run query.

Quick Start

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.