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
Add this skill
npx mdskills install julien040/anyqueryWell-documented SQL query engine with extensive integration support and clear setup instructions
1# Anyquery23<img src="https://anyquery.dev/images/logo-shadow.png" alt="Anyquery logo" width="96"></img>4567[](https://anyquery.dev)8[](https://github.com/julien040/anyquery/issues)9[](https://anyquery.dev/integrations/)10[](https://anyquery.dev/queries)11[](https://pkg.go.dev/github.com/julien040/anyquery/namespace)12[](https://archestra.ai/mcp-catalog/julien040__anyquery)1314Anyquery is a SQL query engine that allows you to run SQL queries on pretty much anything. It supports querying [files](https://anyquery.dev/docs/usage/querying-files/), [databases](https://anyquery.dev/docs/database), and [apps](https://anyquery.dev/integrations) (e.g. Apple Notes, Notion, Chrome, Todoist, etc.). It's built on top of [SQLite](https://www.sqlite.org) and uses [plugins](https://anyquery.dev/integrations) to extend its functionality.1516It can also connect to [LLMs](https://anyquery.dev/llm) (e.g. ChatGPT, Claude, Cursor, TypingMind, etc.) to allow them to access your data.1718Finally, it can act as a [MySQL server](https://anyquery.dev/docs/usage/mysql-server/), allowing you to run SQL queries from your favorite MySQL-compatible client (e.g. [TablePlus](https://anyquery.dev/connection-guide/tableplus/), [Metabase](https://anyquery.dev/connection-guide/metabase/), etc.).19202122## Usage2324### Connecting LLM2526LLMs can connect to Anyquery using the [Model Context Protocol (MCP)](https://anyquery.dev/docs/reference/commands/anyquery_mcp). This protocol provides context for LLMs that support it. You can start the MCP server with the following command:2728```bash29# To be started by the LLM client30anyquery mcp --stdio31# To connect using an HTTP and SSE tunnel32anyquery mcp --host 127.0.0.1 --port 807033```3435You can also connect to clients that supports function calling (e.g. ChatGPT, TypingMind). Refer to each [connection guide](https://anyquery.dev/integrations#llm) in the documentation for more information.3637```bash38# Copy the ID returned by the command, and paste it in the LLM client (e.g. ChatGPT, TypingMind)39anyquery gpt40```41424344### Running SQL queries4546The [documentation](https://anyquery.dev/docs/usage/running-queries) provides detailed instructions on how to run queries with Anyquery.47But let's see a quick example. Type `anyquery` in your terminal to open the shell mode. Then, run the following query:48495051You can also launch the MySQL server with `anyquery server` and connect to it with your favorite MySQL-compatible client.5253```bash54anyquery server &55mysql -u root -h 127.0.0.1 -P 807056```5758## Installation5960The [documentation](https://anyquery.dev/docs/#installation) 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](https://github.com/julien040/anyquery/releases).6162### Homebrew6364```zsh65brew install anyquery66```67<!--68### Snap6970```bash71sudo snap install anyquery72``` -->73### ARCH LINUX (AUR)7475```bash76# Install using an AUR helper like yay77yay -S anyquery-git7879# paru80paru -S anyquery-git81```8283### APT8485```bash86echo "deb [trusted=yes] https://apt.julienc.me/ /" | sudo tee /etc/apt/sources.list.d/anyquery.list87sudo apt update88sudo apt install anyquery89```9091### YUM/DNF9293```bash94echo "[anyquery]95name=Anyquery96baseurl=https://yum.julienc.me/97enabled=198gpgcheck=0" | sudo tee /etc/yum.repos.d/anyquery.repo99sudo dnf install anyquery100```101102### Scoop103104```powershell105scoop bucket add anyquery https://github.com/julien040/anyquery-scoop106scoop install anyquery107```108109### Winget110111```powershell112winget install JulienCagniart.anyquery113```114115### Chocolatey116117```powershell118choco install anyquery119```120121## Plugins122123Anyquery is plugin-based, and you can install plugins to extend its functionality. You can install plugins from the [official registry](https://anyquery.dev/integrations) or create your own. Anyquery can also [load any SQLite extension](https://anyquery.dev/docs/usage/plugins#using-sqlite-extensions).124125126127## License128129Anyquery 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.130131The plugins are not subject to the AGPL license. Each plugins has its own license and the copyright is owned by the plugin author.132See the [LICENSE](https://github.com/julien040/anquery/blob/main/LICENSE.md) file for more information.133134## Contributing135136If you want to contribute to Anyquery, please read the [contributing guidelines](https://anyquery.dev/docs/developers/project/contributing). I currently only accept minor contributions, but I'm open to any suggestions or feedback.137138You can have a brief overview of the project in the [architecture](https://anyquery.dev/docs/developers/project/architecture/) documentation.139
Full transparency — inspect the skill content before installing.