# ClickHouse (verified)

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

## Quick Start

```bash
# Connect this server (installs CLI if needed)
npx -y @smithery/cli@latest mcp add clickhouse

# Browse available tools
npx -y @smithery/cli@latest tool list clickhouse

# Get full schema for a tool
npx -y @smithery/cli@latest tool get clickhouse get_clickpipe

# Call a tool
npx -y @smithery/cli@latest tool call clickhouse get_clickpipe '{}'
```

## Direct MCP Connection

Endpoint: `https://clickhouse.run.tools`

## Tools (13)

- `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…
- `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, p…
- `get_service_backup_details` — Returns a single backup info.
- `get_service_backup_configuration` — Returns the service backup configuration.

```bash
# Get full input/output schema for a tool
npx -y @smithery/cli@latest tool get clickhouse <tool-name>
```