Data and AI engineering blogs

191 blogs · 540 this month

DuckDB Blog the engineering blog of DuckDB: latest posts and feed

DuckDB · Engineering blog · 9.2 a month · 25 posts since Aug 18, 2026

Oct 16

From JSON Strings to Typed Columns

JSON often arrives as a text column inside a table, not as a file. In this post, we infer a schema from such a column, adjust it, and turn the column into typed columns, without first writing the data to a file.

Oct 13

What Is inside an Iceberg Table?

An Iceberg table is a tree of JSON, Avro and Parquet files. DuckDB can read every one of them, so you can walk the tree yourself with SQL: from the metadata file, through the manifest list and manifests, down to the data files and delete...

Oct 9

Agent Mode in the DuckDB CLI

The DuckDB v2.0 CLI has an agent mode that gets AI coding agents to a correct result faster and with fewer tokens. When the CLI detects an agent, it prints compact Markdown tables instead of padded boxes, says clearly when a result was...

Oct 7

A DuckDB Database with No Data in It

A DuckDB database file does not have to hold any data. It can store nothing but view definitions that point at Parquet files on object storage, so a few hundred kilobytes behave like a shared catalog over a whole data lake.

Sep 29

Jev and DuckDB: Plain-English Conditions in SQL

TypeSafe AI released Jev, a model that returns typed answers instead of text, on September 15, 2026. Within ten days, several community extensions let you filter, classify and score DuckDB rows with plain-English conditions.

Sep 16

DuckDB Skills for Claude Code

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...

Sep 2

Try DuckDB v2.0-alpha

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!

Aug 25

How DuckDB Runs Recursive CTEs Faster

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...

About this blog

Releases, benchmarks and internals of the in-process analytical database.

Posts per week, last 26 weeks

9.2 a month over the last six months (or since the feed's oldest post)

Writes about

Databases (21), Data engineering (2), Developer tools (1) in the last six months.

History

Official checkSep 25

not reviewed to official: on duckdb.org