An Introduction to JQ

This page summarizes the projects mentioned and recommended in the original post on /r/programming

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • yq

    yq is a portable command-line YAML, JSON, XML, CSV, TOML and properties processor

    there is https://github.com/mikefarah/yq which is jq for yaml

  • jello

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

    And if you don't like jq syntax, here's how you can use JSON in Bash using jello, a tool I wrote that works very similarly to jq but uses pure Python syntax:

  • InfluxDB

    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.

  • dasel

    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.

    yq is great and so is dasel. Dasel is nice because it works uniformly across input types.

  • miller

    Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

    Another tool I've been meaning to get better at is mlr, which is a format-agnostic data viewing/manipulation cli tool. I hadn't heard of dasel before today. Had you heard of mlr, and if so, how would you compare dasel and mlr? While I would love to LEARNALLTHETOOLS, my brain doesn't have room for that many.

  • csvq

    SQL-like query language for csv

    I just found https://github.com/mithrandie/csvq which is SQL for CSV files, which I thought was pretty cool.

  • jq

    Discontinued Command-line JSON processor [Moved to: https://github.com/jqlang/jq] (by stedolan)

  • jmespath.py

    JMESPath is a query language for JSON.

    https://jmespath.org/ (used by the AWS CLI tools)

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • structured-text-tools

    A list of command-line tools for manipulating structured text data

    Thanks again for the jq writeup and for the dasel pointer. I'll be adding dasel to my mental shortlist of tools to learn. Which is not such a short list....

  • awesome-cli-apps

    🖥 📊 🕹 🛠 A curated list of command line apps

  • yq

    Command-line YAML, XML, TOML processor - jq wrapper for YAML/XML/TOML documents (by kislyuk)

  • xsv

    A fast CSV command line toolkit written in Rust.

    I found this last week for CSV https://github.com/BurntSushi/xsv of course *after* spending several hours manipulating them by hand

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts