DuckDB v2.0 CLI agent mode cuts agent-read tokens by 59% on TPC-H benchmarks
josh_wills · x · 2026-10-10
DuckDB v2.0 CLI ships an agent mode that optimizes terminal output for AI coding agents: compact Markdown tables, explicit truncation notices, early aborts of runaway queries, JSON error reporting, and upfront cost announcements for long queries. Claude Code answered all 22 TPC-H questions correctly across 132 runs, with tokens read dropping from 123.6k to 50.8k (-59%). Net cost savings were only 0.5% since each turn re-reads a large system prompt, and runs took slightly more turns (237 vs 224).
More from coding & agent
- FreeToken-Bots: an open-source skill that auto-scans OpenRouter free models for your agent — sven_ai · 2026-10-10
- Codex's mass emailing hits Gmail's hidden 24-hour, 500-email sending limit — CtrlAltDwayne · 2026-10-10
- Devin now works with personal ChatGPT plans, drawing GPT usage from your quota — BLUECOW009 · 2026-10-10
- LangChain's Model Router Cut Median Coding-Task Cost 64% With No Quality Loss — hwchase17 · 2026-10-10
- Keenan Crane shows AI-generated shader with coarse-to-fine decomposition diagram — keenanisalive · 2026-10-10
- One-line agent skill taps Gaia DR3 to build 3D star maps from real astronomy data — TinfoilTricorn · 2026-10-10