DuckDB Local Analytics And Dev

Overview

Use this skill when DuckDB is the fastest path to local analytical iteration. It helps agents build reproducible local workflows that accelerate development without confusing prototype convenience for production architecture.

When to Use

• prototyping data models and transformations locally before deploying to a warehouse
• reproducing production data issues with sample datasets
• running analytical queries during development without remote infrastructure
• building lightweight CLI tools, validators, or test harnesses
• validating dbt models locally with dbt-duckdb adapter
• creating proof-of-concept demonstrations with embedded analytics

Do not use this when the workload requires production durability, concurrent access, or distributed processing. DuckDB is a development and prototyping accelerator, not a production warehouse replacement.

Workflow