duckdb
About duckdb
DuckDB is an analytical database system designed for high performance and ease of use. It operates as an in-process SQL database management system, making it suitable for embedded applications. DuckDB supports a rich SQL dialect with advanced features like nested subqueries, window functions, and complex data types.
DuckDB is available as a standalone CLI application and offers client libraries for Python, R, Java, and Wasm. It integrates deeply with popular data analysis tools like pandas and dplyr, enhancing its utility for data-driven workflows.
The database is portable and reliable, making it a practical choice for analytical tasks. It simplifies data import from formats like CSV and Parquet, allowing users to query files directly without complex setup.
Key features
- Supports advanced SQL features like nested subqueries and window functions
- Handles complex data types including arrays, structs, and maps
- Integrates with Python, R, Java, and Wasm
- Deep integration with pandas and dplyr
- Simplifies data import from CSV and Parquet files
- Available as a standalone CLI application
Download v1.5.4
Jun 17, 2026WindowsWindows
macOSmacOS
LinuxLinux
Frequently asked questions
- Is duckdb free?
- Yes. duckdb is free and open-source software, distributed under the MIT license.
- Which platforms does duckdb support?
- duckdb provides downloads for Windows, macOS, Linux.
- What is the latest version of duckdb?
- The latest version is v1.5.4, released on Jun 17, 2026.
- What is DuckDB?
- DuckDB is an analytical in-process SQL database management system designed for high performance and ease of use.
- How can I install DuckDB?
- Installation instructions for DuckDB can be found on its official installation page.
- What platforms does DuckDB support?
- DuckDB is available as a standalone CLI application and supports clients for Python, R, Java, and Wasm.
- What license does DuckDB use?
- The license information for DuckDB is not explicitly mentioned in the provided README.
More Data & Database
netdata
netdata
Netdata provides full stack observability with AI-powered insights, designed to be efficient and accessible for small teams. It focuses on delivering fast and comprehensive monitoring capabilities.
meilisearch
meilisearch
Meilisearch is a fast search engine API designed to integrate AI-powered hybrid search functionality into websites and applications. It focuses on delivering efficient and accurate search results for enhanced user experiences.
etcd
etcd-io
etcd is a distributed key-value store designed for reliably storing critical data in distributed systems. It provides consistent and highly available storage for configuration data, service discovery, and coordination.