Use DuckDB for in-process analytics: SQL queries on DataFrames, Parquet/CSV/JSON files, window functions, CTEs, and integration with pandas and Polars.
When to use this skill
- Querying a CSV file with SQL
- Using DuckDB with pandas
- Running analytics on Parquet files
Core concepts
This skill provides guidance on duckdb analytics best practices, patterns, and common pitfalls. It is designed to be loaded on demand when a relevant task is detected.
Installation
curl -LO https://opencode-skills.example/downloads/databases/duckdb-analytics.zip
unzip duckdb-analytics.zip -d ~/.config/opencode/skills/Restart OpenCode — the skill loads automatically.
When it triggers
- querying a CSV file with SQL
- using DuckDB with pandas
- running analytics on Parquet files