Alternatives

Products that do what Jlq – A CLI to easily tail+query JSON log files using Rust+SQLite does

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

1. 1GA
   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

2. 2JI
   jnv: interactive JSON filter using jq▲373

   2024 · github.com

3. 3JQ
   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

4. 4JA
   JQL – A JSON Query Language CLI Tool Built with Rust▲25

   2020 · crates.io

5. 5JE
   jql – Easier jq Alternative with a Lispy Syntax Written in Go▲217

   2020 · github.com

6. 6SP
   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

7. 7TQ
   TextQuery – Query CSV, JSON, XLSX Files with SQL▲163

   2025 · textquery.app

8. 8JA
   Jqview, a simple native GUI for inspecting JSON with jq▲208

   2020 · github.com

9. 9IB
   I built jq-like scriptable tool to query CSV and JSON with SQLite▲11

   2024 · github.com

10. 10JA
    Jql – A JSON Query Language CLI Tool Written in Rust▲9

    2018 · github.com

11. 11SS
    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

12. 12GL
    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

13. 13WJ
    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

14. 14LO
    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

15. 15MA
    MistQL, a mini-language for querying JSON-like structures▲55

    2021 · mistql.com

16. 16JF
    Json2graphql – From a JSON file to Postgres-backed realtime GraphQL▲120

    2019 · github.com

17. 17AT
    A tool like jq, but for parsing HTML▲40

    2022 · github.com

18. 18QL
    Qq: like jq, but can transcode between many formats▲115

    qq is jq inspired interoperable config format transcoder with interactive querying. It features an optional interactive editor with autocomplete for structured data. And supports inputs and outputs for json, xml, ini, toml, yaml, hcl, tf, and csv to varying degrees of capability.

    2024 · github.com

19. 19
    SQL Workbench▲186

    In-browser SQL Workbench for data querying & visualization

    2024

20. 20PU
    PgJQ: Use Jq in Postgres▲39

    2024 · github.com

21. 21PA
    Parqeye – A CLI tool to visualize and inspect Parquet files▲167

    I built a Rust-based CLI/terminal UI for inspecting Parquet files—data, metadata, and row-group-level structure—right from the terminal. If someone sent me a Parquet file, I used to open DuckDB or Polars just to see what was inside. Now I can do it with one command. Repo: https://github.com/kaushiksrini/parqeye

    Nov 2025 · github.com

22. 22JJ
    JAQT – JavaScript Queries and Transformations▲100

    Hi all, I've made a javascript library to simplify searching/sorting/filtering in arrays of objects. Its inspired by both GraphQL and SQL, but implemented using javascript Proxies. Instead of creating a new language, its all just javascript. I've made it as part of an experimental database, which uses javascript as the query engine. The normal javascript map/reduce/sort functions are quite difficult to master for junior developers. JAQT is easier to explain, and can still be used in combination with any existing array functions. Please let me know what you think of the…

    2024 · github.com

23. 23AE
    An example GraphQL server written in Rust▲74

    2020 · github.com

24. 24HA
    Hashquery, a Python library for defining reusable analysis▲67

    Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…

    2024 · hashquery.dev

Ranked by how close each launch is in meaning, then by votes. Refine with a description →