DuckDB CLI Analytics

Fast analytical SQL engine for querying, analyzing, and converting local data files (JSON, JSONL, CSV, TSV, Parquet, SQLite) directly from the shell without database servers or external imports.

Quick Start & Execution Setup

DuckDB runs as a standalone CLI binary. Always invoke duckdb with -batch -dark-mode.

Installation & Subshell PATH Setup (Linux & macOS)

To prevent exit code 127: duckdb: command not found in non-interactive agent subshells (where mise or asdf shims are not sourced):