Skip to main content
50% off all plans, limited time. Starting at $2.48/mo
DuckDB

DuckDB

DuckDB is an in-process analytics database. SQLite-style file-based OLAP for data scientists, with Pandas, Parquet, Arrow, and CSV support out of the box. Used by Hugging Face and Posit. Runs analytical queries 100x faster than Postgres on the same hardware for read-heavy workloads.

At a glance

39k

GitHub stars

84

Page views

119

Active installs

License MIT Version Latest OS Ubuntu Server 24.04 LTS Min RAM 1 GB IP IPV4,IPV6

Active installs is sample data (staging preview); real metric wires in before launch.

Start DuckDB

Open an in-memory database:

duckdb

Or open/create a persistent database file:

duckdb my_database.duckdb

Common Commands

Show help:

duckdb -help

Check version:

duckdb -version

Example Workflow

# Start DuckDB with a persistent database
duckdb analytics.duckdb

# Inside DuckDB shell
CREATE TABLE users(id INTEGER, name VARCHAR);
INSERT INTO users VALUES (1, 'Alice');

SELECT * FROM users;

More in Database Tools

Related apps.

Deploy DuckDB now. From $2.48/mo.