I am considering making a JSON parsing and generating command line tool. Started with looking around a bit. Below is a list of existing JSON command line tools. Numbers are [GitHub stars] at the time of adding the entry.
- jq [11126] – filter, extract, modify and output JSON or text using DSL
- jid [4426] – “You can drill down JSON interactively by using filtering queries like jq.” (item contributed by /u/Tacticus)
- gron [4103] – convert JSON or JSON lines (from file/stdin/url) to text (path=value) which can be processed with grep/sed/diff; the tool also supports converting back to JSON after such processing
- jo [2209] – generate JSON based on command line arguments and stdin; can read data from files and place it as base64 encoded values
- JSON.sh [1635] – written in shell/gawk; “traverses the JSON objects and prints out the path to the current object (as a JSON array) and then the object, without whitespace”
- underscore-cli [1588] ‘THE “Swiss Army knife” tool for processing JSON data – can be used as a simple pretty-printer, or as a full-powered JavaScript command-line’. Added on 2019-09-30 following comment from @joeytwiddle.
- jsawk [1239] – focused primarily on filtering and transforming a list (or an object). Update 2019-09-30: as @joeytwiddle suggested in comment, the project appears to be unmaintained and doesn’t work with recent Node.js versions. Latest commit and latest closed issue are from 2015.
- json (by trentm) [1218] – “massaging JSON on your Unix command line”; JS-like syntax for extracting values; in-place file editing
- jj [1037] – “JJ is a command line utility that provides a fast and simple way to retrieve or update values from JSON documents. It’s powered by GJSON and SJSON under the hood.” (item contributed by /u/RomanaOswin, 2021-03-28) (also noticed it was mentioned earlier in comments by Harald Hanche-Olsen , sorry did not see that)
- rq [1007] – awk/sed-like tool for structured data; supports several formats, including JSON
- dasel [774] – “Dasel (short for data-selector) allows you to query and modify data structures using selector strings. Comparable to jq / yq, but supports JSON, YAML, TOML, XML and CSV with zero runtime dependencies.” (item contributed by /u/AndydeCleyre, 2021-03-27)
- TickTick [469] – use JSON syntax directly in bash; “This is just a fun hack”
- jtc [427] “cli tool to extract, manipulate and transform source JSON” (item contributed by Dmitry in the comments, 2019, added 2021-03-28)
- jshon [309] – very CLI-ish way to extract, manipulate and output the data
- jl [308] – “a tiny functional language for querying and manipulating JSON”; visually reminds Haskell
- faq [248]. “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”. Supports: BSON, Bencode, JSON, TOML, XML, YAML. Added on 2020-10-11.
- jsonpp [244] – JSON pretty printer (item contributed by /u/ferbass)
- fx [227] – conveniently run your JS code to manipulate JSON.
- RecordStream [224] – create, manipulate and output records; supports JSON; Perl-based so grep expressions for example are in Perl.
- JSON.awk [186] – JSON.sh fork in awk; after fork the projects added different features.
- jp [184] – “command line interface to JMESPath” (link contributed by Evgeny Zislis)
- json-command [143] – conveniently manipulate JSON using JS.
- jsonv.sh [130] – convert JSON to CSV; specify paths in JSON to
- jgrep (aka “JSON-grep”) [78] – “Command line tool and API for parsing JSON documents” in Ruby (item contributed by /u/tophlammiepie)
- jello [61]. “Filter JSON and JSON Lines data with Python syntax”. Added on 2020-10-11.
- jsed [48] – manipulate and extract data; somewhat similar to jsawk in mindset
- nvim-jqx [24] “easily browse and preview json files in neovim” using Quickfix buffer (item contributed by /u/evergreengt, 2021-03-28)
- jtbl [21] “A simple cli tool to print JSON data as a table in the terminal.”. Added on 2020-10-11.
- yamlpath [20] “Along with providing a standard for defining YAML Paths, this project aims to provide generally-useful command-line tools which implement YAML Paths.” (item contributed by /u/AndydeCleyre, 2021-03-27)
- jayin [10] “Piping with js at terminal”. Added on 2019-09-30 following comment from @joeytwiddle.
- jsongrep [9] (by dsc) – extract data at given path using shell globs and output one per line
- jc [2] – “jc is used to JSONify the output of many standard linux cli tools”. Added on 2019-10-29 following comment from Kelly Brazil.
- jsongrep [0] (by terrycojones) – easily extract data at given path
Honourable mentions
python -m json.tool– the JSON Python module (mention contributed by Evgeny Zislis)
Update 2018-09-10
I’ve added related post in which I argue that jq functionality belongs to a shell.
If you feel that some project is missing from the list, please let me know in comments below.
Ilya's blog 
I just wanted to drop a thank you for that showstruct tool for jq. I’m always have problems with syntax and that has been very helpful. This list should be as well!
LikeLike
There’s another gawk script at https://gist.github.com/calraith/5c85d17b28e96f49e067f9b054a6fdbb for serializing / deserializing JSON. When fed a JSON string or file, the deserialize() function builds a multidimensional array from which values can be retrieved and manipulated as a hierarchical object. When fed an array (or an array of arrays), the serialize() function stringifies the array into JSON format.
LikeLike
Thanks!
LikeLike
Hi,
Also take a look at fx 🔥 and xx.
* NodeJS JSON cli tool https://github.com/antonmedv/fx
* Golang JSON cli tool https://github.com/antonmedv/xx
They have same api and really simple interface.
LikeLike
most likely it’s a misunderstanding. jtc (https://github.com/ldn-softdev/jtc) is a shell level cli tool, that takes input, validates, parses it, and let extract or manipulate resulting json – same thing that listed tools do. it just offers a novel way to select elements within the input json (via so called walk-path), but at the end, it’s still a tool to manipulate and transform input json at unix cli
LikeLike
For me it’s different enough but it’s arguable so approving the comments.
LikeLike
fx got a lot of stars recently)
LikeLike
There is also jj (https://github.com/tidwall/jj, 796 stars).
LikeLike
I can never get jq to do what I want, so I’m here looking for alternatives. Lots of interesting suggestions!
I think you could remove jsawk. It is 5 years old and doesn’t compile for recent versions of Node.
I have found underscore-cli somewhat useful: https://www.npmjs.com/package/underscore-cli
And (not JSON-specific) jayin lets us run JavaScript against any text file, with LoDash to hand: https://www.npmjs.com/package/jayin
LikeLike
Thanks! Updated.
LikeLike
Hi Ilya,
I wonder, why would not you include jtc (https://github.com/ldn-softdev/jtc) into your list of JSON tools? jtc is pretty much like jq (i.e. both are JSON processors), but has quite a few advantages over it:
1. both run on a metal, but unlike jq (written in C), jtc is written in the idiomatic C++(14 and above), which makes it free of memory/resource leaks – STL guarantee.
2. unlike jq, jtc support streaming seamlessly, which makes it effortless to utilize in between redirect (pipes).
3. due to a built-in cache engine jtc is times faster than jq (quite noticeable on processing big JSONs).
4. but the biggest advantage is that the same JSON queries are much more feasible to achieve with jtc (and it’s not my my opinion).
LikeLike
Wow. Escaped me. Added. Sorry for the delay.
LikeLike
I created a tool called jc that JSONIfies the output of many popular gnu linux commands. Instead of sed/awk/grep/cut/tr, just pipe the output to jq.
Example:
ifconfig | jc –ifconfig | jq…
https://github.com/kellyjonbrazil/jc
or ‘pip3 install –upgrade jc’
LikeLike
I was thinking about creating something similar but in context of the Next Generation Shell. The language should be shipped with a library of parsers. NGS has syntax for run-and-parse: “my_command my args“. At the moment it can detect and parse JSON and output of find command. There is some additional processing (after JSON parsing) of AWS CLI to make the data a bit more palatable, for example Tags array is converted to Hash.
See
https://github.com/ngs-lang/ngs/blob/8d785a9907de7dcc496022170fecd889d8bc353f/lib/stdlib.ngs#L5284-L5289
https://github.com/ngs-lang/ngs/blob/8d785a9907de7dcc496022170fecd889d8bc353f/lib/stdlib.ngs#L5397-L5458
https://github.com/ngs-lang/ngs/blob/8d785a9907de7dcc496022170fecd889d8bc353f/lib/stdlib.ngs#L5460-L5469
Ideally the data should be parsed into more specific objects than just structured data (to fit the language best).
LikeLike
I completely agree – my tool should not need to exist in this day and age. The OS or she’ll should provide a machine readable view of every aspect of the OS and every command that outputs list or table output should have a json option. This is just a stopgap until that day comes. 🙂
LikeLike
JSON is minimum. Most of the information is tables. We need tools for tables. awk ‘{print $8}’ should not be a thing.
In my vision of shell UI, the tables on the screen should carry semantic information and be interactive – https://github.com/ngs-lang/ngs/wiki/UI-Design
LikeLike
I created a simple cli tool called jtbl that converts JSON and JSON Lines into tables in the terminal. https://github.com/kellyjonbrazil/jtbl
LikeLike
Sorry for the delay. Added!
LikeLike
Sometimes I find it difficult to wrangle a jq query into submission. Since I’m more comfortable with python syntax, I created jello (https://github.com/kellyjonbrazil/jello) which is similar to jq, but uses full python syntax without all of the boilerplate code usually needed so you can just focus on the filtering logic.
LikeLike
Added
LikeLike
Another tool (in development) worth considering is FAQ (Format Agnostic JQ) – https://github.com/jzelinskie/faq.
Implemented using libjq, it can work on additional formats, such as BSON, Bencode, TOML, XML, YAML
LikeLike
Sorry for the delay. Added.
LikeLike
[…] instrument for working with JSON on the say-line, and there would possibly per chance be now a whole ecosystem of tools that output and manipulate […]
LikeLike
[…] https://ilya-sher.org/2018/04/10/list-of-json-tools-for-command-line/ […]
LikeLike
There is also Xidel ( https://www.videlibri.de/xidel.html ) to process JSON (and other formats) with XPath/XQuery
LikeLike
There is also a great GUI tool for comparing JSON available from DeltaXML called DeltaJSON
https://deltajsonapp.deltaxml.com/
LikeLike
I approved the comment because it’s related but not adding to the list because the list has only CLI tools
LikeLike
jd is a tool for diff and patch of json files: https://github.com/josephburnett/jd
LikeLike
[…] P.S. There are tools like jc and jq which are great for doing terminal IO using JSON data format! And there are a lot of other tools too which help with JSON processing… […]
LikeLike