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'+1 more matching recipedata4 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
duckdb
CLIIn-process analytical SQL database engine.
data2 recipes