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/
