sqlite3 app.db '.mode json' 'SELECT * FROM users;'

Category: Databases & SQL

sqlite3 app.db '.mode json' 'SELECT * FROM users;'

Output query results as JSON

Switches output to one JSON object per row, handy for feeding jq or a web API. Related: .mode csv, .mode markdown.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.