jq
Lightweight command-line JSON processor, like sed for JSON data
Visit jqlang.org FreeOpen source
jq is a fast command-line processor for JSON. Its filter language lets you slice, filter, map, and transform structured data, making it the standard tool for working with JSON in shell scripts and pipelines.
Key features
- Concise filter language for JSON
- Streams large inputs
- Single dependency-free binary
- Widely available in package managers
Try it on DevTools Daily
Similar tools

yq
Portable command-line YAML, JSON, XML, and TOML processor with jq-like syntax

Miller
Like awk, sed, cut, and sort for name-indexed data such as CSV, TSV, and JSON

VisiData
Terminal spreadsheet multitool for exploring and arranging tabular data

Datasette
Explore and publish SQLite data as an interactive website and JSON API
ClickHouse
Open-source column-oriented database for real-time analytics

DBeaver
Universal database client for SQL and NoSQL databases