Anyquery
🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
What is Anyquery?
Anyquery is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to 🏎️ 🏠 ☁️ - query more than 40 apps with one binary using sql. it can also connect to your postgresql, mysql, or sqlite compatible database. local-first and private by design.
🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- 🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL.
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx anyqueryConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Anyquery
Anyquery is a universal SQL query engine that lets you run SQL queries against 40+ applications — including Apple Notes, Notion, Chrome bookmarks, Todoist, GitHub, and more — as well as PostgreSQL, MySQL, and SQLite databases, all from a single local binary. It exposes these data sources as a Model Context Protocol server so AI assistants can query your personal and professional data using structured SQL without any data leaving your machine. Developers and power users choose Anyquery to give their AI tools private, local-first access to cross-app data for analytics, reporting, and automation.
Prerequisites
- Anyquery binary installed (via Homebrew, Scoop, Winget, apt, or direct download)
- The applications you want to query (e.g. Notion, Chrome, Todoist) and any required plugin credentials
- An MCP-compatible AI client: Claude Desktop, Cursor, or similar
- No API keys required for local data sources; third-party app plugins may require OAuth tokens
Install the Anyquery binary
Install Anyquery for your operating system using the appropriate package manager. Homebrew is recommended for macOS and Linux.
# macOS / Linux
brew install anyquery
# Windows (Winget)
winget install JulienCagniart.anyquery
# Windows (Scoop)
scoop bucket add anyquery https://github.com/julien040/anyquery-scoop && scoop install anyqueryInstall plugins for the apps you want to query
Anyquery uses plugins for each supported application. Install the ones you need and follow the authentication prompts to connect them to your accounts.
# List available plugins
anyquery plugin list
# Install a plugin (example: Notion)
anyquery plugin install notionStart Anyquery in MCP mode
Run Anyquery as an MCP server. It will listen for SQL queries from connected AI clients via the Model Context Protocol.
anyquery mcpAdd Anyquery to your MCP client configuration
Configure your AI client to launch Anyquery in MCP mode. Add this block to your claude_desktop_config.json or equivalent configuration file.
{
"mcpServers": {
"anyquery": {
"command": "anyquery",
"args": ["mcp"]
}
}
}Query your data through the AI assistant
Restart your client and ask the AI to query data from any of your connected applications. Anyquery translates the AI's SQL queries into app-specific API calls and returns results locally.
Anyquery Examples
Client configuration
Claude Desktop config to launch Anyquery as an MCP server for local-first SQL access to 40+ apps.
{
"mcpServers": {
"anyquery": {
"command": "anyquery",
"args": ["mcp"]
}
}
}Prompts to try
These prompts demonstrate querying multiple apps via SQL through the Anyquery MCP server.
- "Show me all Todoist tasks due this week, grouped by project"
- "List all Chrome bookmarks added in the last 30 days and their URLs"
- "Query my Notion database 'Projects' and show items with status = In Progress"
- "How many GitHub issues did I open last month across all my repositories?"
- "Give me a summary of my Apple Notes created this year, sorted by last modified date"Troubleshooting Anyquery
Plugin authentication fails or returns no data
Run anyquery plugin install <name> manually in your terminal and complete the OAuth flow. Tokens are stored locally. Some plugins (e.g. Notion) require you to share specific databases with the integration before they appear in queries.
anyquery command not found when MCP client launches the server
MCP clients may not inherit your shell PATH. Use the full absolute path to the anyquery binary in your config, e.g. "/opt/homebrew/bin/anyquery" on macOS with Homebrew.
SQL query returns an error about unknown table
Each app plugin creates tables with specific names. Run 'anyquery tables' in the terminal to list all available tables, or ask your AI assistant to 'list available anyquery tables' to discover what you have installed.
Frequently Asked Questions about Anyquery
What is Anyquery?
Anyquery is a Model Context Protocol (MCP) server that 🏎️ 🏠 ☁️ - query more than 40 apps with one binary using sql. it can also connect to your postgresql, mysql, or sqlite compatible database. local-first and private by design. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Anyquery?
Follow the installation instructions on the Anyquery GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Anyquery?
Anyquery works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Anyquery free to use?
Yes, Anyquery is open source and available under the NOASSERTION license. You can use it freely in both personal and commercial projects.
Anyquery Alternatives — Similar Databases Servers
Looking for alternatives to Anyquery? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
MySQL
★ 1.7kProvides access to MySQL databases with fine-grained access control, supporting multiple databases simultaneously with configurable access modes (readonly, readwrite, full) and table-level permissions using whitelists, blacklists, wildcards, and rege
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Anyquery in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Anyquery?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.