← Back to Integrations
ClickHouse logo — MCP server on Gumloop

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 StartedGet Started
1

Create 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.

2

Copy Your Server URL

Copy your MCP server URL and add it to your client. You'll be prompted to authorize on first use.