
Databases
How to Query JSON Columns From the Shell With Real Output
Query JSON columns from the shell in PostgreSQL, MySQL and SQLite: extract fields, filter, expand arrays, return clean output for scripts and pipe rows to jq.
6 min read
Tag
2 posts

Query JSON columns from the shell in PostgreSQL, MySQL and SQLite: extract fields, filter, expand arrays, return clean output for scripts and pipe rows to jq.

Compare jq, gron and jless for exploring JSON: querying, grep-able paths and an interactive viewer, with examples on the same document and when to use each.