# DuckDB Published articles for DuckDB. 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]() Original publisher: [Read original article]() Author: The DuckDB team Published: 2026-09-16T00:00:00Z Content type: tutorial Language: en Sources: [DuckDB]() Topics: [DuckDB](), [Claude Code](), [Command-line interface](), [data](), [CSV](), [parquet]() Tags: [claude-code](), [cli](), [csv](), [data](), [duckdb](), [parquet](), [using-duckdb]() ### 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. ## Run DuckDB analytics on your Amazon DynamoDB data with zero-ETL DevFeed: [Run DuckDB analytics on your Amazon DynamoDB data with zero-ETL]() Original publisher: [Read original article]() Author: Lee Hannigan Published: 2026-09-11T14:53:57Z Content type: tutorial Language: en Sources: [AWS Database Blog]() Topics: [Databases](), [Amazon S3](), [Apache Iceberg](), [AWS Lambda](), [AWS IAM](), [Latency]() Tags: [advanced-300](), [amazon-dynamodb](), [amazon-s3-tables](), [analytics](), [apache-iceberg](), [aws-lambda](), [duckdb](), [how-to](), [iam](), [integration](), [sql](), [technical-how-to]() ### AI overview This tutorial explains how to run ad hoc SQL analytics on Amazon DynamoDB data with DuckDB through a zero-ETL replication flow. ### Source excerpt Run ad hoc SQL analytics on your Amazon DynamoDB data with DuckDB. A zero-ETL integration replicates your table into Apache Iceberg tables on Amazon S3 Tables, and an AWS Lambda function running DuckDB serves SQL queries through an IAM-authorized function URL. ## Unifying governance across engines and catalogs in the Open Lakehouse DevFeed: [Unifying governance across engines and catalogs in the Open Lakehouse]() Original publisher: [Read original article]() Author: Daniel Weeks; Ryan Blue; Andrei Tserakhau Published: 2026-09-10T15:05:10Z Content type: article Language: en Sources: [Databricks]() Topics: [Apache Iceberg](), [data](), [databricks](), [Apache Spark](), [DuckDB]() Tags: [apache](), [apis](), [catalog](), [data](), [databricks](), [duckdb](), [governance](), [open](), [product](), [spark]() ### AI overview The article examines two additions to the Apache Iceberg REST Catalog specification: read restrictions and catalog labels. It explains how they support governance across catalogs and engines, including centralized and delegated enforcement, and discusses trust requirements for engines such as Spark, DuckDB, and Trino. ### Source excerpt In our previous posts, we showed how open table formats, open APIs and unified governance... ## Introducing chdb Postgres extension: High-performance imports from cloud storage DevFeed: [Introducing chdb Postgres extension: High-performance imports from cloud storage]() Original publisher: [Read original article]() Author: David Wheeler Published: 2026-09-08T15:42:52Z Content type: release Language: en Sources: [ClickHouse Blog]() Topics: [clickhouse](), [cloud-infrastructure](), [Amazon S3](), [parquet](), [CSV]() Tags: [benchmark](), [clickhouse](), [cloud](), [duckdb](), [extension](), [json](), [parquet](), [performance](), [postgres](), [s3](), [storage]() ### AI overview chdb is a new Postgres extension that uses the in-process ClickHouse engine to import and export data across cloud storage systems and formats. The article presents import benchmarks, format support, and usage through a query function and a COPY hook module. ### Source excerpt The chdb Postgres extension brings fast imports and exports across cloud storage platforms and data formats, powered by the embedded ClickHouse engine. ## Try DuckDB v2.0-alpha DevFeed: [Try DuckDB v2.0-alpha]() Original publisher: [Read original article]() Author: The DuckDB team Published: 2026-09-02T00:00:00Z Content type: release Language: en Sources: [DuckDB]() Topics: [releases]() Tags: [bug](), [development](), [duckdb](), [extension](), [python](), [release](), [releases](), [sql](), [testing]() ### 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! ## AWS Weekly Roundup: Welcome DuckLabs to the team, Agentic Resource Discovery (ARD), and more (August 31, 2026) DevFeed: [AWS Weekly Roundup: Welcome DuckLabs to the team, Agentic Resource Discovery (ARD), and more (August 31, 2026)]() Original publisher: [Read original article]() Author: Daniel Abib Published: 2026-08-31T14:45:25Z Content type: news Language: en Sources: [AWS News Blog]() Topics: [data](), [Amazon S3](), [Amazon Redshift](), [Node.js]() Tags: [acquisition](), [amazon-ec2](), [amazon-elastic-container-service](), [amazon-gamelift](), [amazon-redshift](), [amazon-s3](), [amazon-sagemaker](), [amazon-sagemaker-ai](), [analytics](), [announcements](), [aws](), [aws-fargate](), [aws-glue](), [aws-iot-core](), [aws-lambda](), [database](), [duckdb](), [json](), [news](), [node-js](), [open-source](), [parquet](), [python](), [sql](), [week-in-review]() ### AI overview AWS weekly roundup covering the planned acquisition of DuckLabs, the company behind DuckDB, alongside Amazon ECS recovery updates and AWS Lambda preview runtimes for Node.js 26 and Python 3.15. ### Source excerpt The news that interested me the most last week was the DuckLabs acquisition. AWS has signed a definitive agreement to acquire DuckLabs, the Amsterdam-based company behind DuckDB, the popular open source analytical database that runs in-process and executes SQL directly against files like Parquet, CSV, and JSON. DuckDB stays open source under its independent foundation [...] ## DuckDB and the changing physics of analytics DevFeed: [DuckDB and the changing physics of analytics]() Original publisher: [Read original article]() Author: werner@allthingsdistributed.com (Dr. Werner Vogels) Published: 2026-08-26T14:00:00Z Content type: opinion Language: en Sources: [All Things Distributed]() Topics: [DuckDB](), [data](), [Databases](), [Amazon S3](), [Amazon Web Services](), [Computer science]() Tags: [analytics](), [aws](), [data](), [databases](), [duckdb](), [posts](), [s3](), [software](), [systems]() ### AI overview The article describes how changing relative costs for compute, memory, and networking are enabling more data processing to remain within applications. It presents DuckDB as a database supporting this shift and discusses its relationship to AWS data offerings, including S3 Files, S3 Tables, and S3 Vectors, alongside DuckLabs joining AWS. ### Source excerpt In this post, Andy Warfield explains how databases like DuckDB are enabling a new way to build with data, why they matter right now, and how they complement the work we've been doing in S3 (e.g., S3 Files, S3 Tables, S3 Vectors). And most importantly, why DuckLabs, the team behind DuckDB, is joining AWS ## DuckLabs to Join AWS, Projects to Remain Open Source DevFeed: [DuckLabs to Join AWS, Projects to Remain Open Source]() Original publisher: [Read original article]() Author: Mark Raasveldt and Hannes Mühleisen Published: 2026-08-26T00:00:00Z Content type: news Language: en Sources: [DuckDB]() Topics: [DuckDB](), [Open Source](), [Amazon Web Services (AWS)](), [amazon]() Tags: [amazon](), [amazon-web-services-aws](), [deep-dive](), [duckdb](), [open-source](), [projects](), [software]() ### 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]() Original publisher: [Read original article]() Author: Geertjan Wielenga, Alex Kasko Published: 2026-08-25T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [data](), [C++]() Tags: [c-plus-plus](), [data](), [deep-dive](), [duckdb](), [java](), [sql]() ### 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]() Original publisher: [Read original article]() Author: Denis Hirn Published: 2026-08-25T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [SQL](), [Databases]() Tags: [deep-dive](), [duckdb](), [performance](), [sql]() ### 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]() Original publisher: [Read original article]() Author: Geertjan Wielenga, Alex Kasko Published: 2026-08-21T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [Database](), [data](), [API](), [client]() Tags: [api](), [data](), [deep-dive](), [documentation](), [duckdb](), [java](), [streaming]() ### 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]() Original publisher: [Read original article]() Author: Daniël ten Wolde Published: 2026-08-20T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [Database]() Tags: [database](), [duckdb](), [postgresql](), [release](), [sql]() ### 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]() Original publisher: [Read original article]() Author: {"picture" =\> "/images/blog/authors/mustafa\_khan\_atlan.jpg"} Published: 2026-08-18T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [JSON](), [Databases](), [data](), [SQL](), [Benchmark](), [Python]() Tags: [benchmark](), [data](), [duckdb](), [extension](), [json](), [python](), [sql]() ### 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. ## Agent Night demo recap: Brian Douglas's self-healing Pokémon agent DevFeed: [Agent Night demo recap: Brian Douglas's self-healing Pokémon agent]() Original publisher: [Read original article]() Author: WorkOS Published: 2026-08-17T18:34:12Z Content type: news Language: en Sources: [WorkOS Blog]() Topics: [Demo](), [observability ai agents](), [telemetry](), [Claude Code](), [Python](), [DuckDB](), [Kafka](), [Code](), [Open Source]() Tags: [agent](), [claude-code](), [code](), [coding](), [demo](), [duckdb](), [kafka](), [open-source](), [python](), [self-healing](), [telemetry](), [traces]() ### AI overview A recap of Brian Douglas's Agent Night demo shows how Paper Compute ran Pokémon as a self-healing agent for six months. The setup uses Claude Code, a headless Python emulator, and traces from each session and turn. The article explains how labeled traces and per-session reflections can make the agent's history searchable and useful for improvement. ### Source excerpt Brian Douglas of Paper Compute closed Agent Night with six months of running Pokémon as a self-healing agent: traces, anomalies, dreams, and inceptions. ## A Preview of DuckDB v2.0 DevFeed: [A Preview of DuckDB v2.0]() Original publisher: [Read original article]() Author: Mark Raasveldt and Hannes Mühleisen Published: 2026-08-17T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [Database](), [MySQL]() Tags: [api](), [duckdb](), [features](), [mysql](), [release](), [server](), [sql](), [storage]() ### 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]() Original publisher: [Read original article]() Author: The DuckDB team Published: 2026-08-05T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [GitHub](), [SQL](), [Remote Procedure Call (RPC)](), [Embeddings](), [Internet of things](), [Streaming]() Tags: [announcements](), [blog](), [community](), [developer](), [development](), [duckdb](), [ecosystem](), [embeddings](), [events](), [features](), [github](), [performance](), [production](), [release](), [sql](), [streaming](), [video]() ### 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]() Original publisher: [Read original article]() Author: {"picture" =\> "/images/blog/authors/pedro\_holanda.jpg"} Published: 2026-07-31T00:00:00Z Content type: article Language: en Sources: [DuckDB]() Topics: [aio](), [CSV](), [Amazon S3](), [Amazon EC2]() Tags: [deep-dive](), [duckdb](), [latency](), [parquet](), [performance](), [s3]() ### 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. ## Data Engineering Weekly #280 DevFeed: [Data Engineering Weekly #280]() Original publisher: [Read original article]() Author: Ananth Packkildurai Published: 2026-07-27T03:37:19Z Content type: article Language: en Sources: [Data Engineering Weekly]() Topics: [data-engineering](), [Data Infrastructure](), [Open Source](), [Data Quality](), [DuckDB](), [Database]() Tags: [data](), [data-engineering](), [data-infrastructure](), [data-quality](), [database](), [duckdb](), [engineering](), [open-source](), [python]() ### AI overview Data Engineering Weekly #280 is a newsletter roundup covering updates to leetdata.ai and aidataengineer.io, agent-oriented data infrastructure, open-source modern data stack tools, data-tool landscapes, metric certification, and data quality in the AI era. ### Source excerpt The Weekly Data Engineering Newsletter ## Agentic Data Engineering Is Here -- But Can It Close the Loop? DevFeed: [Agentic Data Engineering Is Here -- But Can It Close the Loop?]() Original publisher: [Read original article]() Author: Daniel Beach Published: 2026-07-22T14:05:27Z Content type: article Language: en Sources: [Data Engineering Central]() Topics: [data-engineering](), [Orchestration](), [data observability](), [Artificial Intelligence](), [AI-assisted coding](), [DuckDB](), [Apache Iceberg]() Tags: [agentic](), [ai-agents](), [data-engineering](), [duckdb](), [orchestration](), [pipelines]() ### AI overview A podcast conversation with Hugo Lu about agentic data engineering and the infrastructure needed for data platforms to execute work, observe outcomes, validate changes, and improve pipelines safely. It examines why production data systems remain difficult for AI, including schema changes, realistic testing, business semantics, and secure execution. ### Source excerpt a conversation with Hugo Lu ## The Creator of Pandas on AI, Apache Arrow, and the Future of Software Engineering DevFeed: [The Creator of Pandas on AI, Apache Arrow, and the Future of Software Engineering]() Original publisher: [Read original article]() Author: Daniel Beach Published: 2026-07-08T12:16:09Z Content type: article Language: en Sources: [Data Engineering Central]() Topics: [pandas](), [data-engineering](), [Artificial Intelligence](), [DuckDB](), [data-platforms](), [software-development](), [future of software](), [Apache Spark](), [Hadoop](), [Open Source](), [parquet]() Tags: [ai](), [apache-arrow](), [arrow](), [data](), [data-engineering](), [data-platforms](), [duckdb](), [hadoop](), [large-language-models](), [open-source](), [pandas](), [parquet](), [software-development]() ### AI overview An interview with Wes McKinney covers the origins of pandas and Apache Arrow, the evolution of modern data engineering from Hadoop to lakehouse architectures, and the roles of tools such as Parquet, DuckDB, DataFusion, and Spark. McKinney also discusses how AI affects software development, arguing that it can improve experienced engineers' productivity but does not replace software engineering, architecture, or judgment. ### Source excerpt interview with Wes McKinney ## How we migrated a live routing system using AI-assisted refactoring DevFeed: [How we migrated a live routing system using AI-assisted refactoring]() Original publisher: [Read original article]() Author: Arnold Wakim Published: 2026-06-23T00:00:00Z Content type: article Language: en Sources: [Datadog | The Monitor blog]() Topics: [AI-assisted coding](), [migration](), [Test-driven development](), [cursor](), [Kafka]() Tags: [ai](), [claude](), [cursor](), [duckdb](), [kafka](), [migration](), [postgresql](), [production](), [refactoring](), [routing](), [storage]() ### AI overview An engineering account of migrating Stream Router's storage architecture with AI-assisted, test-driven refactoring while preserving live production traffic. ### Source excerpt Using AI-assisted refactoring, we migrated our live routing brain to a relational model, safely validating changes against live production traffic. ## RAG in Go: A Vulnerability Research Tool DevFeed: [RAG in Go: A Vulnerability Research Tool]() Original publisher: [Read original article]() Published: 2026-04-20T00:00:00Z Content type: tutorial Language: en Sources: [William Kennedy]() Topics: [Retrieval Augmented Generation (RAG)](), [Go Language](), [vulnerability](), [DuckDB](), [JSON]() Tags: [api](), [ardan-labs](), [blog](), [code](), [database](), [duckdb](), [embedding](), [go](), [go-programming](), [golang](), [json](), [llm](), [programming](), [rag](), [retrieval](), [technical](), [vulnerability]() ### AI overview This tutorial demonstrates how to build a retrieval-augmented generation tool in Go using the Go Vulnerability Database as internal documents. It covers ingesting zipped JSON data, generating vector embeddings, storing them in DuckDB, and retrieving documents relevant to a user query. ### Source excerpt Introduction In the previous post, you saw how you can use tools to add information to an LLM query. In this post, we'll see another method of adding information to an LLM called RAG, or Retrieval-Augmented Generation. The idea of RAG is that you want the LLM to have access to information that wasn't available to it when it was initially trained. You do it by storing documents in your own database along with their embedding. I won't go into the technical details of embedding, but think of it as a way to convert a piece of text into a vector. The magic is that if two pieces of text have similar meaning, an embedding model can create vectors that mathematically show they are similar. ## Data Tables & Ducklake: managed storage for workflows DevFeed: [Data Tables & Ducklake: managed storage for workflows]() Original publisher: [Read original article]() Author: Diego Imbert Published: 2026-03-31T00:00:00Z Content type: release Language: en Sources: [Windmill Blog]() Topics: [data](), [Databases](), [Amazon S3](), [PostgreSQL](), [DuckDB](), [Orchestration]() Tags: [data](), [databases](), [duckdb](), [launch-week](), [orchestration](), [postgresql](), [s3](), [sql](), [storage]() ### AI overview Windmill introduces Data Tables, a workspace-scoped PostgreSQL layer with managed credentials and SQL access, and Ducklake, a data lakehouse backed by S3. The release is designed to let workflows read and write relational and analytical data within the Windmill platform. ### Source excerpt Introducing Data Tables and Ducklake: managed SQL storage and S3-backed data lakehouse in Windmill. ## OpenDroneLog: A Self Hosted DJI Flight Log Dashboard DevFeed: [OpenDroneLog: A Self Hosted DJI Flight Log Dashboard]() Original publisher: [Read original article]() Author: Jeremy Published: 2026-03-02T14:34:38Z Content type: article Language: en Sources: [Noted]() Topics: [Flight](), [dashboards](), [Self-hosted](), [Local-First](), [Docker](), [DuckDB](), [React](), [Tauri](), [telemetry]() Tags: [docker](), [duckdb](), [local](), [local-first](), [maps](), [react](), [self-hosted](), [self-hosted-logging](), [storage](), [tauri](), [telemetry]() ### AI overview OpenDroneLog is a self-hosted dashboard for analyzing DJI flight logs and Litchi CSV exports. It organizes local telemetry into maps, charts, battery-health tracking, maintenance data, and printable reports, with desktop and Docker-deployable web versions. ### Source excerpt OpenDroneLog is a self hosted flight log dashboard for DJI and Litchi files that turns raw telemetry into maps, charts, battery health insights, and printable reports using a Docker deployable web app with local first storage. [Next page]()