duckdb
CLIIn-process analytical SQL database engine.
0 views
Installation
Homebrew
brew install duckdbLinks
License
MITAI Agent Notes
Run SQL analytics on CSV, Parquet, and JSON files without a server
When to use
Analysing large datasets with SQL directly from files
Examples
duckdb -c "SELECT * FROM 'data.csv' LIMIT 10"duckdb -c "COPY (SELECT * FROM 'data.parquet') TO 'out.csv' (HEADER)"
Proven Recipes
Query CSV with SQL🟢 98% success
duckdb -c "SELECT count(*), avg(price) FROM 'data.csv'"Convert Parquet to CSV🟢 97% success
duckdb -c "COPY (SELECT * FROM 'data.parquet') TO 'output.csv' (HEADER, DELIMITER ',')"