duckdb
DuckDB is a high-performance analytical database system
What is duckdb?
DuckDB is a high-performance analytical database system
Overview of duckdb
What it is
DuckDB is a high-performance analytical database system. It runs in-process inside your application, so there is no separate server to manage and no external dependencies. It can read remote files, query other databases, and connect to other DuckDB instances when needed. DuckDB provides a rich SQL dialect with support for arbitrary and nested correlated subqueries, window functions, collations, and complex types (arrays, structs, maps). It is available as a standalone CLI application and has clients for Python, R, Java, Rust, Go, Wasm, and many more, with deep integrations with packages such as pandas.
Key features
- Runs in-process inside your application with no separate server or external dependencies.
- Reads and writes a wide range of file formats including CSV, Parquet, JSON, and Excel from local disk or remote endpoints (S3, HTTP(S), Azure, Google Cloud Storage).
- Supports open lakehouse formats: DuckLake, Apache Iceberg, and Delta Lake.
- Connects to other database systems (PostgreSQL, MySQL, SQLite) via native protocols for in-place queries.
- DuckDB instances can connect to each other over the quack protocol, turning a DuckDB instance into a server.
- Has a modular extension mechanism: core extensions are bundled, community and third-party extensions can be installed and loaded at runtime.
Use cases
DuckDB is designed for analytical workloads, data analysis, and in-process database needs. It is suitable for querying remote files, connecting to other databases without ETL, and embedding a database directly into applications. Its support for multiple file formats and lakehouse formats makes it useful for data engineering and analytics pipelines.
Getting started
See the repository README for installation instructions.
License and pricing
License: MIT. Pricing: open source.
Based on the project's public README and repository metadata.