TL;DR

DuckDB is an open-source analytical database that runs inside one process, and version 2.0.0 LTS, codenamed Cinnamon Teal, was released on 21 October 2026 with the Quack protocol, asynchronous I/O, a first-class VARIANT type, agent mode, triggers and an extensible SQL parser.

The release is built from close to 20,000 commits since DuckDB 1.5, and the project calls it the biggest feature release so far, in contrast with the 1.0 line that concentrated on stability.

The support label carries a date: 2.0 is supported until at least October 2027, with the calendar page listing an end of life of 22 October 2027.

Three version lines run in parallel until 17 November 2026, when community support for 1.4 ends, and two lines remain until March 2027, when the extended support for 1.5 ends.

The storage format moves in one direction now, since releases before 2.0 cannot open files written by 2.0 while existing files that 2.0 reads and writes stay readable by older releases.

A migration plan for a small data…