Alternatives to DuckDB
In-process analytical database that queries CSV, JSON and Parquet directly. The listings below can replace it for an important use case. Each note says what changes if you switch.
The original
DuckDB
In-process analytical database that queries CSV, JSON and Parquet directly.
Replacements
Listings that take over the same core job as DuckDB.
trdsql
Query structured files with SQL from the command line.
trdsql also queries structured files with SQL from the command line, but its SQL behaviour depends on the selected database backend rather than a built-in engine.
ClickHouse
Columnar OLAP database widely used as a backend for logs, traces and metrics.
ClickHouse is a self-hosted columnar OLAP server built for very large datasets and many users, but operating it at scale takes real database administration expertise.
Also worth comparing
These listings name DuckDB as their own alternative, so the relationship runs both ways.
SQLite
A small, self-contained SQL database engine that stores a whole database in one file.
DuckDB is also an embedded, in-process database but aimed at analytics, querying CSV, JSON and Parquet files directly, released under the MIT license.
Similar software
Related functionality, not a direct replacement.
Datasette
Publishes SQLite databases as an explorable website and JSON API.
DB Browser for SQLite
Opens a SQLite file in a spreadsheet-like window so you can look at the data without writing SQL.
usql
Use one command-line interface for many database systems.
Harlequin
A SQL IDE that runs in the terminal, with adapters for DuckDB, SQLite, Postgres and more.
VisiData
An interactive terminal multitool for exploring, cleaning and converting tabular data in many formats.
Apache Superset
A self-hosted data exploration and visualization platform with a no-code chart builder and SQL IDE.
