jq

Created: Mar 26, 2020 by Pradeep Gowda . Updated: Nov 30, 2023 Tagged: json

jq is a command line tool that you can use it to slice and filter and map and transform JSON.

jq Manual (development version)
JQ as a dynamic functional language
jq play ground
Reshaping JSON with jq | Programming Historian – this is where I learnt how to generate from a hierarchical json object. This is a real nice tutorial to learn about jq.
8 months of pq | Sevag H > “A post announcing the 1.0 release of pq, my Rust command-line protobuf deserializer”
jq examples and cheatsheet on reddit.
Illustrated jq tutorial
Wazzaps/jqed: json interactive stream editor (jq + up) - for Linux and MacOS

fiatjaf/awesome-jq: A curated list of awesome jq tools and resources.

Associated programs

Jo

See also: jo , a tool to write JSON in the shell. Example usage:

$ jo -p name=jo n=17 parser=false
{
    "name": "jo",
    "n": 17,
    "parser": false
}

jc

2020-06-01: https://github.com/kellyjonbrazil/jc This tool converts the output of popular command-line tools and file-types to JSON. This allows piping of output to tools like jq.

Example:

$ ls -l /usr/bin | jc --ls | jq '.[] | select(.size > 50000000)'
{
  "filename": "docker",
  "flags": "-rwxr-xr-x",
  "links": 1,
  "owner": "root",
  "group": "root",
  "size": 68677120,
  "date": "Aug 14 19:41"
}

jtbl

2020-06-01: https://github.com/kellyjonbrazil/jtbl – A simple cli tool to print JSON and JSON Lines data as a table in the terminal

Example:

$  cat cities.json | jtbl
  LatD    LatM    LatS  NS      LonD    LonM    LonS  EW    City               State
------  ------  ------  ----  ------  ------  ------  ----  -----------------  -------
    41       5      59  N         80      39       0  W     Youngstown         OH
    42      52      48  N         97      23      23  W     Yankton            SD
    46      35      59  N        120      30      36  W     Yakima             WA
    42      16      12  N         71      48       0  W     Worcester          MA

jello - Filter JSON and JSON Lines data with Python syntax

2020-06-01: jello

jid - json incremental digger

2020-06-05: simeji/jid

jj - JSON Stream editor

2023-05-26: tidwall/jj)

fq - jq for binary formats

2023-06-03: wader/fq: jq for binary formats - tool, language and decoders for working with binary and text formats It was originally designed to query, inspect and debug media codecs and containers like mp4, flac, mp3, jpeg. But has since then been extended to support a variety of formats like executables, packet captures (with TCP reassembly) and serialization formats like JSON, YAML, XML, ASN1 BER, Avro, CBOR, protobuf. In addition it also has functions to work with URL:s, convert to/from hex, number bases, search for things etc.

jaq

jaq aims to support a large subset of jq’s syntax and operations.

Goals: 1. Correctness 2. Performance 3. Simplicity

Faq

jzelinskie/faq: Format Agnostic jQ

faq is a tool intended to be a more flexible “jq”, supporting additional formats. The additional formats are converted into JSON and processed with libjq. Supported formats: BSON, Bencode, JSON, TOML, XML, YAML.