
ClickHouse
Query ClickHouse Cloud services via SQL, manage services, backups, ClickPipes and costs, and manage ClickStack observability (dashboards, alerts, sources)
Tools
Execute Query
Execute a SQL query against a ClickHouse Cloud service.
List Organizations
List ClickHouse Cloud organizations, or fetch one by id.
List Services
List services in a ClickHouse Cloud organization, or fetch one by id.
List Service Backups
List backups for a service (most recent first), or fetch one by id.
Get Service Backup Configuration
Get the backup schedule and retention configuration for a service.
List Clickpipes
List ClickPipes configured on a service, or fetch one by id.
Get Organization Cost
Retrieve daily billing and usage cost data for a ClickHouse Cloud organization (max 31-day window).
Update Service State
Start or stop a ClickHouse Cloud service.
List Dashboards
List ClickStack dashboards configured on a service, or fetch one by id.
Create Dashboard
Create a ClickStack dashboard.
Update Dashboard
Update a ClickStack dashboard.
Delete Dashboard
Delete a ClickStack dashboard.
List Alerts
List ClickStack alerts configured on a service, or fetch one by id.
Create Alert
Create a ClickStack alert tied to a dashboard tile or a saved search.
Update Alert
Update a ClickStack alert.
Delete Alert
Delete a ClickStack alert.
List Sources
List ClickStack data sources configured on a service. Source IDs are required to attach dashboards and alerts.
Installation Steps
Get StartedCreate a Gumloop Account
To use this MCP, you need a Gumloop account. If you don't have one yet, you can create one for free.
Copy Your Server URL
Copy your MCP server URL and add it to your client. You'll be prompted to authorize on first use.