Agent skill · data analytics · aaaaqwq
duckdb-en
DuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".
Why this skill is useful
Provides specific SQL commands and data conversion patterns for DuckDB that the AI wouldn't reliably generate on its own.
What it needs
Requires duckdb installed locally. About 4k tokens when loaded. Last updated 2026-08-06. 83 stars on the source repository.
What this skill does
DuckDB CLI Specialist Helps with data analysis, SQL queries and file conversion via DuckDB CLI. Quick Start Read data files directly with SQL Open persistent databases Command Line Arguments Output formats (as flags) Flag Format ------ -------- -csv Comma-separated -json JSON array -table ASCII table -markdown Markdown table -html HTML table -line One value per line Execution arguments Argument Description ---------- ------------- -c COMMAND Run SQL and exit -f FILENAME Run script from file -init FILE Use alternative to ~/.duckdbrc -readonly Open in read-only mode -echo Show commands before execution -bail Stop on first error -header / -noheader Show/hide column headers -nullvalue TEXT Text for NULL values -separator SEP Column separator Data Conversion CSV to Parquet Parquet to CSV JSON to Parquet Convert with filtering Dot Commands Schema inspection Command Description --------- ------------- .tables [pattern] Show tables (with LIKE pattern) .schema [table] Show CREATE statements .databases Show attached databases Output control Command Description --------- ------------- .mode FORMAT Change output format .output file Send output to file .once file Next output to file .headers on/off Show/hide column headers .separator COL ROW Set separators Queries Command Description --------- ------------- .timer on/off Show execution time .echo on/off Show commands before execution .bail on/off Stop on error .read file.sql Run SQL from file Editing Command Description --------- ------------- .edit or \e Open query in external editor .help [pattern] Show help Output Formats (18 available) Data export csv - Comma-separated for spreadsheets tabs - Tab-separated json - JSON array jsonlines - Newline-delimited JSON (streaming) Readable formats duckbox (default) - Pretty ASCII with unicode box-drawing table - Simple ASCII table markdown - For documentation html - HTML table latex - For academic papers Specialized insert TABLE - SQL INSERT statements column - Columns with adjustable …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aaaaqwq/duckdb-cli-ai-skills