what is Anyquery?
Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications like Apple Notes and Notion. It is built on SQLite and supports plugins to enhance its functionality.
how to use Anyquery?
To use Anyquery, you can connect it to LLMs using the Model Context Protocol (MCP) or run SQL queries directly from the terminal. Detailed instructions are available in the documentation.
key features of Anyquery?
- Supports querying multiple data sources (files, databases, apps)
- Connects to LLMs for enhanced data access
- Acts as a MySQL server for compatibility with MySQL clients
- Plugin-based architecture for extended functionality
use cases of Anyquery?
- Running SQL queries on local files and databases.
- Integrating with applications like Notion and Todoist for data retrieval.
- Connecting LLMs to access and manipulate data seamlessly.
FAQ from Anyquery?
- Can Anyquery query any type of data source?
Yes! Anyquery can query files, databases, and various applications through its plugin system.
- Is Anyquery free to use?
Yes! Anyquery is open-source and free to use under the AGPLv3 license for the core engine.
- How can I install Anyquery?
You can install Anyquery using package managers like Homebrew, APT, or download the binary from the releases page.
Anyquery
Anyquery is a SQL query engine that allows you to run SQL queries on pretty much anything. It supports querying files, databases, and apps (e.g. Apple Notes, Notion, Chrome, Todoist, etc.). It's built on top of SQLite and uses plugins to extend its functionality.
It can also connect to LLMs (e.g. ChatGPT, Claude, Cursor, TypingMind, etc.) to allow them to access your data.
Finally, it can act as a MySQL server, allowing you to run SQL queries from your favorite MySQL-compatible client (e.g. TablePlus, Metabase, etc.).
Usage
Connecting LLM
LLMs can connect to Anyquery using the Model Context Protocol (MCP). This protocol provides context for LLMs that support it. You can start the MCP server with the following command:
# To be started by the LLM client
anyquery mcp --stdio
# To connect using an HTTP and SSE tunnel
anyquery mcp --host 127.0.0.1 --port 8070
You can also connect to clients that supports function calling (e.g. ChatGPT, TypingMind). Refer to each connection guide in the documentation for more information.
# Copy the ID returned by the command, and paste it in the LLM client (e.g. ChatGPT, TypingMind)
anyquery gpt
Running SQL queries
The documentation provides detailed instructions on how to run queries with Anyquery.
But let's see a quick example. Type anyquery in your terminal to open the shell mode. Then, run the following query:
You can also launch the MySQL server with anyquery server and connect to it with your favorite MySQL-compatible client.
anyquery server &
mysql -u root -h 127.0.0.1 -P 8070
Installation
The documentation provides detailed instructions on how to install Anyquery on your system. You can install anyquery from Homebrew, APT, YUM/DNF, Scoop, Winget and Chocolatey. You can also download the binary from the releases page.
Homebrew
brew install julien040/anyquery/anyquery
APT
echo "deb [trusted=yes] https://apt.julienc.me/ /" | sudo tee /etc/apt/sources.list.d/anyquery.list
sudo apt update
sudo apt install anyquery
YUM/DNF
echo "[anyquery]
name=Anyquery
baseurl=https://yum.julienc.me/
enabled=1
gpgcheck=0" | sudo tee /etc/yum.repos.d/anyquery.repo
sudo dnf install anyquery
Scoop
scoop bucket add anyquery https://github.com/julien040/anyquery-scoop
scoop install anyquery
Winget
winget install JulienCagniart.anyquery
Chocolatey
choco install anyquery
Plugins
Anyquery is plugin-based, and you can install plugins to extend its functionality. You can install plugins from the official registry or create your own. Anyquery can also load any SQLite extension.
License
Anyquery is licensed under the AGPLv3 license for the core engine. The RPC library is licensed under the MIT license so that anyone can reuse plugins in different projects.
The plugins are not subject to the AGPL license. Each plugins has its own license and the copyright is owned by the plugin author. See the LICENSE file for more information.
Contributing
If you want to contribute to Anyquery, please read the contributing guidelines. I currently only accept minor contributions, but I'm open to any suggestions or feedback.
You can have a brief overview of the project in the architecture documentation.