julien040/anyquery

What it solves

Anyquery provides a unified way to query data across disparate sources—files, databases, and third-party applications (like Notion, Chrome, and Apple Notes)—using standard SQL. It eliminates the need to write custom scripts or learn multiple proprietary APIs to extract and analyze data from different platforms.

How it works

Built on top of SQLite, Anyquery uses a plugin system to translate SQL queries into requests that can be fulfilled by various data sources. It can operate as a standalone shell, a MySQL-compatible server for use with existing database clients, or an MCP (Model Context Protocol) server to provide LLMs with structured data access.

Who it’s for

• Data Analysts and Developers who want to query multiple apps and files using a single SQL interface.
• AI Engineers looking to provide LLMs with a standardized way to access and query a user's personal or organizational data.
• Power Users who prefer using SQL-compatible tools (like TablePlus or Metabase) to explore their data across different apps.

Highlights

• Broad Integration Support: Query files, databases, and apps via plugins.
• LLM Connectivity: Supports the Model Context Protocol (MCP) and function calling for integration with clients like ChatGPT and Claude.
• MySQL Compatibility: Can act as a MySQL server, allowing the use of any MySQL-compatible client.
• Extensible: Supports official plugins and any standard SQLite extension.