TextQuery – Query CSV, JSON, XLSX Files with SQL

In plain words

TextQuery is a developer tool that lets users query CSV, JSON, and XLSX files using SQL commands. It launched in May 2025 and is designed for developers and data analysts who need to extract and analyze data from common file formats without converting them first. The tool's main advantage is combining SQL's familiarity with support for multiple file types in a single application.

written from the facts on this page · September 2026

From the sources

TextQuery is a desktop app to import data file as a table, query it using SQL.

TextQuery is an all-in-one desktop app to import, query, modify, and visualize your raw data with SQL. TextQuery lets you import multiple data files without needing to define schema, writing code, or commands. Our best-in-class SQL editor offers multiple features to help you write queries faster. Create clean, beautiful charts right within the app. Simple to use and easy to customize. Quickly edit values, collect your changes, and commit them in one go. Quickly narrow down table's rows using filters. No need to write queries manually. Work on multiple queries and tables simultaneously using tabs. Export data in multiple formats (CSV, JSON, Excel, SQL) or create another table with the…from textquery.app

In the maker’s words, at launch

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…

• 
  cq – Query CSVs using SQL2019 · github.com · ▲80

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

• 
  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?

• 
  Anyquery2024 · anyquery.dev · ▲110

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

• 
  FSQL – Search through your file system with SQL-esque queries2017 · github.com · ▲341

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

• 
  I built jq-like scriptable tool to query CSV and JSON with SQLite2024 · github.com · ▲11

  Convert and query JSON, JSONL, CSV, and SQLite with ease! - chand1012/sq

• DU
  Duck-UI – Browser-Based SQL IDE for DuckDB2025 · demo.duckui.com · ▲213

  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…

• 
  /dev/null▲489

  a social network for devs

  Dev tools · 3d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 28d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 26d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 23d ago · openbot.run

• 
  Talanoa▲346

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 21d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 29d ago · corespeed.io

• 
  Tapflow 2.0▲1,125

  We built Tapflow for devs, designers, PMs, and tech folks who’ve been sitting on internal docs, templates, and systems — but never productized them. Upload a PDF, notes, or workshop deck, and Tapflow drafts a structured product (with chapters, teaser and pricing plans). It’s good for AI kits, onboarding guides, design systems, and frameworks. You can sell through Stripe, LemonSqueezy, or PayPal. Real-time collaboration is in early beta. No site builder, no LMS — clean design and just focused tools to ship. Fully bootstrapped and just launched on PH today →…

  Work · 2025 · tapflow.ai

• C9
  Clippy – 90s UI for local LLMs▲1,122

  Life & fun · 2025 · felixrieseberg.github.io

• 
  Appwrite Sites▲990

  Appwrite 2.0 brings a new engine, a rebuilt Console, five database types, an S3 API, an OAuth 2.1 server, and organization-level Domains and Firewall.

  Dev tools · 2025 · appwrite.io

• 
  AI Meeting Notes by Notion▲965

  Perfect meeting memory in Notion

  AI · 2025 · notion.com

• 
  Den▲948

  Multiplayer AI agent builder

  AI · 2025 · getden.io

• 
  Raycast for iOS▲870

  Powerful productivity on the go

  AI · 2025 · raycast.com