Go CLI doing SQL over files and databases with active maintenance, larger source-type coverage and a query registry; pick it if you want a maintained drop-in peer.
sq data wrangler
- 2.6k
- Go
- MIT
CLI SQL querying of local data files
A command-line tool that loads JSON, CSV, Excel, Parquet and similar files into an in-memory SQLite database so you can run SQL queries over them.
Same problem, same approach. Swapping one for another is a config change, not a rewrite.
Go CLI doing SQL over files and databases with active maintenance, larger source-type coverage and a query registry; pick it if you want a maintained drop-in peer.
sq data wrangler
Python implementation of the same SQL-over-delimited-files idea, preferable when you want a Python stack or GPL-3.0 terms and don't mind slower startup on big files.
q - Run SQL directly on delimited files and multi-file sqlite databases
Actively maintained Go CLI with SQL over CSV/LTSV/JSON/YAML and multi-format output; choose it when you need output writers or Postgres/driver passthrough.
CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
The replacement the seed itself recommends: a single-binary SQL CLI that queries CSV/JSON/Parquet directly with vectorized columnar execution and far better performance.
DuckDB is an analytical in-process SQL database management system
Solves the same problem with a different architecture or at a different layer. Expect to rewrite the integration.
Choose it when you want a Rust CSV/JSON toolkit with a non-SQL expression language and many subcommands instead of an ANSI SQL engine.
The CSV magician
SQLite-based engine that extends the same query-a-file model to 60+ SaaS/API sources and MCP; choose it when SQL over live services matters more than raw file throughput.
One SQL interface for 60+ tools (e.g., GitHub, Notion, Airtable). Plug into any LLM through MCP.
Serves SQL/REST/GraphQL over columnar files as a long-running HTTP service; choose it when you need an API rather than a one-shot shell command.
Create full-fledged APIs for slowly moving datasets without writing a single line of code.
Distributed MPP SQL engine over JSON/Parquet/CSV; pick it for cluster-scale queries across large self-describing datasets instead of single-machine SQLite.
Apache Drill is a distributed MPP query layer for self describing data
An earlier or more limited way to do the job. Still the right call when you need something small, proven, or CPU-only.
Same SQL-over-CSV CLI, but unmaintained for 2+ years so no fixes; pick it only for its richer SQL dialect if you accept stale code.
SQL-like query language for csv
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.
Execute SQL against structured text like CSV or TSV
Narrower TSV-only toolkit for filtering, join and stats via fixed subcommands; use it for streaming huge TSVs without SQL, but it has been unpushed ~4 years.
eBay's TSV Utilities: Command line tools for large, tabular data files. Filtering, statistics, sampling, joins and more.
Does the same job, but ships as an app. Useful to a person, not swappable into a codebase.
Rust TUI application for interactively browsing and querying CSV/Parquet — usable by an end user, not scriptable into a codebase.
A lightweight TUI application to view and query tabular data files, such as CSV, TSV, and parquet.
A Windows desktop GUI for browsing and SQL-filtering Parquet files, Parquet-only and not scriptable from a shell.
Simple Windows desktop application for viewing & querying Apache Parquet files
Terminal spreadsheet application for interactive data exploration, not a headless query tool you can script.
A terminal spreadsheet multitool for discovering and arranging data
These projects were analysed and named dsq among their alternatives. The relationship is not symmetric — how dsq rates them is a separate judgement, made when dsq is analysed in its own right.
calls dsq “Direct SQL-on-file tool with broader format support but stale; use if you accept an unmaintained Go utility.”
q - Run SQL directly on delimited files and multi-file sqlite databases
calls dsq “Older static Go binary for SQL over many formats; useful if you need those formats but accept a dormant project.”
Execute SQL against structured text like CSV or TSV