DuckDB

Embedded analytics files.

Ready

DuckDB is an embedded analytics database with the same local-file model as SQLite. Open a .duckdb file or an in-memory database and query it with the schema-aware editor.

Capabilities

Connections

Ready

A .duckdb file on disk, or :memory: for an in-memory database.

Schema browser

Ready

Schemas, tables, views, sequences, and types.

SQL editor and results

Ready

Schema-aware completion and the native result grid.

Create forms

Ready

Create schemas, tables, views, and sequences.

Visual EXPLAIN

Planned

Plan output is shown as text today; the graph is planned.

In the app

ZQLZ grid of a DuckDB customers table with UUID, ENUM, and STRUCT columns — UUIDs, ENUMs, and STRUCTs in the grid, with LIST, MAP, INTERVAL, and BLOB columns in the inspector.

ZQLZ grid of a DuckDB daily revenue view — Views open like tables, here daily revenue rolled up from 242 orders.

ZQLZ SQL editor with a DuckDB query using STRUCT field access, quantile_cont, and GROUP BY ALL — STRUCT field access, quantile_cont, and GROUP BY ALL, highlighted and schema-aware.

ZQLZ grid of a 500,000-row DuckDB events table with a STRUCT properties column — A 500,000-row events table, with each event's STRUCT properties one click away.

ZQLZ grid of a DuckDB orders table with a JSON column, beside its column list — A table opens as a grid, with its column types and keys alongside.

ZQLZ grid of a DuckDB table named select with mixed-case and spaced columns and emoji values — A table named select, mixed-case and spaced columns, emoji and right-to-left values.

Connecting

Open a .duckdb or .db file from disk, or use :memory: for an in-memory database.

← All databases

DuckDB

Embedded analytics files.

Download ZQLZ View roadmap

Ready

DuckDB is an embedded analytics database with the same local-file model as SQLite. Open a .duckdb file or an in-memory database and query it with the schema-aware editor.

Capabilities

Connections

Ready

A .duckdb file on disk, or :memory: for an in-memory database.

Schema browser

Ready

Schemas, tables, views, sequences, and types.

SQL editor and results

Ready

Schema-aware completion and the native result grid.

Create forms

Ready

Create schemas, tables, views, and sequences.

Visual EXPLAIN

Planned

Plan output is shown as text today; the graph is planned.

In the app

Connecting

Open a .duckdb or .db file from disk, or use :memory: for an in-memory database.

← All databases