Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)
Hey HN, I’m Julien, and after finishing my CS sophomore year, I wanted a project to keep me busy during the summer. So I built anyquery for fun, a SQL query engine for pretty much anything. SQL is the industry standard query language for databases. But what if it could query other services? That’s what I wanted to explore. Kinda like Yahoo! Query Language, except that I was too young to see it. Anyquery can run queries on local/remote files (CSV, JSON, logs with Grok, Parquet, HTML tables, etc.), SaaS (GitHub, Notion, Spotify, etc.) and local apps (Apple Notes, Git, Google Chrome tabs,…
In plain words
Anyquery is a SQL query engine that lets users run SQL commands on diverse data sources including CSV files, JSON, GitHub, Notion, Spotify, Apple Notes, and other local and cloud services. It supports 35 integrations and can transform Google Sheets and Airtable bases into queryable SQL databases with full write capabilities. The tool also functions as a MySQL server to work with existing business intelligence tools and ORMs, making it useful for developers and data analysts who want to query multiple data sources using standard SQL syntax.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hey HN, I’m Julien, and after finishing my CS sophomore year, I wanted a project to keep me busy during the summer. So I built anyquery for fun, a SQL query engine for pretty much anything. SQL is the industry standard query language for databases. But what if it could query other services? That’s what I wanted to explore. Kinda like Yahoo! Query Language, except that I was too young to see it. Anyquery can run queries on local/remote files (CSV, JSON, logs with Grok, Parquet, HTML tables, etc.), SaaS (GitHub, Notion, Spotify, etc.) and local apps (Apple Notes, Git, Google Chrome tabs, etc.). I’ve built 35 integrations. Anyquery can also transform a Google Sheets or an Airtable base into a SQL database with INSERT/UPDATE/DELETE support. Additionally, it can act as a MySQL server to leverage its ecosystem (BI tools, ORMs, etc.). Finally, you can run PRQL and PQL (KQL inspired language) queries with it. Under the hood, it uses Go and SQLite's virtual tables. Therefore, you can use the SQLite ecosystem (like sqlite-vec, datasette, etc.). The project is licensed under the AGPL-v3. Personally, I find the project useful for data migration (I’m using it to transfer my Pocket bookmarks to Raindrop) and data visualization (connecting my GitHub data to Metabase or Tableau) I would love to hear your feedback about the project. Website: https://anyquery.dev/docs/#installation Source code: https://github.com/julien040/anyquery Brief overview of the architecture: https://anyquery.dev/docs/developers/project/architecture/
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, August 2024
the whole month →
- IY
Life & fun · 2024 · ytch.xyz
- IA
Hey there HN! We’re Joe and Stopa, and today we’re open sourcing InstantDB, a client-side database that makes it easy to build real-time and collaborative apps like Notion and Figma. Building modern apps these days involves a lot of schleps. For a basic CRUD app you need to spin up servers, wire up endpoints, integrate auth, add permissions, and then marshal data from the backend to the frontend and back again. If you want to deliver a buttery smooth user experience, you’ll need to add optimistic updates and rollbacks. We do these steps over and over for every feature we build, which can…
Dev tools · 2024 · github.com