DuckDB

Analyze columnar data with an embedded engine.

DuckDB brings fast analytical queries to local data. Query CSV, Parquet, and JSON files directly, with no import step.

Querying files

sql

SELECT country, count(*) AS n
FROM 'events.parquet'
GROUP BY country
ORDER BY n DESC;