# Key Features of DuckDB v2.0 Revolutionary innovations are coming to the database world. - **Source:** [Hacker News](https://news.ycombinator.com) - **Published:** 2026-08-17 - **Topic:** [Data & AI](https://brifing.si/c/data-ai) - **Original article:** - **On Brifing:** https://brifing.si/s/26583f30-4b70-435e-8f9d-578768eef21a ## Core Features of DuckDB v2.0 DuckDB v2.0, codenamed 'Cyanoptera', is set to launch this fall. This release brings significant innovations to the database world. It includes fundamental changes like a new SQL parser, default storage format, and revised C API. Prepared with over 10,000 commits, this version enables DuckDB to function as a server. Many features previewed at DuckCon #7 will be included in this release. ## Client/Server Mode DuckDB now supports client/server mode. The Quack extension provides a native protocol for communication between DuckDB instances. Previewed before DuckCon #7, this feature becomes stable in v2.0. The new CONNECT statement allows any DuckDB process to serve databases over the network, while other DuckDB instances can attach and route queries. This is particularly useful in multi-user scenarios. ## PostgreSQL and MySQL Integration The new remote pushdown optimizer (#22914) can send SQL queries directly to PostgreSQL and MySQL servers. Instead of pulling data, queries can be executed on remote servers. For example, using 'CONNECT postgres://localhost/mydb' you can connect to a PostgreSQL database and run queries there. This feature offers great flexibility in heterogeneous database environments. ## Transaction and MVCC Support DuckDB was designed from the beginning as a transactional database. It provides full MVCC and transaction isolation support. In multi-user scenarios, it can compete with general-purpose databases like PostgreSQL in terms of performance. The client/server mode makes these capabilities available in long-term, multi-tenant deployments. ## Observability and Metrics v2.0 introduces better metrics, logs, and observability features. The metrics layer was redesigned with commit #22799. This allows detailed monitoring of what a DuckDB instance is actually doing. Users started developing their own clients for the Quack protocol within weeks of its preview release, demonstrating strong community interest in DuckDB. ## VARIANT Data Type Introduced in DuckDB v1.5, the VARIANT type can be thought of as JSON on steroids. Capable of storing differently-shaped data in each row, it's not a text format and therefore executes fast. DuckDB automatically detects common structure in semi-structured data and 'shreds' it, enabling good compression and fast queries without schema declarations. Ideal for real-time log ingestion. ## Advanced VARIANT Features v2.0 provides an end-to-end pipeline for VARIANT type. Features include shredded execution straight from storage (#20912), extraction pushdown into scans (#22478), shredded VARIANT reading/writing for Parquet, and a family of variant_* functions. Long-term plans include backing the regular JSON type with VARIANT, allowing existing JSON workloads to benefit without query changes. ## Trigger Support DuckDB v2.0 delivers the long-awaited trigger support. It includes BEFORE and AFTER triggers, FOR EACH ROW and FOR EACH STATEMENT options, transition tables via REFERENCING OLD/NEW TABLE, multiple triggers per event, and DROP TRIGGER command. The classic use case is audit tables, where triggers record what changed in the system. This feature naturally complements long-running DuckDB services. ## Asynchronous I/O v2.0 introduces asynchronous I/O support. This feature improves performance particularly on high-latency storage systems. By executing I/O operations in the background, DuckDB prevents the main thread from blocking. This provides significant advantages especially in cloud-based deployments and when working with large datasets. ## New SQL Parser DuckDB v2.0 comes with a completely new SQL parser. This parser enables faster and more flexible query processing. It also provides better compliance with SQL standards and supports more complex queries. The new parser offers performance advantages particularly when working with large and complex datasets. ## New Storage Format v2.0 introduces a new default storage format. This format improves data compression ratios while also enhancing read/write performance. Optimized especially for large datasets, the new format increases DuckDB's scalability. Tools are provided to convert existing databases to the new format. ## The Future of DuckDB DuckDB v2.0 represents a significant step in database technology. With client/server mode, advanced transaction support, and new data types, DuckDB is moving beyond being just an embedded database. Its popularity is expected to grow particularly in data analytics and real-time data processing. Community-developed clients demonstrate the ecosystem's growth. ## Sources covering this story - https://duckdb.org/2026/08/17/duckdb-20-highlights — --- _Summary written by Brifing from the original reporting. Copyright in the original article belongs to its publisher; read the full piece at the link above._