Run TPCH benchmarks and analyze DuckDB query execution plans.
npx skills add https://github.com/ztdevelops/claude-code-skills --skill duckdb-expert
Please help me install this Agent Skill. Skill: duckdb-expert Source: https://github.com/ztdevelops/claude-code-skills/tree/main/private/personal/duckdb-expert Command: npx skills add https://github.com/ztdevelops/claude-code-skills --skill duckdb-expert
This Skill provides an expert-level, modular assistant for running rigorous DuckDB performance work: it orchestrates TPCH benchmarking, interprets execution plans for query optimization, and explains DuckDB internals so engineers can diagnose and fix performance issues quickly and reproducibly.
Run a TPCH benchmark for query 5 on tpch.duckdb with 5 warm runs and save the results to DUCKDB_STATS.md and DUCKDB_ANALYSIS.md.
High-intent search queries and answers about installing and using this skill.
Run a strict TPCH benchmark on DuckDB using the included helper script, which enforces 1 cold run plus N warm runs with threads=1 and memory_limit='1GB', then generates DUCKDB_STATS.md and DUCKDB_ANALYSIS.md.
Optimize slow DuckDB queries by running EXPLAIN ANALYZE to interpret execution plans, identify bottlenecks, and apply targeted query rewrites or configuration changes for better performance.
DuckDB vectorized execution and columnar storage process data in batches to reduce overhead and improve cache efficiency, which is crucial for diagnosing performance limits during query optimization.
Control DuckDB memory limits and threading by setting configuration parameters like memory_limit='1GB' and threads=1 to ensure strict, reproducible benchmarking and performance tuning.
Inconsistent DuckDB TPCH benchmark timing often results from not isolating cold runs from warm runs or failing to enforce strict memory and thread limits, which the helper script prevents.
You need to install DuckDB and bc dependencies to execute the benchmarking scripts and collect timing statistics for strict TPCH methodology analysis.
nq-rdlInstall or update DuckDB extensions and the CLI in automation pipelines.
AstrumonDiagnose slow SQL queries and optimize PostgreSQL and SQLite configurations.
hung-phanExplain OLAP warehouse design principles for large-scale analytical queries.
cyperx84Analyze EXPLAIN plans and recommend indexing strategies for SQL queries.
