菜单
Install or update DuckDB extensions. Use when DuckDB reports a missing extension, when the user asks to install/update extensions, or when other skills delegate here. Each argument is a plain extension name or name@repo. Pass --update to update.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Build data processing pipelines using DuckDB, GDAL, and gpio as pixi tasks. Use when creating ETL workflows, multi-step data transformations, format conversions, or batch processing — even if the user just says "process this data" or "build a pipeline".
Attach a DuckDB database for persistent querying. Use when the user has a .duckdb file they want to explore, or when they want to persist query results across sessions. Explores schema and wires up state.sql so all DuckDB skills can access it.
Search DuckDB and DuckLake documentation via full-text search. Use when encountering DuckDB errors, looking up function syntax, or when other skills hit unknown DuckDB behavior. Also use proactively when unsure about DuckDB features.
Run SQL queries against DuckDB databases or ad-hoc files. Accepts raw SQL or natural language. Use whenever the user wants to query data, explore tables, run analytics, or ask questions about datasets — even if they don't say "DuckDB" explicitly.
Read and explore any data file (CSV, JSON, Parquet, Avro, Excel, spatial, remote) using DuckDB. Use proactively when the user mentions a data file, asks "what's in this file", or wants to explore/preview/describe any dataset — even without saying DuckDB.
Search past Claude Code session logs to recover context. Use proactively when recalling past decisions, patterns, or unresolved work from previous sessions.
| name | install-duckdb |
| description | Install or update DuckDB extensions. Use when DuckDB reports a missing extension, when the user asks to install/update extensions, or when other skills delegate here. Each argument is a plain extension name or name@repo. Pass --update to update. |
| argument-hint | [--update] [ext1 ext2@repo ...] |
| allowed-tools | Bash |
Arguments: $@
Parse each extension as name → INSTALL name; or name@repo → INSTALL name FROM repo;.
pixi run duckdb --version
If pixi fails, fall back to system duckdb --version. If neither works, tell the user to install via pixi add duckdb or see https://duckdb.org/docs/installation.
Install mode (no --update flag):
pixi run duckdb :memory: -c "INSTALL ext1; INSTALL ext2 FROM repo2; ..."
Update mode (--update in $@):
# Check CLI version
pixi run duckdb --version
# Update extensions
pixi run duckdb :memory: -c "UPDATE EXTENSIONS;"
# Or specific: UPDATE EXTENSIONS (ext1, ext2);
Report success or failure. Common extensions for this project: spatial, httpfs, fts, parquet.