csvkit
CLIA suite of utilities for converting and working with CSV files.
Get stats on a CSV file~98% est.
csvstat data.csv+2 more matching recipesdata3 recipes
miller
CLILike awk/sed/cut/join/sort for name-indexed data (CSV, JSON, TSV).
Filter CSV rows by condition~97% est.
mlr --csv filter '$age > 30' data.csv+2 more matching recipesdata3 recipes
duckdb
CLIIn-process analytical SQL database engine.
Query CSV with SQL~98% est.
duckdb -c "SELECT count(*), avg(price) FROM 'data.csv'"+1 more matching recipedata2 recipes
psql
CLIPostgreSQL interactive terminal, used non-interactively for one-shot queries and scripts.
Export a query as CSVVerified macOS · Linux
psql "$DATABASE_URL" -Atc "COPY (SELECT slug, name FROM tools ORDER BY slug LIMIT 2) TO STDOUT WITH CSV HEADER"data4 recipes · 4 verified
sqlite3
CLICommand-line shell for SQLite databases. Preinstalled on macOS; apt install sqlite3 on Linux.
Import a CSV (with header row) into an existing tableVerified macOS · Linux
sqlite3 app.db '.import --csv --skip 1 users.csv users'data5 recipes · 5 verified