Anyquery

What is Anyquery?

Anyquery is a SQL query engine built on SQLite that lets you run SQL queries on files, databases, and apps (e.g. Apple Notes, Notion, Chrome, Todoist). It uses plugins to extend its functionality and can connect to LLMs such as ChatGPT, Claude, Cursor, and TypingMind via the Model Context Protocol (MCP) or function calling. It can also act as a MySQL server, allowing you to query from any MySQL-compatible client.

How to use Anyquery?

Start the MCP server for LLM integration with anyquery mcp --stdio (stdio transport) or anyquery mcp --host 127.0.0.1 --port 8070 (HTTP/SSE). For function calling clients, run anyquery gpt and paste the returned ID into the client. Anyquery can be installed via Homebrew, APT, YUM/DNF, Scoop, Winget, or Chocolatey.

Key features of Anyquery

• SQL query engine for files, databases, and apps
• Plugin-based architecture with an official plugin registry
• Connects to LLMs via MCP or function calling
• Acts as a MySQL-compatible server
• Can load any SQLite extension
• Available on multiple package managers

Use cases of Anyquery

• Query your local files (CSV, JSON, etc.) with SQL
• Run SQL queries across apps like Notion, Todoist, or Chrome
• Give LLMs (ChatGPT, Claude, Cursor) real-time access to your data
• Connect business intelligence tools (e.g. Metabase, TablePlus) via the MySQL server

FAQ from Anyquery

What sources can Anyquery query?

Anyquery can query files, databases, and apps (e.g. Apple Notes, Notion, Chrome, Todoist) through its plugin system.

How does Anyquery connect to LLMs?

Anyquery connects to LLMs using the Model Context Protocol (MCP) or function calling. Start the MCP server with anyquery mcp --stdio or use anyquery gpt to get an ID for function calling clients.

What are the system requirements?

Anyquery runs on any system that supports the available installation methods (Homebrew, APT, YUM/DNF, Scoop, Winget, Chocolatey). It is a Go binary and does not require a separate database server.

Is Anyquery open source?

The core engine is licensed under AGPLv3. The RPC library is MIT-licensed. Plugins have their own licenses and are not subject to the AGPL.

How do I install plugins?

Plugins can be installed from the official registry at anyquery.dev/integrations. Anyquery can also load any SQLite extension.