# DuckDB

DuckDB is an in-process SQL database management system focused on analytical query processing. It is designed to be easy to install and easy to use. DuckDB has no external dependencies. DuckDB has bindings for C/C++, Python, R, Java, Node.js, Go and other languages.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## DuckDB Skills for Claude Code

DevFeed: [DuckDB Skills for Claude Code](<https://devfeed.tech/articles/duckdb-skills-for-claude-code-31480.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/09/16/duckdb-skills.html>)

Author: The DuckDB team

Published: 2026-09-16T00:00:00Z

Content type: tutorial

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [Claude Code](<https://devfeed.tech/topics/claude-code.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [data](<https://devfeed.tech/topics/data.md>), [CSV](<https://devfeed.tech/topics/csv.md>), [parquet](<https://devfeed.tech/topics/parquet.md>)

Tags: [claude-code](<https://devfeed.tech/tags/claude-code.md>), [cli](<https://devfeed.tech/tags/cli.md>), [csv](<https://devfeed.tech/tags/csv.md>), [data](<https://devfeed.tech/tags/data.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [parquet](<https://devfeed.tech/tags/parquet.md>), [using-duckdb](<https://devfeed.tech/tags/using-duckdb.md>)

### AI overview

This post introduces the duckdb-skills plugin for Claude Code. The plugin uses the DuckDB CLI to inspect data files, run SQL queries, convert formats, explore object storage and spatial data, search documentation, and recall earlier sessions. It explains installation, how the skills select appropriate commands, and how Claude uses DuckDB for exact query results.

### Source excerpt

The duckdb-skills plugin gives Claude Code a growing number of skills that use the DuckDB CLI to read data files, run queries, convert formats, explore object storage, work with spatial data, search the documentation and recall earlier sessions.

## Try DuckDB v2.0-alpha

DevFeed: [Try DuckDB v2.0-alpha](<https://devfeed.tech/articles/try-duckdb-v2-0-alpha-4814.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/09/02/try-duckdb-20-alpha.html>)

Author: The DuckDB team

Published: 2026-09-02T00:00:00Z

Content type: release

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>)

Tags: [bug](<https://devfeed.tech/tags/bug.md>), [development](<https://devfeed.tech/tags/development.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [extension](<https://devfeed.tech/tags/extension.md>), [python](<https://devfeed.tech/tags/python.md>), [release](<https://devfeed.tech/tags/release.md>), [releases](<https://devfeed.tech/tags/releases.md>), [sql](<https://devfeed.tech/tags/sql.md>), [testing](<https://devfeed.tech/tags/testing.md>)

### AI overview

DuckDB v2.0-alpha is available for testing ahead of a projected October release. The post asks users to try alpha clients and extensions, test existing SQL workloads, and report reproducible issues.

### Source excerpt

DuckDB's development team in Amsterdam has started getting DuckDB v2.0 ready for release in October. If you like shiny new things, try out the alpha releases now and report anything that might not be working as expected!

## DuckLabs to Join AWS, Projects to Remain Open Source

DevFeed: [DuckLabs to Join AWS, Projects to Remain Open Source](<https://devfeed.tech/articles/ducklabs-to-join-aws-projects-to-remain-open-source-4810.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/26/ducklabs-to-join-aws.html>)

Author: Mark Raasveldt and Hannes Mühleisen

Published: 2026-08-26T00:00:00Z

Content type: news

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Amazon Web Services (AWS)](<https://devfeed.tech/topics/amazon-web-services-aws.md>), [amazon](<https://devfeed.tech/topics/amazon.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-web-services-aws](<https://devfeed.tech/tags/amazon-web-services-aws.md>), [deep-dive](<https://devfeed.tech/tags/deep-dive.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [projects](<https://devfeed.tech/tags/projects.md>), [software](<https://devfeed.tech/tags/software.md>)

### AI overview

DuckLabs will join Amazon Web Services as a new subsidiary, with the change expected to take effect in early September. DuckDB, DuckLake, Quack, and related extensions will remain free and open source under the MIT license, with their roadmap, governance model, and development pace unchanged.

### Source excerpt

DuckLabs will join Amazon Web Services (AWS), which is expected to be effective in early September. The projects will remain open-source under the MIT license.

## DuckDB Table Functions in Java

DevFeed: [DuckDB Table Functions in Java](<https://devfeed.tech/articles/duckdb-table-functions-in-java-4807.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/25/table-functions-in-java.html>)

Author: Geertjan Wielenga, Alex Kasko

Published: 2026-08-25T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [C++](<https://devfeed.tech/topics/c-plus-plus.md>)

Tags: [c-plus-plus](<https://devfeed.tech/tags/c-plus-plus.md>), [data](<https://devfeed.tech/tags/data.md>), [deep-dive](<https://devfeed.tech/tags/deep-dive.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [java](<https://devfeed.tech/tags/java.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

DuckDB's Java client can register pure-Java table functions that expose Java-accessible data sources as SQL tables, enabling joins across remote systems and local files without an export step.

### Source excerpt

The DuckDB Java client can register table functions written in pure Java, exposing any Java-accessible data source as a SQL table. That turns DuckDB into a single-node query engine for heterogeneous joins across remote systems and local files, with no export step.

## How DuckDB Runs Recursive CTEs Faster

DevFeed: [How DuckDB Runs Recursive CTEs Faster](<https://devfeed.tech/articles/how-duckdb-runs-recursive-ctes-faster-4805.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/25/how-duckdb-runs-recursive-ctes-faster.html>)

Author: Denis Hirn

Published: 2026-08-25T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [deep-dive](<https://devfeed.tech/tags/deep-dive.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [performance](<https://devfeed.tech/tags/performance.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

The article explains how DuckDB's upcoming v2.0 improves recursive CTE performance by retaining reusable state across iterations, selecting execution modes based on frontier size and physical work, and probing keyed state directly. A reachability benchmark reports a median runtime reduction from 4.051 seconds in DuckDB v1.5.5 to 0.095 seconds in the v2.0 preview, a 42.6x speedup without SQL changes.

### Source excerpt

DuckDB's recursive CTE engine now treats recursion as one long-lived computation: it retains eligible epoch-invariant state, chooses execution modes from exact frontier cardinalities and physical work, probes keyed state directly and gives `USING KEY ... UNION` changed-key semantics.

## Chunked Query Results in the DuckDB Java Driver

DevFeed: [Chunked Query Results in the DuckDB Java Driver](<https://devfeed.tech/articles/chunked-query-results-in-the-duckdb-java-driver-4801.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/21/chunked-query-results-java-driver.html>)

Author: Geertjan Wielenga, Alex Kasko

Published: 2026-08-21T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [data](<https://devfeed.tech/topics/data.md>), [API](<https://devfeed.tech/topics/api.md>), [client](<https://devfeed.tech/topics/client.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [data](<https://devfeed.tech/tags/data.md>), [deep-dive](<https://devfeed.tech/tags/deep-dive.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [java](<https://devfeed.tech/tags/java.md>), [streaming](<https://devfeed.tech/tags/streaming.md>)

### AI overview

The DuckDB Java driver now supports lazily fetched query results as columnar data chunks, reducing the row-by-row and per-value overhead imposed by JDBC. The article explains the mismatch between DuckDB's vectorized execution model and JDBC's row-oriented API, and introduces the chunked-results alternative in driver version 1.5.3.0.

### Source excerpt

The DuckDB Java driver can now return query results as a lazily fetched sequence of columnar data chunks, avoiding JDBC's row-at-a-time ResultSet and its per-value overhead.

## DuckDB v2.0: Your Database Deserves a Better Parser

DevFeed: [DuckDB v2.0: Your Database Deserves a Better Parser](<https://devfeed.tech/articles/duckdb-v2-0-your-database-deserves-a-better-parser-4796.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/20/duckdb-20-peg-parser.html>)

Author: Daniël ten Wolde

Published: 2026-08-20T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

DuckDB v2.0 replaces its PostgreSQL-derived SQL parser with a PEG-based parser that is easier to evolve and extend at runtime.

### Source excerpt

DuckDB v2.0 replaces its PostgreSQL-derived SQL parser with a PEG-based parser that is easier to evolve and can be extended at runtime.

## Reconciling JSON in DuckDB, One Patch at a Time

DevFeed: [Reconciling JSON in DuckDB, One Patch at a Time](<https://devfeed.tech/articles/reconciling-json-in-duckdb-one-patch-at-a-time-4792.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/18/reconciling-json.html>)

Author: {"picture" =\> "/images/blog/authors/mustafa\_khan\_atlan.jpg"}

Published: 2026-08-18T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [JSON](<https://devfeed.tech/topics/json.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [data](<https://devfeed.tech/topics/data.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [Python](<https://devfeed.tech/topics/python.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [data](<https://devfeed.tech/tags/data.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [extension](<https://devfeed.tech/tags/extension.md>), [json](<https://devfeed.tech/tags/json.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

DuckDB v2.0 expands its JSON extension with functions for computing inverse RFC 7396 merge patches, applying patches with skip-on semantics, canonicalizing key order, and recursively removing null-valued keys. The article demonstrates how these functions support JSON reconciliation in SQL and compares them with Python implementations using synthetic CDC events.

### Source excerpt

DuckDB v2.0 will ship JSON functions that allow you to easily apply JSON patches.

## A Preview of DuckDB v2.0

DevFeed: [A Preview of DuckDB v2.0](<https://devfeed.tech/articles/a-preview-of-duckdb-v2-0-4787.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/17/duckdb-20-highlights.html>)

Author: Mark Raasveldt and Hannes Mühleisen

Published: 2026-08-17T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [features](<https://devfeed.tech/tags/features.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [release](<https://devfeed.tech/tags/release.md>), [server](<https://devfeed.tech/tags/server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

DuckDB v2.0 preview covering server mode, SQL and storage changes, asynchronous I/O, triggers, and the VARIANT type.

### Source excerpt

DuckDB v2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.

## Thank You for 40 000 Stars on GitHub

DevFeed: [Thank You for 40 000 Stars on GitHub](<https://devfeed.tech/articles/thank-you-for-40-000-stars-on-github-4783.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/08/05/github-40k-stars.html>)

Author: The DuckDB team

Published: 2026-08-05T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [GitHub](<https://devfeed.tech/topics/github.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Remote Procedure Call (RPC)](<https://devfeed.tech/topics/rpc.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [Internet of things](<https://devfeed.tech/topics/iot.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>)

Tags: [announcements](<https://devfeed.tech/tags/announcements.md>), [blog](<https://devfeed.tech/tags/blog.md>), [community](<https://devfeed.tech/tags/community.md>), [developer](<https://devfeed.tech/tags/developer.md>), [development](<https://devfeed.tech/tags/development.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [ecosystem](<https://devfeed.tech/tags/ecosystem.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [events](<https://devfeed.tech/tags/events.md>), [features](<https://devfeed.tech/tags/features.md>), [github](<https://devfeed.tech/tags/github.md>), [performance](<https://devfeed.tech/tags/performance.md>), [production](<https://devfeed.tech/tags/production.md>), [release](<https://devfeed.tech/tags/release.md>), [sql](<https://devfeed.tech/tags/sql.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [video](<https://devfeed.tech/tags/video.md>)

### AI overview

DuckDB celebrates reaching 40,000 GitHub stars by reviewing recent ecosystem growth, including DuckDB 1.4.0 and 1.5.0, the DuckLake 1.0 standard, the Quack remote protocol, community metrics, meetups, developer events, and community projects involving search, embeddings, IoT, and streaming analytics.

### Source excerpt

DuckDB just reached 40 000 stars on GitHub! Here's what happened since the last 10 000-star milestone.

## Asynchronous I/O in DuckDB: Work, Thread, Work

DevFeed: [Asynchronous I/O in DuckDB: Work, Thread, Work](<https://devfeed.tech/articles/asynchronous-i-o-in-duckdb-work-thread-work-4778.md>)

Original publisher: [Read original article](<https://duckdb.org/2026/07/31/asynchronous-io.html>)

Author: {"picture" =\> "/images/blog/authors/pedro\_holanda.jpg"}

Published: 2026-07-31T00:00:00Z

Content type: article

Language: en

Sources: [DuckDB](<https://devfeed.tech/sources/duckdb.md>)

Topics: [aio](<https://devfeed.tech/topics/aio.md>), [CSV](<https://devfeed.tech/topics/csv.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>)

Tags: [deep-dive](<https://devfeed.tech/tags/deep-dive.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [latency](<https://devfeed.tech/tags/latency.md>), [parquet](<https://devfeed.tech/tags/parquet.md>), [performance](<https://devfeed.tech/tags/performance.md>), [s3](<https://devfeed.tech/tags/s3.md>)

### AI overview

DuckDB v2.0 will add asynchronous reads for Parquet and CSV files to improve query performance when remote I/O cannot saturate available bandwidth. The article contrasts local SSD workloads with remote data-lake setups using S3 and EC2, where concurrent reads can keep worker threads from waiting on network requests.

### Source excerpt

Starting with v2.0, scheduled for fall 2026, DuckDB will support asynchronous reads of Parquet and CSV files. This can significantly speed up queries when synchronous I/O does not saturate the available bandwidth, as is typical in EC2/S3 compute-storage setups.