Dev tools · alternatives · 2026
24 alternatives to Sql2json – Python package to run SQL query and get JSON result
Python CLI tool to run queries against sqltatabases and convert the results to json, csv, excel in the command line or python program. Easy to use for Humans, automations, LLMS/Agents - fsistemas/sql2json
Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Sql2json – Python package to run SQL query and get JSON result launched in 2020; newer entries below may have overtaken it.
- 1
- 2
JSON Query▲154I'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 →
- 3
LLM 0.26 is out with the biggest new feature since I started the project: support for tools. You can now use the LLM CLI tool—and Python library—to grant LLMs from …
2025 · simonwillison.net · its alternatives →
- 4EC
2017 · exceljson.com · its alternatives →
- 5
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 →
- 6
Use your Google Sheets as a JSON API. Connect Google Spreadsheets with your CRM or any other tool using JSON API and RESTful requests.
2015 · sheetsu.com · its alternatives →
- 7
SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql
2020 · github.com · its alternatives →
- 8
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 →
- 9
Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql
2020 · github.com · its alternatives →
- 10
Convert and query JSON, JSONL, CSV, and SQLite with ease! - chand1012/sq
2024 · github.com · its alternatives →
- 11
TABLUM.IO▲159Turn CSV, XML & JSON into a live analysis-ready SQL database
2023 · tablum.io · its alternatives →
- 12
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 →
- 13
simplest possible native GUI for inspecting JSON objects with jq - fiatjaf/jqview
2020 · github.com · its alternatives →
- 14SQ
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 →
- 15
- 16
- 17
CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats. - noborus/trdsql
2022 · github.com · its alternatives →
- 18
Hi folks, My friend Sami and I recently built Vizly, a Mac application that allows anyone to query their databases using plain English. Vizly is built on Llama 2, llama.cpp, and runs fully on-prem (edit: meaning everything is local and your data never leaves your own computer). We are running two Llama models, one for natural language to SQL translation, and another that uses the results from the SQL to render visualizations. That means there are no external APIs and all the AI models are running locally on your MacBook. We tried to make Vizly very easy to share as well. Every Vizly instance…
2023 · vizly.fyi · its alternatives →
- 19
Query CSVs using SQL. Contribute to jolmg/cq development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 20
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 →
- 21
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 →
- 22RS
2021 · spanrr.com · its alternatives →
- 23
Clean messy CSV, Excel, JSON with one Python script
2025 · payhip.com · its alternatives →
- 24
Simple XLSX and CSV to dictionary converter. Contribute to Pytlicek/sheet2dict development by creating an account on GitHub.
2021 · github.com · 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 →