Ask HN: Local Tools for Viewing JSON

• fx

  50 18,531 9.1 Go

  Terminal JSON viewer & processor

• dasel

  44 4,879 8.1 Go

  Select, put and delete data from JSON, TOML, YAML, XML and CSV files with a single tool. Supports conversion between formats and can be used as a Go package.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• dsq

  20 3,638 4.3 Go

  Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.

  

• gron

  64 13,550 0.0 Go

  Make JSON greppable!

• jello

  31 461 5.8 Python

  CLI tool to filter JSON and JSON Lines data with Python syntax. (Similar to jq)

• jless

  34 4,517 6.3 Rust

  jless is a command-line JSON viewer designed for reading, exploring, and searching through JSON data.

• jid

  15 6,803 2.2 Go

  json incremental digger

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• jql

  11 1,424 8.0 Rust

  A JSON Query Language CLI tool

• qp

  1 130 10.0 JavaScript

  query-pipe: command-line (ND)JSON querying

• visidata

  37 7,432 9.8 Python

  A terminal spreadsheet multitool for discovering and arranging data

I would add VisiData to that list. It is more suited for tabular data, but it can be used to explore large nested data. I find it is a good starting place to explore json data I'm not familiar with. I will also sometimes flatten the data with some general jq scripts or gron.

If I'm trying to understand some new json data, I start with visidata, and then I poke around to find the data I want. If it is data I want to extract again, I use jq to get the interesting bits. Sometimes I use that in combination with sqlite-utils to store that data so I can query it. (I haven't tried some of the other tools that will create a sqlite database for you.)

- https://github.com/saulpw/visidata

• sqlite-utils

  35 1,528 8.1 Python

  Python CLI utility and library for manipulating SQLite databases

Suggest a related project