Miller
Like awk, sed, cut, and sort for name-indexed data such as CSV, TSV, and JSON
Visit miller.readthedocs.io FreeOpen source
Miller (mlr) processes CSV, TSV, JSON, and other record-oriented formats using named fields. It provides verbs for sorting, joining, aggregating, and reshaping data, plus a DSL for custom transformations.
Key features
- Works with CSV, TSV, JSON, and more
- Verbs for sort, join, stats, and reshape
- Format conversion between inputs and outputs
- Streaming for large files
Try it on DevTools Daily
Similar tools
VisiData
Terminal spreadsheet multitool for exploring and arranging tabular data
jq
Lightweight command-line JSON processor, like sed for JSON data
yq
Portable command-line YAML, JSON, XML, and TOML processor with jq-like syntax
Datasette
Explore and publish SQLite data as an interactive website and JSON API
DuckDB
In-process analytical SQL database for fast queries over local and remote files
ClickHouse
Open-source column-oriented database for real-time analytics
