DuckDB

In-process analytical SQL database

DuckDB is an embedded columnar database for fast analytical SQL queries over local files like CSV and Parquet, usable from many languages.

Visit DuckDB ↗

Pricing: Free

Platforms: Mac, Windows, Linux

Categories: Databases

DuckDB compared with similar tools

Product	Price	Open source	Self-host	Platforms
DuckDB	Free	Yes	–	Mac, Windows, Linux
MotherDuck	Free plan	–	–	Web, API
ClickHouse	Free plan	Yes	Yes	Web, Self-hosted, Linux, Mac
Datasette	Free	Yes	Yes	Self-hosted, Web
Drizzle ORM	Free	–	–	API
Turso	Free plan	–	–	Web, API
Beekeeper Studio	Free plan	Yes	–	Mac, Windows, Linux

Similar to DuckDB

MotherDuck

Cloud data warehouse built on DuckDB

MotherDuck is a serverless analytics service that runs DuckDB in the cloud and lets local DuckDB queries combine with cloud data.

Free plan · Web, API · Website ↗

ClickHouse

Open-source columnar database for real-time analytics

ClickHouse is a fast column-oriented SQL database for analytics and log data, available open source or as ClickHouse Cloud.

Free plan · Web, Self-hosted, Linux, Mac · Website ↗

Datasette

Open-source tool for exploring and publishing data

Datasette lets you explore, query and publish SQLite databases as interactive websites and JSON APIs, with a large plugin ecosystem.

Free · Self-hosted, Web · Website ↗

Drizzle ORM

Lightweight TypeScript ORM with SQL-like syntax

Drizzle ORM is a headless TypeScript ORM for Postgres, MySQL and SQLite with type-safe queries and a migration toolkit.

Free · API · Website ↗

Turso

Hosted SQLite databases built on libSQL

Turso offers managed SQLite-compatible databases based on libSQL, with embedded replicas and many small databases per app.

Free plan · Web, API · Website ↗

Beekeeper Studio

Open-source SQL editor and database manager

Beekeeper Studio is a cross-platform SQL editor and database GUI for PostgreSQL, MySQL, SQLite, SQL Server and more, with a free community edition.

Free plan · Mac, Windows, Linux · Website ↗

Litestream

Streaming replication of SQLite databases to S3

Litestream continuously replicates SQLite databases to S3-compatible storage and other targets, giving simple disaster recovery for SQLite in production.

Free · Linux, Mac, Self-hosted · Website ↗

Tiger Data (TimescaleDB)

Postgres for time-series and real-time analytics

Tiger Data, formerly Timescale, develops TimescaleDB, a Postgres extension for time-series data, and a managed cloud for it.

Free plan · Web, Self-hosted, Linux · Website ↗

Questions

Is DuckDB free?

DuckDB is free.

Is DuckDB open source?

Yes, DuckDB is open source.

What platforms does DuckDB run on?

DuckDB is available for Mac, Windows, Linux.

What are some alternatives to DuckDB?

Similar indie products include MotherDuck, ClickHouse, Datasette, Drizzle ORM and 4 more.

Is this your product? Submit an update.