About this project

DuckDB is an analytical database system that provides a rich SQL dialect supporting window functions, nested correlated subqueries, and complex types such as arrays, structs, and maps. It is designed to be portable and easy to deploy, available as a standalone CLI application and through clients for Python, R, Java, and Wasm. It features deep integrations with data analysis tools like pandas and dplyr. Key capabilities include: - Direct data import from CSV and Parquet files via SQL FROM clauses. - Support for various extensions to enhance SQL usability. - In-process architecture for high-performance analytical workloads. For developers, the project is built using CMake and requires a C++17 compliant compiler and Python 3.