AltHub

multiprocessio/dsq Alternatives

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.

3.9kGoNOASSERTIONdormant · last push 3.0y agoGitHub

Drop-in peers

Same problem, same approach. Swapping one for another is a config change, not a rewrite.

neilotoole/sqGitHub

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
active17d ago
harelba/qGitHub

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

10.4k
Python
GPL-3.0
slowing8mo ago
noborus/trdsqlGitHub

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.

2.2k
Go
MIT
active1mo ago
duckdb/duckdbGitHub

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

40.8k
C++
MIT
active1mo ago

Same job, different approach

Solves the same problem with a different architecture or at a different layer. Expect to rewrite the integration.

medialab/xanGitHub

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

4.5k
Rust
Unlicense
active19d ago
julien040/anyqueryGitHub

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.

1.8k
Go
NOASSERTION
active2mo ago
roapi/roapiGitHub

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.

3.4k
Rust
Apache-2.0
active7mo ago
apache/drillGitHub

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

2.0k
Java
Apache-2.0
active21d ago

Older generation, or narrower

An earlier or more limited way to do the job. Still the right call when you need something small, proven, or CPU-only.

mithrandie/csvqGitHub

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

1.6k
Go
MIT
dormant2.2y ago
dinedal/textqlGitHub

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

9.1k
Go
MIT
dormant3.0y ago
eBay/tsv-utilsGitHub

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.

1.5k
D
BSL-1.0
dormant4.1y ago

End-user tools

Does the same job, but ships as an app. Useful to a person, not swappable into a codebase.

shshemi/tabiewGitHub

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.

3.1k
Rust
MIT
active17d ago
mukunku/ParquetViewerGitHub

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

1.2k
C#
GPL-3.0
active24d ago
saulpw/visidataGitHub

Terminal spreadsheet application for interactive data exploration, not a headless query tool you can script.

A terminal spreadsheet multitool for discovering and arranging data

9.3k
Python
GPL-3.0
active2mo ago

Listed as an alternative to

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.

harelba/qGitHub

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

10.4kPythonslowing
dinedal/textqlGitHub

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

9.1kGodormant