psql
CLIPostgreSQL interactive terminal, used non-interactively for one-shot queries and scripts.
Run one query and print only the valueVerified macOS · Linux
psql "$DATABASE_URL" -Atc 'SELECT count(*) FROM tools'+2 more matching recipesdata4 recipes · 4 verified
sqlite3
CLICommand-line shell for SQLite databases. Preinstalled on macOS; apt install sqlite3 on Linux.
Run a query with column headersVerified macOS · Linux
sqlite3 -header -column app.db 'SELECT * FROM users LIMIT 5'+1 more matching recipedata5 recipes · 5 verified
csvkit
CLIA suite of utilities for converting and working with CSV files.
Query CSV with SQL~95% est.
csvsql --query 'SELECT name FROM data WHERE age > 30' data.csvdata3 recipes
duckdb
CLIIn-process analytical SQL database engine.
Query CSV with SQL~98% est.
duckdb -c "SELECT count(*), avg(price) FROM 'data.csv'"data2 recipes
jq
CLILightweight and flexible command-line JSON processor.
text-processing7 recipes · 6 verified
yq
CLIA lightweight YAML, JSON, and XML processor.
text-processing5 recipes · 5 verified