Cursor

How to use Clickhouse with Cursor

You want Clickhouse inside Cursor so it can explore an unfamiliar database, answer a data question with SQL, investigate an unexpected metric, and validate a query against the schema — without you copy-pasting between tabs. Here is the whole setup, once.

Create your Clickhouse gateway

The gateway is the thing Cursor connects to, and it is where you decide which Clickhouse tools an agent may use. You create it once and every client reuses it.

Create an Arcade account

Sign up and open the dashboard. The free tier is enough to follow this through.
Create an MCP Gateway and select your Clickhouse tools

In the dashboard, create a gateway and pick the Clickhouse tools you want to expose. The gateway is what your client connects to, and it is where tool access is decided.
Copy your gateway URL

Every client below needs it.
```
https://api.arcade.dev/mcp/<YOUR-GATEWAY-SLUG>
```

Create a Clickhouse gateway Opens the gateway builder in your Arcade dashboard.

Connect the gateway to Cursor

Heads up

Cursor does not refresh MCP OAuth tokens automatically. For a persistent connection, set Authorization to “Arcade Headers” on the gateway in the dashboard.

Open MCP settings

Command Palette (⌘⇧P / Ctrl+Shift+P) → Open MCP Settings, then click “New MCP Server”.

Add the gateway to mcpServers

{
  "mcpServers": {
    "mcp-arcade": {
      "url": "https://api.arcade.dev/mcp/<YOUR-GATEWAY-SLUG>"
    }
  }
}

Try it out

Ask Cursor to use one of your Clickhouse tools.

Full Cursor guide in the docs steps verified 2026-08-13

Try these Clickhouse prompts

Cursor can now act on your Clickhouse account. Click a prompt to copy it.

Use a credential limited to the databases and tables the agent needs, and keep access read-only to prevent changes. Pair it with Contextual Access policies to control which database access an agent receives, so it can inspect schemas and run queries without broader access.

How to use Clickhouse with Cursor

Create your Clickhouse gateway

Create an Arcade account

Create an MCP Gateway and select your Clickhouse tools

Copy your gateway URL

Connect the gateway to Cursor

Open MCP settings

Add the gateway to mcpServers

Try it out

Try these Clickhouse prompts

Ready to actually ship your agent?