DuckDB SQL

About

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

• Operates in a 'display-only' mode, showing queries for review before execution
• 0 GitHub stars
• Follows best practices for DuckDB, including ATTACH statements and relative pathing
• Analyzes data to automatically detect and document potential enum columns
• Creates a local asset cache with schemas and a data dictionary for fast query generation
• Generates DuckDB-compliant SQL for .ddb, .csv, and .parquet files

Use Cases

• Quickly generating SQL to explore and analyze local data files without remembering exact schemas.
• Creating a persistent, documented data dictionary for a project's local data sources.
• Refactoring, improving, or debugging existing DuckDB SQL queries for better performance.