ClickHouse

Query ClickHouse Cloud — run SQL, list databases and tables, explore services and backups, inspect usage, run ClickPipes.

CommunityOnlineNo sign-inGlobalFreeRead-only

What it can do

Get Clickpipe: Returns the specified ClickPipe.
Get Organizations: Retrieves all accessible ClickHouse Cloud organizations.
Run Select Query: Executes a SELECT query against a ClickHouse service. Runs a read-only SELECT query on the specified ClickHouse service via the Query API endpoint. This function provides direct acce

What data it sees

Do you need an account

No: the server works without sign-in

Query ClickHouse Cloud — run SQL, list databases and tables, explore services and backups, inspect usage, run ClickPipes.

How to connect

How to connect ClickHouse to Claude

The server address to paste into Claude settings:

https://clickhouse.run.tools

Open Claude (claude.ai or the desktop app).
Go to Settings → Connectors.
Click Add custom connector.
Paste the server address copied below into Remote MCP server URL and click Add.
In a chat, click + → Connectors and switch the new connector on.

Custom connectors are available on Free, Pro, Max, Team and Enterprise plans (Free is limited to one). On Team and Enterprise an organization Owner adds the connector first under Organization settings → Connectors.

Authorization

After you click Add, a sign-in window for the service opens. Sign in with your own account and approve access. Claude never sees your password.

How to connect ClickHouse to ChatGPT

The server address to paste into ChatGPT settings:

https://clickhouse.run.tools

Open ChatGPT in a browser (chatgpt.com). A Plus, Pro, Business, Enterprise or Edu plan is required.
Turn on developer mode once: Settings → Apps → Advanced settings → Developer mode.
Open Settings → Connectors and click Create.
Fill in the form: Name (anything), Description (one line about what the service does), MCP server URL (copy it below).
Under Authentication choose OAuth if the service requires sign-in, otherwise None. Click Create.
In a new chat open + → Apps/Connectors and enable the connector.

OpenAI has renamed this section before (Connectors → Apps/Plugins). If the label differs, search settings for "developer mode". On Business/Enterprise workspaces an admin must allow custom connectors first.

Authorization

On first use ChatGPT opens the service's sign-in window. Sign in and approve access.

How to connect ClickHouse to Cursor

The server address to paste into Cursor settings:

https://clickhouse.run.tools

Fastest: click Open in Cursor below and confirm the prompt.

Manually:

In Cursor open Settings → Cursor Settings → MCP and click Add new global MCP server.
Paste the JSON copied below into ~/.cursor/mcp.json (per project: .cursor/mcp.json in the repo root).
Save the file. The server appears in the MCP list; authorize it there if asked.

Authorization

If the service needs sign-in, an authorize button appears next to the server in the MCP list.

Server tool list (13)

Raw names from tools/list. Only developers need these.

get_clickpipe	Returns the specified ClickPipe.
get_organizations	Retrieves all accessible ClickHouse Cloud organizations.
run_select_query	Executes a SELECT query against a ClickHouse service. Runs a read-only SELECT query on the specified ClickHouse service via the Query API endpoint. This function provides direct access to database content through SQL queries while ensuring that only read operations are permitted.
list_databases	Retrieves all databases available in a ClickHouse service.
list_tables	Retrieves a comprehensive list of tables in a ClickHouse database, including columns.
get_services_list	Retrieves all services in a ClickHouse Cloud organization.
get_organization_details	Returns details of a single organization. The auth key must belong to the organization.
get_service_details	Returns a service that belongs to the organization.
list_clickpipes	Retrieves all ClickPipes configured for a specific service.
list_service_backups	Returns a list of all backups for the service. The most recent backups comes first in the list.
get_organization_cost	Retrieves billing and usage cost data for a ClickHouse Cloud organization. Returns a grand total and a list of daily, per-entity organization usage cost records for the organization in the queried time period (maximum 31 days).
get_service_backup_details	Returns a single backup info.
get_service_backup_configuration	Returns the service backup configuration.