zsv
« Back to VersTracker
Description:
Tabular data swiss-army knife CLI
Type: Formula  |  Latest Version: 1.3.0@0  |  Tracked Since: Nov 25, 2025
Links: Homepage  |  formulae.brew.sh
Category: Developer tools
Tags: csv data-processing cli etl sql
Install: brew install zsv
About:
zsv is a high-performance command-line tool for processing tabular data (CSV, TSV, etc.) that uses a streaming, memory-efficient approach. It provides a familiar SQL-like interface for querying, filtering, and transforming large datasets without loading them entirely into memory. Its primary value is speed and efficiency on large files, outperforming many traditional text processing tools.
Key Features:
  • SQL-like query syntax (SELECT, WHERE, JOIN, GROUP BY)
  • High performance with low memory footprint
  • Streaming processing for large files
  • Supports CSV, TSV, and other delimited formats
  • Extensible with custom plugins
Use Cases:
  • Analyzing large log files or CSV exports on the command line
  • Performing ETL (Extract, Transform, Load) operations on tabular data
  • Joining and aggregating data from multiple files without scripting
Alternatives:
  • csvkit – Python-based, easier to install but slower and more memory-intensive for large files
  • q – Uses SQLite under the hood, similar SQL interface but zsv is written in C for better performance
  • awk/sed – Standard Unix tools, more flexible for text but require more complex syntax for structured data operations
Version History
Detected Version Rev Change Commit
Nov 25, 2025 2:56am 0 VERSION_BUMP 533165bb
Nov 7, 2025 1:57pm 0 VERSION_BUMP 1949d974
Oct 19, 2025 1:13pm 0 VERSION_BUMP 2af66bc5