← ClaudeAtlas

duckdblisted

Gate the DuckDB 2.0 CLI binary, select agent output modes, evaluate result trust, and route to specialized skills. Use when the user mentions DuckDB, a .duckdb file, or the duckdb CLI.
srimon12/duckdb-2-skills · ★ 1 · Data & Documents · score 65
Install: claude install-skill srimon12/duckdb-2-skills
# DuckDB 2.0 Target DuckDB 2.0.0 LTS and newer 2.0 patch releases. ## Gate the binary Before running DuckDB commands, verify the binary version: ```bash duckdb -no-agent --version ``` If stdout does not contain `v2.0`, stop. DuckDB 1.x is unsupported. When piping version output, pass `-no-agent` because stderr banner pollution invalidates `2>&1 | head -1`. If DuckDB 2.0 is missing or outdated, install it: ```bash curl -fsSL https://install.duckdb.org | sh ``` The installer places the binary in `~/.duckdb/cli/<version>/`, points `~/.duckdb/cli/latest` at it, and links `~/.local/bin/duckdb` when that directory exists without an existing `duckdb` binary. If using Homebrew, check the version immediately because Homebrew packages can lag releases. If a 2.0 binary resides outside `PATH`, invoke it by its absolute path. ## Choose the output mode | Consumer | Command | Output characteristics | | --- | --- | --- | | Model reads table | `duckdb -agent -c "..."` | Compact Markdown, JSON errors on stderr, row/byte/cell caps, result hash | | Script parses rows | `duckdb -json -c "..."` | One JSON array on stdout, text errors on stderr | | Human reads terminal | `duckdb -box -c "..."` | Unicode box table | | Human explores visually | `duckdb -ui` | Browser UI served at `localhost:4213` | When passing any output flag (`-json`, `-csv`, `-box`), DuckDB disables automatic agent mode. To preserve agent framing (stderr JSON errors and banner) with another renderer, pass `-agent` expli