duckdblisted
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