MCP Directory

How to add Anyquery to Windsurf

Run SQL over files, databases, and 40+ apps (GitHub, Notion, Chrome, Todoist) — and expose them to LLMs via MCP. Paste the config into ~/.codeium/windsurf/mcp_config.json and restart Windsurf.

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

Windsurf 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 Windsurf → Cascade → the hammer/MCP icon → Configure (or edit ~/.codeium/windsurf/mcp_config.json).
  2. 2Paste the Anyquery config below.
  3. 3Fill in placeholder secrets, then save.
  4. 4Click Refresh in the MCP panel.
  5. 5Anyquery's tools become available to Cascade.

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 Windsurf

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 + Windsurf FAQ

Where is the Windsurf config file?

Windsurf reads MCP servers from ~/.codeium/windsurf/mcp_config.json. Paste the Anyquery config there under the "mcpServers" key and restart the client.

Is Anyquery safe to use with Windsurf?

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