87 /100
Strong for local analytical tasks when agents are constrained to read-only queries.
Structured output 92/100
Whether the CLI can return JSON, YAML, or stable machine-readable output.
Non-interactive use 88/100
Whether common workflows can run predictably without an interactive prompt.
Safety boundaries 68/100
Whether read-only, dry-run, scoped auth, and destructive command boundaries are clear.
インストール方法
Homebrew
$ brew install duckdb pip
$ pip install duckdb よく使うコマンド
Query CSV · 安全
$ duckdb -c "SELECT * FROM 'data.csv' LIMIT 5" Reads local tabular data quickly.
Export JSON · 安全
$ duckdb -json -c "SELECT count(*) AS rows FROM 'data.csv'" Returns parseable JSON output.
Delete rows · 破壊的
$ duckdb data.db -c "DELETE FROM events WHERE ..." Mutates data and requires approval.
Agent 使用例
Gemini CLI
Use DuckDB for read-only analysis of CSV, Parquet, and local databases. Prefer SELECT queries and JSON output. 安全メモ
- Local analytical reads are generally safe.
- COPY, INSERT, UPDATE, DELETE, and external database access should be reviewed.
- Agents should run SELECT-only queries by default when exploring data.
Agent が使えること
DuckDB CLI は Agent が SQL でローカルデータファイルを調べ、構造化された要約を作る用途に使えます。
向いている用途
CSV 分析、Parquet 確認、ローカル分析、再現可能なデータチェックに適しています。