DuckDB

Health v2 · maintenance only

Adoption not part of the score

42114 stars · 3904 forks observed · 2026-10-12

What it is AI-extracted, prompt v1, taxonomy v1, 2026-09-28, confidence 0.99

DuckDB is a high‑performance, in‑process analytical SQL database written in C++. It provides a rich SQL dialect, supports many file formats, and offers native client libraries for multiple languages.

Use cases

• run ad‑hoc analytics on CSV or Parquet files without a server
• embed a fast OLAP engine inside a Python or R data‑science workflow
• perform complex SQL queries on data stored in object storage or local files
• use a lightweight SQL engine for testing or CI pipelines
• build data‑processing pipelines that need fast, columnar analytics in‑process

When to choose

• you need an embedded, zero‑configuration SQL engine for analytics
• your workload is read‑heavy and benefits from columnar storage
• you want seamless integration with pandas, dplyr, or other data‑science tools
• you prefer a single binary or library that runs on many platforms

When to avoid

• you require a full‑featured transactional OLTP database with high write concurrency
• you need built‑in sharding, replication, or distributed query execution across many nodes
• your application depends on proprietary database features not supported by DuckDB

Facets

library · maturity active

database database-driver data-science databases analytics backend windows wasm python go jvm rust in-process olap analytical embedded columnar friendly-sql extensible sql linux macos nodejs c++

Member repositories

For agents

markdown · JSON · MCP: product_card(name="duckdb/duckdb")