Open CLI

duckdb

scriptablepopularlocal-onlydatabrew

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

$ brew install duckdb
One-liner to try
$ duckdb ':memory:' 'select 42'

Agent pack

Copy into an agent

A markdown-ready setup brief with install, verify, safe starting commands, and guardrails for AI agents.

Open .mdJSON
Readiness
Great for agents · 85/100
Verify
duckdb -c "select 1"
Agent URL
/cli/duckdb/agent.md

Quick reference

Install
brew install duckdb
Verify
duckdb -c "select 1"
First command
duckdb ':memory:' 'select 42'
Machine JSON
/cli/duckdb.json

About

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.

Example workflow

1. duckdb ':memory:' 'select 42'

Alternatives worth considering

jq

JSON processing, apis, and agent output parsing from the terminal.

http

API testing, readable http, and debugging endpoints from the terminal.

yq

YAML processing, config edits, and kubernetes files from the terminal.