Same CLI job with broader format support (JSON, Parquet, Excel) and active development.
executes SQL against CSV, TSV, LTSV, JSON, JSONL, Parquet, Microsoft Excel™ , ACH, and Fedwire files with shell.
- 178
- Go
- MIT
CSV/TSV SQL querying
A Go command-line tool for running SQL queries directly against CSV/TSV and other structured text files.
Same problem, same approach. Swapping one for another is a config change, not a rewrite.
Same CLI job with broader format support (JSON, Parquet, Excel) and active development.
executes SQL against CSV, TSV, LTSV, JSON, JSONL, Parquet, Microsoft Excel™ , ACH, and Fedwire files with shell.
Same CLI job with multi-format input/output and a mature Go implementation.
CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
Same CLI job with a broader data-wrangling focus, including database support.
sq data wrangler
Solves the same problem with a different architecture or at a different layer. Expect to rewrite the integration.
Interactive TUI for SQL queries on JSON/CSV; choose when you want a terminal UI instead of a one-shot CLI.
qo is an interactive minimalist TUI to query JSON and CSV using SQL.
An earlier or more limited way to do the job. Still the right call when you need something small, proven, or CPU-only.
Tcl-based awk-like SQL tool; useful if you need a lightweight Tcl dependency but it is unmaintained.
Like awk, but with SQL and table joins
Older static Go binary for SQL over many formats; useful if you need those formats but accept a dormant project.
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
Does the same job, but ships as an app. Useful to a person, not swappable into a codebase.
Sublime Text editor package for column highlighting and SQL-like queries, not a CLI you can swap in.
Rainbow CSV - Sublime Text Package: Highlight columns in CSV and TSV files and run queeries in SQL-like language
Desktop GUI app to query local files with SQL; choose when a graphical interface is preferred.
EasyDB is a lightweight desktop app built with Tauri + Rust, powered by Apache DataFusion. Query local CSV, TSV, Text, NdJson, Excel, Parquet files and MySQL databases directly with SQL — no external database required. Handles datasets from hundreds of MB to several GB with ease. 让所有数据说同一种“语言”
Vim plugin for CSV/TSV highlighting and SQL-like queries; choose for in-editor workflows.
Rainbow CSV - Vim plugin: Highlight columns in CSV and TSV files and run queries in SQL-like language
These projects were analysed and named textql among their alternatives. The relationship is not symmetric — how textql rates them is a separate judgement, made when textql is analysed in its own right.
calls textql “Direct SQL-on-CSV/TSV tool but stale; use if you accept an unmaintained Go binary.”
q - Run SQL directly on delimited files and multi-file sqlite databases
calls textql “The older Go SQL-over-CSV tool that inspired this class; pick it only for legacy pipelines, since it has been unpushed for ~3 years.”
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.