Dev tools · alternatives · 2026

24 alternatives to Jlq – A CLI to easily tail+query JSON log files using Rust+SQLite

Hi all! It's been a while since I posted something. Wrote this back in November to scratch an itch regarding tailing logs locally for multiple services. I know we all love jq...but I'm quite comfortable with SQLite and SQL so just wanted to use that instead. Published my first Rust crate today! My first public Rust project so be gentle :) . Hope you enjoy it! https://crates.io/crates/jlq https://github.com/hamin/jlq

Jlq is a command-line tool for tailing and querying JSON log files using SQL and SQLite instead of jq. Built in Rust, it allows developers to monitor logs from multiple services locally and run SQL queries against log… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Jlq – A CLI to easily tail+query JSON log files using Rust+SQLite launched in 2023; newer entries below may have overtaken it.

1
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 →
2
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 →
3
Jql – A JSON Query Language CLI Tool Written in Rust▲9
A JSON Query Language CLI tool. Contribute to yamafaktory/jql development by creating an account on GitHub.
2018 · github.com · its alternatives →
4
GritQL, a Rust CLI for rewriting source code▲280
Hi everyone! I’m excited to open source GritQL, a Rust CLI for searching and transforming source code. GritQL comes from my experiences with conducting large scale refactors and migrations. Usually, I would start exploring a codebase with grep. This is easy to start with, but most migrations end up accumulating additional requirements like ensuring the right packages are imported and excluding cases which don’t have a viable migration path. Eventually, to build a complex migration, I usually ended up having to write a full codemod program with a tool like jscodeshift. This comes with its own…
2024 · github.com · its alternatives →
5
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 →
6
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 →
7
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 →
8
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 →
9
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 →
10
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 →
11
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 →
12
Json2graphql – From a JSON file to Postgres-backed realtime GraphQL▲120
Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events. - graphql-engine/community/tools/json2graphql at master · hasura/graphql-engine
2019 · github.com · its alternatives →
13
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 →
14
Jq-Like Tool for Markdown▲325
There have been a few times I wanted the ability to select some text out of a Markdown doc. For example, a GitHub CI check to ensure that PRs / issues / etc are properly formatted. This can be done to some extent with regex, but those expressions are brittle and hard to read or edit later. mdq uses a familiar pipe syntax to navigate the Markdown in a structured way. It's in 0.x because I don't want to fully commit to the syntax being stable, in case real-world testing shows that the syntax needs tweaking. But I think the project is in a pretty good spot overall, and would be…
2025 · github.com · its alternatives →
15
JQL▲1
A JSON Query Language CLI tool
2020 · github.com · its alternatives →
16
I built jq-like scriptable tool to query CSV and JSON with SQLite▲11
Convert and query JSON, JSONL, CSV, and SQLite with ease! - chand1012/sq
2024 · github.com · its alternatives →
17
SPyQL – SQL with Python in the middle▲105
SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…
2022 · github.com · its alternatives →
18
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 →
19
Write JSON processor queries (jq) in natural language▲38
Hey HN! Jaiqu is an AI agent for creating repeatable JSON transforms using jq query language syntax. Jaiqu translates complex JSON structures into repeatable jq queries. jq is a command line utility built for fast, reliable JSON queries. Jaiqu takes advantage of the LLMs for both constructing jq queries as well as using feedback to fix errors/invalid results if those queries are incorrect. Writing code to parse JSON is super annoying. It usually involves manually reading huge JSON balls, parsing the keys in a language of your choice, and pulling the data manually. Also, you're likely to…
2024 · github.com · its alternatives →
20LO
LogsQL – opinionated query language for logs▲61
I don't like the existing query languages for Elasticsearch and Grafana Loki, because they are too awkward to use for typical logs' investigation cases. So I designed new query language - LogsQL - and wrote reference implementation for it as a part of VictoriaLogs - an open source database for logs. LogsQL is based on the following principles: - Simplicity. It is easy to write typical queries over logs in it. For example, a single word `error` is a valid LogsQL query, which returns all the logs with the `error` word. Another example is `_time:5m error`, which returns all the logs with the…
2024 · docs.victoriametrics.com · its alternatives →
21
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 →
22
JQL by Mixpanel▲96
A powerful new query language to analyze your data
2016 · mixpanel.com · its alternatives →
23
Graphql-java – A complete Java implementation of the GraphQL spec▲65
Contribute to andimarek/graphql-java development by creating an account on GitHub.
2015 · github.com · 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 →