nowfound

Dev tools · alternatives · 2026

24 alternatives to Trdsql – CLI tool that can execute SQL queries on CSV, LTSV, JSON

CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats. - noborus/trdsql

Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Trdsql – CLI tool that can execute SQL queries on CSV, LTSV, JSON launched in 2022; newer entries below may have overtaken it.

  1. 1

    Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.

    2017 · github.com · its alternatives →

  2. 2

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

    2020 · github.com · its alternatives →

  3. 3DU

    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 →

  4. 4

    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 →

  5. 5

    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 →

  6. 6

    Query CSVs using SQL. Contribute to jolmg/cq development by creating an account on GitHub.

    2019 · github.com · its alternatives →

  7. 7
    TABLUM.IO▲159

    Turn CSV, XML & JSON into a live analysis-ready SQL database

    2023 · tablum.io · its alternatives →

  8. 8

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

    2020 · github.com · its alternatives →

  9. 9

    Template Language for SQL with Automatic Bind Parameter Extraction - sripathikrishnan/jinjasql

    2016 · github.com · its alternatives →

  10. 10

    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 →

  11. 11
    soarSQL▲98

    The analytical SQL editor - powered by duckDB

    2025 · its alternatives →

  12. 12

    WhatTheDuck is an in-browser sql tool to analyze csv files that uses duckdb-wasm under the hood. Please provide feedback/issues/pull requests.

    2024 · github.com · its alternatives →

  13. 13

    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 →

  14. 14

    I've always been curious about how SQL engines actually work. So I built a minimum viable SQL engine in Go. - Supports CSV files as tables - Supports SELECT, FROM, WHERE, LIMIT It's very simple: 1. Parses query string 2. Converts it into an AST representation 3. Executes the query against the CSV 4. Returns the results

    2024 · github.com · its alternatives →

  15. 15

    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 · its alternatives →

  16. 16SQ

    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&#x2F;_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 →

  17. 17

    A JSON Query Language CLI tool. Contribute to yamafaktory/jql development by creating an account on GitHub.

    2018 · github.com · its alternatives →

  18. 18

    Non-interactive PostgreSQL query tool. Contribute to soheilpro/pgcmd development by creating an account on GitHub.

    2019 · github.com · its alternatives →

  19. 19

    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

    2020 · github.com · its alternatives →

  20. 20

    SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.

    2025 · github.com · its alternatives →

  21. 21

    zsv+lib: tabular data swiss-army knife CLI + world's fastest (simd) CSV parser - liquidaty/zsv

    2022 · github.com · its alternatives →

  22. 22
    Anyquery▲110

    Query anything with SQL (e.g. Notion, GitHub, JSON)

    2024 · anyquery.dev · its alternatives →

  23. 23

    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:&#x2F;&#x2F;crates.io&#x2F;crates&#x2F;jlq https:&#x2F;&#x2F;github.com&#x2F;hamin&#x2F;jlq

    2023 · github.com · its alternatives →

  24. 24

    A query language for JSON-like structures

    2021 · mistql.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 →