DuckDB

Is an in-process analytical SQL database for wrangling, querying and transforming data across formats such as CSV, JSON, Parquet and Iceberg locally or in object storage. Sells to developers and data and analytics teams in businesses that need embedded analytical processing. Delivered as free and open-source MIT-licensed software with native clients for major programming languages that deploys anywhere from edge devices to servers with hundreds of cores.

Key features

• In-process analytical SQL database
• PostgreSQL-inspired query language
• Deploy from edge to multi-core servers
• Read and write CSV, JSON, Parquet
• Read and write Iceberg tables
• Object storage support
• Extensible extensions for formats and functions
• Native clients for major programming languages
• Quack client-server protocol
• DuckLake lakehouse format support
• Direct query over HTTPS and S3