MCP Directory

How to add Anyquery to Claude Desktop

Run SQL over files, databases, and 40+ apps (GitHub, Notion, Chrome, Todoist) — and expose them to LLMs via MCP. Paste the config into ~/Library/Application Support/Claude/claude_desktop_config.json and restart Claude Desktop.

Last updated June 14, 2026 · 1.7k★ · stdio · no auth

Claude Desktop config for Anyquery

brew install anyquery
{
  "mcpServers": {
    "anyquery": {
      "command": "path/to/anyquery/that/you/copied/from/step-3",
      "args": [
        "mcp",
        "--stdio"
      ]
    }
  }
}

Setup steps

  1. 1Open Claude Desktop → Settings → Developer → Edit Config (this opens ~/Library/Application Support/Claude/claude_desktop_config.json).
  2. 2Paste the Anyquery config below under the top-level "mcpServers" key.
  3. 3Fill in any placeholder secrets (API keys, paths) in the snippet.
  4. 4Save the file, then fully quit and reopen Claude Desktop.
  5. 5Open a chat and confirm Anyquery's tools appear under the 🔌 tools menu.

Before you start

  • Install the anyquery binary (Homebrew, APT, YUM/DNF, Scoop, Winget, Chocolatey, AUR, or release binary)
  • An MCP-compatible client (e.g. Claude Desktop, Cursor, Windsurf)
  • Optionally install plugins from the Anyquery registry to query specific apps/data sources

What Anyquery can do in Claude Desktop

listTables

Lists all the tables available. When the user requests data or wants an action (insert/update/delete), the model calls this to check if a table corresponds to the request.

describeTable

Describes a table — returns its columns, the supported operations, and SQL examples. Must be called for each table before executeQuery.

executeQuery

Executes a SQL query (SELECT, INSERT, UPDATE, or DELETE) on the database, according to what each table's schema supports.

Security

Runs locally and queries your connected data sources, files, and app integrations; the executeQuery tool can run INSERT/UPDATE/DELETE statements on tables that support them, so the LLM may modify connected data. The HTTP/SSE transport binds to 127.0.0.1:8070 by default and supports a --no-auth flag and an internet tunnel (--tunnel); exposing the server beyond localhost without authentication grants query access to all connected data.

Anyquery + Claude Desktop FAQ

Where is the Claude Desktop config file?

Claude Desktop reads MCP servers from ~/Library/Application Support/Claude/claude_desktop_config.json. Paste the Anyquery config there under the "mcpServers" key and restart the client.

Is Anyquery safe to use with Claude Desktop?

Runs locally and queries your connected data sources, files, and app integrations; the executeQuery tool can run INSERT/UPDATE/DELETE statements on tables that support them, so the LLM may modify connected data. The HTTP/SSE transport binds to 127.0.0.1:8070 by default and supports a --no-auth flag and an internet tunnel (--tunnel); exposing the server beyond localhost without authentication grants query access to all connected data.

How do I start the MCP server?

Run `anyquery mcp --stdio` (started by your MCP client) for stdio transport, or `anyquery mcp --host 127.0.0.1 --port 8070` for an HTTP/SSE tunnel.

Which clients can connect?

Any MCP-compatible client such as Claude Desktop, Cursor, or Windsurf. Anyquery also supports function-calling clients like ChatGPT and TypingMind via `anyquery gpt`.

How do I add new data sources?

Install plugins from the official Anyquery registry (40+ integrations) or load any SQLite extension. You can also pass a SQLite database with the `--database` flag.

View repo Full Anyquery page