About Anyquery
Anyquery is an open source SQL engine that turns everyday apps, services and files into queryable tables. GitHub, Notion, Spotify, Gmail, Airtable, Google Sheets, CSV and Parquet files, logs and more than forty other sources can be read with a plain SELECT statement and joined against one another, without learning each service's API or installing separate command line tools. It also runs as an MCP server, so AI assistants can answer questions with real data from those sources.
It is built for developers, analysts and technically minded individuals who want one query language across scattered personal and work data. The engine is built on SQLite and runs locally on the user's machine, with no cloud service or ETL pipeline, and API tokens stay on the device. It exposes the MySQL wire protocol, so BI tools such as Metabase, Tableau and Looker can connect directly. Writes are supported too: INSERT, UPDATE and DELETE work on Notion, Airtable and Google Sheets. A query hub offers community queries that can be reused without writing SQL, and PRQL and Kusto are accepted as alternatives to SQL. The single command anyquery mcp connects it to Claude Desktop, ChatGPT, Cursor, TypingMind, LibreChat, Zed, Windsurf and other MCP clients.
Anyquery is free and released under the AGPL 3.0 licence. It runs on macOS, Linux and Windows and installs through Homebrew and other package managers. There are no paid plans.
The project is maintained by an individual developer rather than a company, which buyers weighing it for production use should factor in.