nowfound

Life & fun · February 24, 2024

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

I built jq-like scriptable tool to query CSV and JSON with SQLite launched on February 24, 2024 with 11 votes, #1,240 of 3,962 launches that month and more than 75% of that year's launches. The site was still online in September 2026, 2 years on.

In plain words

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 switching between multiple query languages. The key feature is combining SQLite's query power with a jq-style interface, making it useful for processing and transforming data from common file formats.

written from the facts on this page · September 2026

Does a similar job

all alternatives →
  • TextQuery – Query CSV, JSON, XLSX Files with SQL2025 · textquery.app · ▲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…

  • Querying JSON documents using SQL-like language in Scala2020 · github.com · ▲70

    SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql

  • JSON QueryOct 2025 · jsonquerylang.org · ▲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?

  • jql – Easier jq Alternative with a Lispy Syntax Written in Go2020 · github.com · ▲217

    Easy JSON Query Processor with a Lispy syntax in Go - cube2222/jql

  • Sqlify2017 · ▲191

    JSON, CSV and SQL converter

  • Jqview, a simple native GUI for inspecting JSON with jq2020 · github.com · ▲208

    simplest possible native GUI for inspecting JSON objects with jq - fiatjaf/jqview

More life & fun this month

the category →

Source: Show HN post ↗

Launched alongside, February 2024

the whole month →
  • Flipner AI▲1,623

    Capture your ideas & craft texts with AI's touch

    AI · 2024 · flipner.webflow.io

  • Typeframes▲1,315

    Video creation for makers

    Work · 2024 · revid.ai

  • Superlist▲1,252

    The task layer for your AI agents

    Work · 2024 · superlist.com

  • Never run out of marketing ideas ever again

    Growth · 2024 · marketingideas.com

  • Layers▲1,198

    A home for designers

    Work · 2024 · layers.to

  • Heyday▲1,178

    AI copilot for your own research, notes & conversations

    AI · 2024 · heyday.xyz