duckdb

Agent-readyData & DBData

Local analytics, sql, and csv/parquet queries from the terminal.

Local analytics, sql, and csv/parquet queries from the terminal. Built by DuckDB. Supports structured output — good for scripts and agents. Runs entirely on your machine.

Task fit

local analytics, sql, and csv/parquet queries from the terminal.

Lane

Inspect schemas, run safe queries, and understand your data fast.

Operator brief

Use duckdb for local analytics, sql, and csv/parquet queries from the terminal.

Run `duckdb ':memory:' 'select 42'` and see what comes back.

Repository family

DuckDB

First trust check

duckdb responds locally and is ready for the first real command.

Safe first loop

Install, verify, then run one real command.

Safe database loop

Install command

$ brew install duckdb

Operator pack

Copy or export the working notes for this CLI before handing it to an agent.

Verify

$ duckdb --version

duckdb responds locally and is ready for the first real command.

First real command

$ duckdb ':memory:' 'select 42'

First steps

01Install duckdb.
02Run `duckdb --version` first.
03Start with `duckdb ':memory:' 'select 42'`.
04Install a CLI that matches your database engine.

When to use / hold off when

Best for

local analytics, sql, and csv/parquet queries from the terminal.

Use this when

You want data processing that runs entirely on your machine.

Hold off when

You don't work with data processing.

Trust and constraints

automation-ready100/100

Install readyAutomation-ready

JSON outputYes

Non-interactiveYes

CI-friendlyYes

Why operators pick it

duckdb fits data & db well, especially for local analytics, sql, and csv/parquet queries from the terminal.
5,907 homebrew installs (30d).
Good for scripts and agents.

Constraints