# ローカルデータ分析のための DuckDB CLI
ターミナルから CSV、Parquet、JSON、ローカルデータセットを SQL で扱えます。
Agent Readiness Score: 87/100
Strong for local analytical tasks when agents are constrained to read-only queries.
## Install

- Homebrew: `brew install duckdb`
- pip: `pip install duckdb`

## Structured output

Supported output formats: json, csv, parquet, markdown.
Prefer structured output flags such as `--json`, `--format json`, or equivalent when available.

## Safe commands

- 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.

## Commands requiring approval

- Delete rows: `duckdb data.db -c "DELETE FROM events WHERE ..."` — destructive; require explicit user approval.

## Agent instructions

- 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.

## Metadata

Official URL: https://duckdb.org/docs/stable/clients/cli/overview.html
GitHub: https://github.com/duckdb/duckdb
Docs: https://duckdb.org/docs/