Generates and refines DuckDB SQL queries for data analysis using local database, CSV, and Parquet files.
Acts as a specialized assistant for writing, reviewing, and understanding DuckDB SQL queries. It creates a local asset cache containing schemas and a data dictionary from your `.ddb`, `.csv`, or `.parquet` files, allowing for rapid query generation without direct database access. By default, it displays queries for user review and execution, ensuring you have full control. It's ideal for exploring local data, translating natural language questions into efficient SQL, and improving existing queries.
Key Features
01Operates in a 'display-only' mode, showing queries for review before execution
020 GitHub stars
03Follows best practices for DuckDB, including ATTACH statements and relative pathing
04Analyzes data to automatically detect and document potential enum columns
05Creates a local asset cache with schemas and a data dictionary for fast query generation
06Generates DuckDB-compliant SQL for .ddb, .csv, and .parquet files
Use Cases
01Quickly generating SQL to explore and analyze local data files without remembering exact schemas.
02Creating a persistent, documented data dictionary for a project's local data sources.
03Refactoring, improving, or debugging existing DuckDB SQL queries for better performance.
