← Top 100 Full directory (1,560)

ClickHouse

Databases Remote Official ★ 3,124 13 tools

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

Connect

MCP endpoint

https://clickhouse.run.tools

How to connect

Smithery (hosted)

1. Open https://smithery.ai/servers/clickhouse
2. Click Connect and complete OAuth in your MCP client (Claude, Cursor, VS Code, etc.)
3. MCP 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 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.