DuckDB 2.0 agent mode cuts output 56%, but -json turns it off
DuckDB 2.0.0 "Cinnamon Teal" is out as a long-term support release supported until at least October 2027. Its new CLI agent mode prints compact Markdown tables, JSON errors and a footer with a result hash, cutting output by 56%, but passing -json disables the mode and restores full output.
- DuckDB 2.0.0 "Cinnamon Teal" is an LTS release supported until at least October 2027
- Agent mode activates when AI_AGENT is set and stdout is not a terminal, cutting output 56%
- The footer reports omitted rows and a hash of the full result for comparing edits
- json disables agent mode: a 5,000-row query grew from 1,385 to 246,729 bytes
Read next
Software