Miller ทุกเวอร์ชันและเวอร์ชันเก่า

What's Changed

Features
• Add datediff DSL function by @johnkerl in #2221
• Support XDG Base Directory spec for location of .mlrrc by @johnkerl in #2215
• Batch-stream mlr seqgen output for head-friendliness by @johnkerl in #2230
• reshape：add -S/-n to sort new wide-field keys in long-to-wide (#1646) by @ChrisJr404 in #2235
• Support Unicode-boxed I/O format：tabular with UTF-8 markers by @johnkerl in #2253

Fixes
• Fix I/O flag clash by @johnkerl in #2254

Build, CI & tooling
• Add scoped make gosec target for security scanning by @johnkerl in #2223
• Go 1.25 -> 1.26 in .github/workflows/golangci-lint.yml by @johnkerl in #2245
• Fix CI Go versions by @johnkerl in #2246

Docs
• docs：fix dead links in README by @1t1sCooL in #2238

Dependency updates
• Bump the codeql-action group with 3 updates by @dependabot[bot] in #2234, #2237, #2239, #2251, #2252
• Bump github.com/stretchr/testify from 1.11.1 to 1.12.0 by @dependabot[bot] in #2232
• Bump github.com/stretchr/testify from 1.12.0 to 1.12.1 by @dependabot[bot] in #2236
• Bump golang.org/x/text from 0.40.0 to 0.41.0 by @dependabot[bot] in #2233
• Bump golang.org/x/text from 0.41.0 to 0.42.0 by @dependabot[bot] in #2249
• Bump github.com/klauspost/compress from 1.19.2 to 1.20.0 by @dependabot[bot] in #2243
• Bump golang.org/x/sys from 0.47.0 to 0.48.0 by @dependabot[bot] in #2244
• Bump golang.org/x/term from 0.45.0 to 0.46.0 by @dependabot[bot] in #2250
• Bump github.com/modelcontextprotocol/go-sdk from 1.7.0 to 1.8.0 by @dependabot[bot] in #2248

New Contributors

• @ChrisJr404 made their first contribution in #2235
• @1t1sCooL made their first contribution in #2238

Full Changelog：https://github.com/johnkerl/miller/compare/v6.21.0...v6.22.0

## New verbs and DSL features

`mlr rank` verb, `sparkline` DSL function and verb, `bootstrap-ci` verb for bootstrap-resampling confidence intervals
Sliding-window mode for `stats1 -w {n}`, more `step -a` back-reference options
Positional placeholders (`{1}`, etc.) in the `format` DSL function
`--right-align-numeric` for PPRINT/Markdown output
Named `.mlrrc` profile sections via `--profile`/`-P`
`mlr join --ignore-empty` to skip pairing on empty join keys
New GNU recutils (`.rec`) I/O format
YAML now follows JSON's auto-flatten/auto-unflatten behavior

## Documentation

Numerous new recipes/guides: wide-CSV transposition, updating a CSV from partial downloads, merging files with colliding column names, combining CSVs with different headers, SQL-style join examples, preprocessing join's left file, --lazy-quotes semantics, malformed-TZ troubleshooting, STAN-format JSON-array reshaping
Clarified docs for `uniq`, `join` format flags, `summary` field types, `NF` dynamism
Published an epub of the docs on https://miller.readthedocs.io/en/latest

## Bug fixes

`tee`/`split` no longer leak downstream mutations into side-output files (#1671)
Fixed float formatting (e.g. 004.56) to emit valid JSON numbers
`--ors crlf` is now honored for CSV output (#1810)
`reorder -r` groups matched fields by regex order, not record order (#1325)
Fixed dedupe-field-names clobbering values on ragged short rows (#1997)
`--skip-trivial-records` now exits 0 on trailing blank CSV/TSV lines
`join` exits nonzero if the left file can't be read (#2169)
DKVPX reader now honors `--ifs`/`--ips` instead of hardcoding comma/equals
Fixed recutils parser for empty fields with `+`-continuation
Fixed a mid-stream error-loss race causing flaky exit codes on transformer errors

## Internal/infra

Multi-phase removal of `os.Exit` calls below the entrypoint (5 phases) for cleaner exit-code handling
Guard against release tags being cut before the version-bump commit lands
Plans checked in for future work: exit-handling, recutils, r-strings, format-from-extension inference, nested/JSON-style accessors in non-DSL verbs
Routine dependency bumps (golang.org/x/*, codeql-action, go-isatty, etc.)

Full diff: https://github.com/johnkerl/miller/compare/v6.20.2...v6.21.0

What's new in 6.20.2
- Miller now treats AI agents as first-class users
- There is shell tab-completion for bash and zsh
- There is a new bytes datatype, along with base64 encode/decode support
(Note: versions 6.20.0 and 6.20.1 were in error and are not released.)
Miller and AI
Miller now treats AI agents as first-class users. Everything an agent needs to drive Miller well --
discovering what exists, learning your data's shape, validating expressions before running them, and
recovering from errors -- is now a built-in, structured feature of the mlr binary, packaged for
MCP-speaking agents (Claude Code, Claude Desktop, Cursor, ...) via a one-line setup. Your choice of
# Claude
mlr skill install ~/.claude/skills/miller
# Codex and Gemini
mlr skill install ~/.agents/skills/miller
or
# Claude
claude mcp add miller -- mlr mcp
# Codex
codex mcp add miller -- mlr mcp
# Gemini
gemini mcp add miller mlr mcp
See the new Miller and AI docs page for the quick start.
Reference pages:
- https://miller.readthedocs.io/en/latest/ai
- https://miller.readthedocs.io/en/latest/agent-skill
- https://miller.readthedocs.io/en/latest/mcp-server
- https://miller.readthedocs.io/en/latest/ai-support
PRs:
- Machine-readable help catalog, mlr help --as-json: by @johnkerl in #2099, #2106
- JSON capability index and mlr which intent router by @johnkerl in #2107
- Structured verb options, with enum value-sets by @johnkerl in #2111
- Structured error output, --errors-json, with hints and did-you-mean suggestions by @johnkerl in #2113
- DSL validate/dry-run, mlr put --explain / mlr filter --explain by @johnkerl in #2131
- New mlr describe verb: field names, types, cardinality, and value domains of your data in one pass by @johnkerl in #2132
- New mlr mcp MCP server and agent playbook, with a --no-shell sandbox flag by @johnkerl in #2133
- Roadmap doc by @johnkerl in #2103; "Miller and AI" docs page by @johnkerl in #2134
Shell tab-completion for bash and zsh
Documentation:
https://miller.readthedocs.io/en/latest/shell-completion/
PR:
- Shell tab-completion for bash and zsh by @johnkerl in #2096
A first-class bytes type in the DSL
Docs:
- https://miller.readthedocs.io/en/latest/reference-main-data-types/
- https://miller.readthedocs.io/en/latest/reference-dsl-builtin-functions/#base64_encode
- https://miller.readthedocs.io/en/latest/reference-dsl-builtin-functions/#base64_decode
PR:
- New bytes type with b"..." literals and base64/hex codecs by @johnkerl in #2122
More features
- New tail -n +N and head -n -N options by @farnoy in #2071
- Long-overdue --md flag by @johnkerl in #2100
- Windows-arm64 releases by @teo-tsirpanis in #2127
Bug fixes
- Fix masked unset-on-array error path (along with govet lint findings) by @johnkerl in #2129
Documentation
- CSV and JSON troubleshooting tips by @dashitongzhi in #2123, with page-refactor by @johnkerl in #2128
- Document time-conversion thread safety by @dashitongzhi in #2115
- PNG graphics in perf docs for issue-2084 perf mods by @johnkerl in #2095
Internals
- golangci-lint CI workflow by @dashitongzhi in #2076
- Lint fixes bringing staticcheck and errcheck to zero by @johnkerl in #2108, #2110, #2112, #2130
- Strip dead code from pkg/ by @johnkerl in #2121
- CI/actions updates by @johnkerl in #2119 and by @dependabot in #2101, #2102, #2104, #2105, #2114, #2116, #2118, #2124, #2125, #2126
- Dependency bumps by @dependabot in #2117, #2120
New Contributors
- @farnoy made their first contribution in #2071
- @dashitongzhi made their first contribution in #2076
- @teo-tsirpanis made their first contribution in #2127
Full Changelog: v6.19.0...v6.20.0

New features
- Add a stat DSL function by @johnkerl in #1560
- Add mad accumulator for stats1 DSL function by @johnkerl in #1561
- Support $NO_COLOR by @johnkerl in #1580
Bug fixes
- Fraction bugfix by @oandrew in #1579
- Fix local time when TZ is not set by @balki in #1649
- Bash process substitution not working with put -f by @johnkerl in #1583
- Be smarter about auto-unflatten by @johnkerl in #1584
- RS aliases for ASCII top-of-table control characters are misnamed by @johnkerl in #1620
- Fix binary data in JSON output by @johnkerl in #1626
- Fix prepipe handling when filenames have whitespace by @johnkerl in #1627
- Error in splita/splitax when field contains a single non-string value by @johnkerl in #1629
Documentation updates
- Update reference-verbs.md by @aborruso in #1665
- Characters to be removed by @aborruso in #1668
- Fix minor typo by @austinletson in #1673
- Enable admonition extension by @aborruso in #1636
- To realize which chapter and section are active by @aborruso in #1631
- To have edit and copy code in each page by @aborruso in #1632
- Update extra.css by @aborruso in #1633
- A note about positional field names by @aborruso in #1634
- Fix typo in online help for --no-jlistwrap by @johnkerl in #1541
- Try to build readthedocs .epub and .pdf by @johnkerl in #1548
- On-line help for mlr summary --transpose by @johnkerl in #1581
- Note IANA TSV support by @johnkerl in #1582
- Source-file update for PR 1634 by @johnkerl in #1635
- Update source material for #1665 by @johnkerl in #1666
- Fix 1668 error-source by @johnkerl in #1672
Minor changes
- The package version must match the major tag version by @lespea in #1654
- Use string version of regexp methods to reduce allocs by @Juneezee in #1614
- Chore: fix function name in comment by @camcui in #1543
- Fix mismatched method names in comments by @forcedebug in #1549
- Compiling on newer go versions doesn't work by @lespea in #1655
- Misc. codespell findings by @johnkerl in #1628
New Contributors
- @camcui made their first contribution in #1543
- @forcedebug made their first contribution in #1549
- @oandrew made their first contribution in #1579
- @balki made their first contribution in #1649
- @lespea made their first contribution in #1654
- @austinletson made their first contribution in #1673
Dependency updates
- Bump actions/cache from 4.0.1 to 4.0.2 by @dependabot in #1532
- Bump golang.org/x/term from 0.18.0 to 0.19.0 by @dependabot in #1536
- Bump github.com/klauspost/compress from 1.17.7 to 1.17.8 by @dependabot in #1538
- Bump actions/upload-artifact from 4.3.1 to 4.3.2 by @dependabot in #1547
- Bump actions/checkout from 4.1.2 to 4.1.3 by @dependabot in #1550
- Bump actions/upload-artifact from 4.3.2 to 4.3.3 by @dependabot in #1551
- Bump actions/checkout from 4.1.3 to 4.1.4 by @dependabot in #1552
- Bump actions/setup-go from 5.0.0 to 5.0.1 by @dependabot in #1553
- Bump golang.org/x/sys from 0.19.0 to 0.20.0 by @dependabot in #1554
- Bump golang.org/x/text from 0.14.0 to 0.15.0 by @dependabot in #1556
- Bump golang.org/x/term from 0.19.0 to 0.20.0 by @dependabot in #1555
- Bump actions/checkout from 4.1.4 to 4.1.5 by @dependabot in #1557
- Bump goreleaser/goreleaser-action from 5.0.0 to 5.1.0 by @dependabot in #1563
- Bump actions/checkout from 4.1.5 to 4.1.6 by @dependabot in #1566
- Bump github/codeql-action from 2.13.4 to 3.25.5 by @dependabot in #1567
- Bump github/codeql-action from 3.25.5 to 3.25.6 by @dependabot in #1568
- Bump github/codeql-action from 3.25.6 to 3.25.7 by @dependabot in #1570
- Bump goreleaser/goreleaser-action from 5.1.0 to 6.0.0 by @dependabot in #1574
- Bump github/codeql-action from 3.25.7 to 3.25.8 by @dependabot in #1575
- Bump golang.org/x/text from 0.15.0 to 0.16.0 by @dependabot in #1576
- Bump golang.org/x/sys from 0.20.0 to 0.21.0 by @dependabot in #1578
- Bump golang.org/x/term from 0.20.0 to 0.21.0 by @dependabot in #1577
- Bump github.com/klauspost/compress from 1.17.8 to 1.17.9 by @dependabot in #1585
- Bump ac

- Add DSL functions for integer nanoseconds since the epoch by @johnkerl in #1326
- Add %N and %O for strfntime by @johnkerl in #1334
- Add %s format specifier for strftime by @johnkerl in #1335
- Requested on issue #1152 by @derekmahar
- See also https://miller.readthedocs.io/en/6.9.0/reference-dsl-builtin-functions/index.html#time-functions
- New DSL functions for summary stats over arrays / maps by @johnkerl in #1364
- Requested on issue #1345 by @janxkoci
- See also https://miller.readthedocs.io/en/6.9.0/reference-dsl-builtin-functions/index.html#stats-functions
- Filename options for split by @sloanlance in #1366
- Requested on issue #1365 by @sloanlance
- Fatal-on-data-error mlr -x option by @johnkerl in #1373
- See also https://miller.readthedocs.io/en/6.9.0/reference-dsl-errors/#handling-for-data-errors
- Requested on issue #1106 by @honzajde
- New sub, gsub, and ssub verbs by @johnkerl in #1361, requested by @janxkoci on #1356.
See also:
- https://miller.readthedocs.io/en/6.9.0/reference-verbs/#sub
- https://miller.readthedocs.io/en/6.9.0/reference-verbs/#gsub
- https://miller.readthedocs.io/en/6.9.0/reference-verbs/#ssub
- New contains DSL function by @johnkerl in #1374
- https://miller.readthedocs.io/en/6.9.0/reference-dsl-builtin-functions/index.html#contains
- Support ZSTD compression in-process by @johnkerl in #1360, from issue #1342 by @aborruso
- See also https://miller.readthedocs.io/en/6.9.0/reference-main-compressed-data/
- Support comments in mlr -s files by @johnkerl in #1359, from issue #1343 by @janxkoci
- Add empty-key check to mlr check by @johnkerl in #1330, from issue #1050 by @aborruso
Bug fixes
- Do wildcard globbing on Windows by @johnkerl in #1362, from issue #1341 by @coolbq
- Treat empty like absent in + - * by @johnkerl in #1371, from issue #1001 by @Poshi
- Can't use ${field_name} if it contains UTF-8 characters also encodeable as Latin-1 by @johnkerl in #1363, from issue #1358 by @clemente
- Typofix in uif/uof percentiles by @johnkerl in #1375
Documentation updates
- Update readthedocs notes in the how-to-release page by @johnkerl in #1308
- Fix mlr grep docs re OFS/OPS by @johnkerl in #1309
- Update Fedora link by @bkmgit in #1339
- Small typos in documentation of mlr nest by @johnkerl in #1352, from issue #1350 by @kusalananda
Internal
- Update 2015-era Python sketch to Python 3 by @johnkerl in #1372
- Remove redundant nil check by @Juneezee in #1367
- Bump actions/checkout from 3.5.2 to 3.5.3 by @dependabot in #1319
- Bump github/codeql-action from 2.3.6 to 2.13.4 by @dependabot in #1318
- Bump golang.org/x/term from 0.8.0 to 0.9.0 by @dependabot in #1321
- Bump goreleaser/goreleaser-action from 4.2.0 to 4.3.0 by @dependabot in #1320
- Bump golang.org/x/text from 0.9.0 to 0.10.0 by @dependabot in #1322
- Bump golang.org/x/text from 0.10.0 to 0.11.0 by @dependabot in #1337
- Bump golang.org/x/sys from 0.9.0 to 0.10.0 by @dependabot in #1336
- Bump golang.org/x/term from 0.9.0 to 0.10.0 by @dependabot in #1338
- Bump golang.org/x/sys from 0.10.0 to 0.11.0 by @dependabot in #1347
- Bump golang.org/x/text from 0.11.0 to 0.12.0 by @dependabot in #1349
- Bump actions/setup-go from 4.0.1 to 4.1.0 by @dependabot in #1351
- Bump goreleaser/goreleaser-action from 4.3.0 to 4.4.0 by @dependabot in #1354
- Bump golang.org/x/term from 0.10.0 to 0.11.0 by @dependabot in #1348
- Bump actions/checkout from 3.5.3 to 3.6.0 by @dependabot in #1369
New Contributors
- @bkmgit made their first contribution in #1339
- @Juneezee made their first contribution in #1367
- @sloanlance made their first contribution in #1366