pickfit

BrowseDeveloper CLIs

Miller

Command-line tool for processing name-indexed CSV, TSV, and JSON data.

Tested on Linux

Use it

Linux x86_64

  1. download and install Miller binary to ~/.local/bin

    mkdir -p ~/.local/bin && curl -L https://github.com/johnkerl/miller/releases/download/v6.22.0/miller-6.22.0-linux-amd64.tar.gz -o /tmp/miller.tar.gz && tar -xzf /tmp/miller.tar.gz -C /tmp && cp /tmp/miller-6.22.0-linux-amd64/mlr ~/.local/bin/mlr && chmod +x ~/.local/bin/mlr && ~/.local/bin/mlr --version

Check that it works

mlr --version

The output should contain “mlr 6.22.0”.

First thing to try

cat > /tmp/input.csv <<'EOF'
name,age,salary
alice,30,1000
bob,25,2000
carol,35,1500
EOF
cat /tmp/input.csv
cat > /tmp/input.json <<'EOF'
{"name": "alice", "age": 30}
{"name": "bob", "age": 25}
EOF
cat /tmp/input.json
cat > /tmp/input2.csv <<'EOF'
a,b,c
1,2,3
4,5,6
7,8,9
EOF
cat /tmp/input2.csv
mlr --csv put '$double_salary = $salary * 2' /tmp/input.csv

What it does

  • Add and transform fields with functions
    Tested
  • Convert between CSV TSV JSON formats
    Tested
  • Process CSV TSV JSON data
    Tested
  • Slice dice reformat data for databases
    Tested

How far pickfit got

Linux x86_64

  1. Installs
  2. Starts
  3. 4 of 4 features work
  4. Works offline

macOS and Windows: the project says it runs there; pickfit hasn’t tried it.

Good for

An alternative to awk, sed, cut, join and sort.

How pickfit tested it

Each run starts from a clean machine and follows the steps above. How pickfit verifies

Linux x86_64

Its main function works

  • Replayed from scratch
  • Works offline
  • Checked on 4 Nov 2026
  • Version 6.22.0

Differences the test machine hit

  • README: apt-get install miller / yum install miller
    In the test: no root in sandbox; downloaded linux-amd64 tarball from GitHub releases and installed to ~/.local/bin

How to read a tool card

Stitching
pickfit installed this tool itself. Everything under the stitches comes from that run. A tool pickfit has not run never gets stitches.
Verified on your OS
The install steps ran on the system you chose. “Ran on Linux only” means it has not been run on yours yet.
macOS, Linux and WindowsWhere it ran
Green OS marks: pickfit ran the install steps there. Grey ones: the README says it runs there, and pickfit has not tried.
How far the run got
Installs and starts, its main function works, its service answers, it produces model output. A window means a desktop app opened; a plug, an MCP client used it. The mark sits beside the run’s result, under “Why it fits and how we know” and in “How pickfit tested it”.
Visual check
pickfit looked at screenshots of the app. Green: it looks right. Amber with a number: things that look wrong; open it to see them. Grey and dashed: not checked yet.
Known vulnerabilities
Known high or critical vulnerabilities (OSV.dev) in what it installs. Green: none known. Red with a number: how many; open it for the list, and read it before you install. Grey and dashed: not checked, which does not mean safe.
About the run
The day it ran, and the version that ran.
Source of a reason
Every reason a pick fits rests on one profile field. Open the reason to see the field and the value it relies on.
Hidden gem
High quality, little known.
Quality and popularity
Two scores out of 100. Quality: how well it installed and worked when pickfit tried it, and how good its install docs and upkeep are. Popularity: from stars, downloads and Hacker News.
Features checked
Of the main features the README advertises, how many the run actually exercised (green), and how many failed (red). Grey ones were not checked, and the card says why.
Not verified
A well-known tool Fitz mentions from general knowledge. No run record, no steps, no score.