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.
Install options
Homebrew
$ brew install duckdb pip
$ pip install duckdb Common commands
Query CSV · safe
$ duckdb -c "SELECT * FROM 'data.csv' LIMIT 5" Reads local tabular data quickly.
Export JSON · safe
$ duckdb -json -c "SELECT count(*) AS rows FROM 'data.csv'" Returns parseable JSON output.
Delete rows · destructive
$ duckdb data.db -c "DELETE FROM events WHERE ..." Mutates data and requires approval.
Agent usage examples
Gemini CLI
Use DuckDB for read-only analysis of CSV, Parquet, and local databases. Prefer SELECT queries and JSON output. Safety notes
- 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.
What agents can use it for
DuckDB CLI lets agents inspect local data files with SQL and produce structured output for summaries.
Best fit
Use it for CSV analysis, Parquet inspection, local analytics, and repeatable data checks.