ClickHouse (verified)
Query ClickHouse Cloud — run SQL, list databases and tables, explore services and backups, inspect usage, run ClickPipes.
Quick Start
# Connect this server (installs CLI if needed)
npx -y smithery mcp add clickhouse
# Browse available tools
npx -y smithery tool list clickhouse
# Get full schema for a tool
npx -y smithery tool get clickhouse get_clickpipe
# Call a tool
npx -y smithery 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.
# Get full input/output schema for a tool
npx -y smithery tool get clickhouse