Life & fun · alternatives · 2026

24 alternatives to I built jq-like scriptable tool to query CSV and JSON with SQLite

Convert and query JSON, JSONL, CSV, and SQLite with ease! - chand1012/sq

This tool lets users query CSV and JSON files using SQLite, offering a jq-like scripting experience. It's designed for developers and data analysts who need flexible, scriptable access to structured data without… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. I built jq-like scriptable tool to query CSV and JSON with SQLite launched in 2024; newer entries below may have overtaken it.

1
TextQuery – Query CSV, JSON, XLSX Files with SQL▲163
Hiya HN! TextQuery is my sabbatical project that I have been working on for the past six months. It was born out of a personal pain point. Anytime I wanted to analyze raw CSV data, I had to create a schema first before I could import it for querying. And to create charts, I had to use yet another tool. I also disliked how bad charts from popular tools like Excel, Google Sheets looked like. I wanted an easier way to do this and TextQuery was my solution: an all-in-one tool to query CSV files using SQL and create beautiful visualizations as well. Currently, it's a macOS app and focused on CSV…
2025 · textquery.app · its alternatives →
2
Querying JSON documents using SQL-like language in Scala▲70
SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql
2020 · github.com · its alternatives →
3
JSON Query▲154
I'm working on a tool that will probably involve querying JSON documents and I'm asking myself how to expose that functionality to my users. I like the power of `jq` and the fact that LLMs are proficient at it, but I find it right out impossible to come up with the right `jq` incantations myself. Has anyone here been in a similar situation? Which tool / language did you end up exposing to your users?
Oct 2025 · jsonquerylang.org · its alternatives →
4
jql – Easier jq Alternative with a Lispy Syntax Written in Go▲217
Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql
2020 · github.com · its alternatives →
5
Sqlify▲191
JSON, CSV and SQL converter
2017 · its alternatives →
6
Jqview, a simple native GUI for inspecting JSON with jq▲208
simplest possible native GUI for inspecting JSON objects with jq - fiatjaf/jqview
2020 · github.com · its alternatives →
7
SQLite Plugin for Jekyll▲227
I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination. However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s). It gives you the simplicity of the Baked Data pattern[2], and the…
2024 · github.com · its alternatives →
8SQ
SQLite query inside a Bash function▲134
Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…
2021 · its alternatives →
9
jnv: interactive JSON filter using jq▲373
Interactive JSON filter using jq. Contribute to ynqa/jnv development by creating an account on GitHub.
2024 · github.com · its alternatives →
10
JSON For You – Visualize JSON in graph or table views▲211
After two years of improvement, I think it's time to share it with you all. Here’s a quick overview: - Common features include validation, formatting, minification, and more. - Visualize JSON in a graph or table view. - Structured comparison with fallback to text comparison. - Navigate though JSON using JSON pointer. - Supports jq. Would love to hear the community's questions, thoughts and comments!
2024 · github.com · its alternatives →
11
FSQL – Search through your file system with SQL-esque queries▲341
Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.
2017 · github.com · its alternatives →
12DP
Datasette Publish – Turn CSVs into a SQLite-Backed JSON API▲101
2018 · publish.datasettes.com · its alternatives →
13
TABLUM.IO▲159
Turn CSV, XML & JSON into a live analysis-ready SQL database
2023 · tablum.io · its alternatives →
14
cq – Query CSVs using SQL▲80
Query CSVs using SQL. Contribute to jolmg/cq development by creating an account on GitHub.
2019 · github.com · its alternatives →
15
gq – like jq or zq, but you use Go▲107
Hi HN. I've gotten pretty tired of needing to learn a custom programming language for a tool I use once a week or less. So I figured, it might be easier to pick up if `jq` used a programming language I already know. Voila, gq.
2022 · github.com · its alternatives →
16
Private, in-browser, CSV-SQL query runner using SQLite-WASM▲41
Upload CSV, and start querying, all locally without any data leaving your browser. Can handle large CSV's easily. Download query results once done. Uses sqlite-wasm binary.
2024 · csvsqltool.com · its alternatives →
17
SQL Workbench▲186
In-browser SQL Workbench for data querying & visualization
2024 · sql-workbench.com · its alternatives →
18DU
Duck-UI – Browser-Based SQL IDE for DuckDB▲213
I built Duck-UI, a web-based SQL editor that runs DuckDB entirely in your browser via WebAssembly. No backend required. The Problem: Every time I needed to query csv, parquet, or even to play with SQL, I had to either: (a) spin up a Jupyter notebook (b) use the CLI (c) upload to a hosted service. Friction at every step (TOO MUCH to load a csv or even to test some sql (study)... The Solution: DuckDB's WASM runtime lets us run SQL analysis client-side. Load CSV/JSON/Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…
2025 · demo.duckui.com · its alternatives →
19
SQL workbench in the browser▲117
Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.
2024 · sql-workbench.com · its alternatives →
20
SQLite JavaScript - extend your database with JavaScript▲199
Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript. - sqliteai/sqlite-js
2025 · github.com · its alternatives →
21
Anyquery▲110
Query anything with SQL (e.g. Notion, GitHub, JSON)
2024 · anyquery.dev · its alternatives →
22
JQL – A JSON Query Language CLI Tool Built with Rust▲25
crates.io serves as a central registry for sharing crates, which are packages or libraries written in Rust that you can use to enhance your projects
2020 · crates.io · its alternatives →
23ZA
ZenQuery – Analyze CSV/JSON files using natural language for cents▲16
2025 · zenquery.app · its alternatives →
24
An Interactive Jq Tutorial▲15
Interactive jq tutorial: learn to filter and wrangle JSON files using a command-line interface in your browser.
2021 · sandbox.bio · its alternatives →

Also compare

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →