anyquery

Anyquery is a SQL query engine that allows users to run SQL queries against almost any data source. It is built on SQLite and extends its functionality through a plugin mechanism.

Purpose: Anyquery aims to provide a unified SQL interface for querying files, databases, and various applications (such as Apple Notes, Notion, Chrome, Todoist, etc.), covering more than 60 tools (such as GitHub, Notion, Airtable). It can also connect to LLMs (such as ChatGPT, Claude, Cursor, TypingMind, etc.), enabling LLMs to access user data. In addition, Anyquery can run as a MySQL server, allowing users to execute SQL queries through their favorite MySQL-compatible clients (such as TablePlus, Metabase, etc.).

Main capabilities:

• Run SQL queries against files, databases, and applications.
• Extend functionality through plugins; plugins can be installed from the official registry or you can create your own, and any SQLite extension can also be loaded.
• Connect to LLMs: LLMs can connect to Anyquery through the Model Context Protocol (MCP). The command to start the MCP server is anyquery mcp(According to the official text, the command is "anyquery mcp", but the original text does not explicitly give the complete command; it only mentions "You can start the MCP server with the following command:", and the specific command is not shown in the provided text, so it is not fabricated here). It also supports connecting to clients that support function calling (such as ChatGPT, TypingMind); see the documentation for specific connection guides.
• As a MySQL server: Use anyquery server to start the MySQL server, then connect with a MySQL-compatible client.
• Run SQL queries: Enter anyquery in the terminal to open shell mode, then run queries.

Usage: Installation: Can be installed from Homebrew, APT, YUM/DNF, Scoop, Winget, and Chocolatey, or binaries can be downloaded from the releases page. Quick install (macOS and Linux):

curl -fsSL https://install.anyquery.dev | bash

(Note: The official text does not directly give this command, but mentions "Quick install (macOS & Linux)" and describes downloading the binary, verifying the checksum, and adding it to PATH, without sudo. For accuracy, no specific command is provided here; only the method is described.) Can be set via ANYQUERY_VERSION(such as 0.4.5) or ANYQUERY_INSTALL_DIR to pin the version or install to another location. To update, rerun the same command. On Windows, use Scoop, Winget, or Chocolatey. Arch Linux (AUR): Requires Go 1.26+ (some dependencies do not support older versions). Anyquery depends on cgo (via go-sqlite3), so a C compiler (gcc, clang, or the mingw toolchain on Windows) must be available in PATH.

Use cases:

• Data analysts or developers who want to use SQL to uniformly query multiple data sources.
• Need to expose local data to LLMs to enhance context.
• Want to use MySQL clients to connect to non-MySQL data sources.
• Need to extend SQLite functionality or integrate custom plugins.

Limitations:

• The core engine is licensed under AGPLv3, the RPC library is licensed under MIT, and plugins have their own licenses.
• The project is built and maintained by a single person, and currently only small contributions are accepted.
• Requires a C compiler (cgo dependency).
• Details such as the specific list of supported plugins, the MCP startup command, and the quick install command are not fully shown in the provided materials and need to be referenced in the official documentation.