trdsql ☆

« Back to VersTracker

Description:
CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN

Type: Formula | Tracked Since: Dec 28, 2025

Links: Homepage | formulae.brew.sh

Category: Developer tools

Tags: sql cli data-processing csv json dev-tools

Install: brew install trdsql

About:
trdsql is a command-line tool that executes SQL queries on various file formats including CSV, LTSV, JSON, YAML, and TBLN. It automatically parses input files and allows users to leverage standard SQL syntax for data manipulation and analysis. This utility bridges the gap between traditional database operations and flat-file data processing without requiring database setup.

Key Features:

Supports multiple input/output formats (CSV, LTSV, JSON, YAML, TBLN)
Uses standard SQL syntax for queries
No database server required - operates directly on files
Cross-platform compatibility
Streaming capable for large files

Use Cases:

Analyzing log files in JSON or LTSV format using SQL queries
Converting data between different file formats using SQL transformations
Quick data filtering and aggregation on CSV files without spreadsheet software
ETL operations for small to medium datasets

Alternatives:

q – Similar SQL-on-files tool but with different format support focus
csvkit – CSV-specific toolkit with broader command set but limited to tabular data
duckdb – Embedded database with strong file format support but heavier footprint

Version History

Detected	Version	Rev	Change	Commit