DuckDB 2.0.0 LTS "Cinnamon Teal"

Your SQL queries on remote object storage like S3 can now run much faster due to asynchronous I/O improvements.

DuckDB has released version 2.0.0 LTS, codenamed "Cinnamon Teal." This significant feature release, built on nearly 20,000 commits, introduces a polished Quack protocol for client-server operation, asynchronous I/O for faster data reads from object storage, and a first-class VARIANT data type for semi-structured data. It also includes an agent mode for the CLI to improve interaction with coding agents, an extensible SQL parser based on PEG, and a revamped C API v2 for extensions. DuckDB 2.0.0 LTS will be supported until at least October 2027, while the previous LTS release, 1.4, remains supported until late November 2026. Additionally, version 1.5 has an extended support period until March 2027.

The introduction of the Quack protocol and the new CONNECT statement signal a strategic move towards making DuckDB a more versatile data management tool, capable of operating both in-process and as a client-server database. This evolution broadens its applicability beyond embedded analytics to scenarios requiring shared data access or integration with other database systems like PostgreSQL and MySQL, aided by the new remote pushdown optimizer.

The first-class VARIANT type and the extensible SQL parser are key developments that position DuckDB for more complex data workloads, particularly those involving semi-structured data and custom SQL syntax. The agent mode in the CLI also reflects a growing trend in how developers interact with data tools, prioritizing efficiency and integration with AI coding assistants, which could fundamentally change how development and analysis workflows are structured.