csvq ☆

« Back to VersTracker

Description:
SQL-like query language for csv

Type: Formula | Latest Version: 1.18.1@0 | Tracked Since: Dec 17, 2025

Links: Homepage | formulae.brew.sh

Category: Developer tools

Tags: csv sql data-analysis cli query-language etl

Install: brew install csvq

About:
csvq is a command-line tool that allows users to execute SQL-like queries on CSV files without requiring a database engine. It provides a familiar SQL syntax for filtering, joining, aggregating, and transforming data directly from the terminal. This tool streamlines data analysis and manipulation tasks, making it ideal for quick data exploration and reporting.

Key Features:

Full SQL-92 support including JOINs, subqueries, and window functions
Direct querying of CSV, TSV, and JSON files without database setup
Built-in functions for data type conversion and string manipulation
Support for writing query results back to CSV or JSON files
Cross-platform availability (macOS, Linux, Windows)

Use Cases:

Quickly filtering and analyzing log files or exported application data
Joining multiple CSV exports from different sources for consolidated reporting
Transforming data formats and structures for ETL pipelines without database overhead

Alternatives:

q – Similar SQL-on-CSV functionality, but csvq supports more advanced SQL features like window functions
sqlite3 – More powerful but requires importing CSVs into a database first, adding setup overhead
Miller (mlr) – Excellent for data transformation, but uses its own DSL rather than standard SQL syntax

License: MIT

Bottles available for: arm64_tahoe, arm64_sequoia, arm64_sonoma, arm64_ventura, arm64_monterey, arm64_big_sur, sonoma, ventura, monterey, big_sur, arm64_linux, x86_64_linux

Version History

Detected	Version	Rev	Change	Commit
Oct 10, 2025 12:02pm		0	VERSION_BUMP	ead6c8e8