Skip to content

Connectors · Developer & infrastructure

ClickHouse Cloud MCP server for AI agents.

actionlake is an MCP gateway: one remote MCP server that connects Claude and other MCP clients to ClickHouse Cloud and the rest of your systems. It gives your agent 169 ClickHouse Cloud actions (83 reads, 59 writes and 27 that wait for a confirmation) and holds the ClickHouse Cloud credential itself, so the agent never does. It paces ClickHouse Cloud's limits and records every call.

100,000 free calls a month. No card, no email, no password: press Start a free sandbox on the next screen and keep the key it shows you.

claude mcp add --transport http actionlake https://connect.actionlake.com/mcp
the first call
do {  action: "clickhouse_cloud.organizations.list",  intent: "check which ClickHouse Cloud account is connected"}# Get list of available organizations · read · 1 upstream call
  • 169actionsin one signed file
  • 83readlook, never change
  • 59writecreate and update
  • 27wait for a yesdestructive, confirmed first

Set up

Connect ClickHouse Cloud in three steps.

  1. 01

    Add actionlake to Claude.

    Run the command once in Claude Code; its consent page can create a free sandbox: 100,000 calls a month, no card. In the Claude app, add a custom connector with the URL below and paste your key on the consent page. Creating a new sandbox from the Claude app is not yet tested by us.

    https://connect.actionlake.com/mcp
  2. 02

    Connect ClickHouse Cloud.

    Username and secret. No consent screen: your agent can connect it for you, but the key then passes through your chat. To keep it out of the model's context, paste it in the console instead. actionlake stores what you paste write-only, sealed under your tenant's key.

    • key_idClickHouse Cloud API key ID
    • key_secretClickHouse Cloud API key secret, shown once when the key is created
    account { op: "connections.requirements", service: "clickhouse_cloud" }
    # free: exactly what to paste, and what is found for you
  3. 03

    Make the first call. Check before a write.

    Ask in plain words; Claude picks the action. Before anything changes, check validates the call and prices it, for free.

    do    { action: "clickhouse_cloud.organizations.list" }# get list of available organizations · read · 1 upstream callcheck { action: "clickhouse_cloud.roles.create", input: { … } }# free: inputs, permissions, cost and confirmations, nothing sent

ClickHouse Cloud at a glance

Sign-in
Username and secret. No consent screen: your agent can connect it for you, but the key then passes through your chat. To keep it out of the model's context, paste it in the console instead.
You provide
key_idkey_secret
Limits we pace to
10 calls per 10 seconds, per connection
API covered
ClickHouse Cloud API v1 (OpenAPI 3.1.1, 174 operations)api.clickhouse.cloud
Built from
ClickHouse Cloud's documentation, read 22 October 2026api.clickhouse.cloudclickhouse.com
Service file
Version 1.0.0, signed (Ed25519)
Cached reads
75 of 83 reads, for up to 5 minutes; a write clears what it affects
Shared entities
3, so ask can line ClickHouse Cloud up with your other systems
Data
Processed and stored in Sydney, Australia. No US region yet

Capabilities

What an AI agent can do in ClickHouse Cloud.

169 actions in 65 areas. Every one carries its effect, so a key can allow the reads and hold the rest.

  • 83readlook, never change
  • 59writecreate and update
  • 27destructivewait for a confirmation
  1. Service clickpipes

    7

    4 read · 2 write · 1 destructive

    Create ClickPipe · Discover ClickPipe source schema · List ClickPipes · Get ClickPipe

  2. Service clickstack dashboards

    6

    3 read · 2 write · 1 destructive

    ClickStack: List Dashboards · ClickStack: Create Dashboard · ClickStack: Get Dashboard · ClickStack: Update Dashboard

  3. Byoc infrastructure

    5

    2 read · 2 write · 1 destructive

    Create BYOC Infrastructure · Validate BYOC infrastructure prerequisites · Get BYOC infrastructure details · Update BYOC Infrastructure

  4. Keys

    5

    2 read · 2 write · 1 destructive

    Create key · Get list of keys · Get key details · Delete key

  5. Postgres

    5

    2 read · 2 write · 1 destructive

    Create new Postgres service · List of organization Postgres services · Get PostgreSQL service details · Update a PostgreSQL service

  6. Roles

    5

    2 read · 2 write · 1 destructive

    List all available roles for an organization · Create a new role · Get role details · Update a role

  7. Service clickhouse settings

    5

    3 read · 1 write · 1 destructive

    Get ClickHouse setting · List ClickHouse settings · Get ClickHouse settings schema · Update ClickHouse settings

  8. Service clickpipes reverse private endpoints

    5

    2 read · 2 write · 1 destructive

    Create reverse private endpoint · List reverse private endpoints · Get reverse private endpoint · Update reverse private endpoint

57 more areas · 126 actions
  • Service clickstack alerts 5
  • Service clickstack roles 5
  • Service clickstack saved searches 5
  • Service clickstack sources 5
  • Service clickstack webhooks 5
  • Service query API endpoints 5
  • Service saved queries 5
  • Services 5
  • Invitations 4
  • Members 4
  • Service backup bucket 4
  • Udf attachments 4
  • Udfs 4
  • Organizations 3
  • Postgres config 3
  • Service query endpoint 3
  • Service scaling schedule 3
  • Service upgrade window 3
  • Udf versions 3
  • Activities 2
  • Postgres slow query patterns 2
  • Quotas 2
  • Service backup configuration 2
  • Service backups 2
  • Service clickpipe settings 2
  • Service clickpipes CDC scaling 2
  • Service replica aware routing 2
  • Service snapshot configuration 2
  • Service snapshots 2
  • Active balances 1
  • Byoc infrastructure private endpoint config 1
  • Byoc infrastructure progress 1
  • Byoc infrastructure tags 1
  • Credit balances 1
  • Notification types 1
  • Notifications 1
  • Postgres backups 1
  • Postgres logs 1
  • Postgres metrics 1
  • Postgres password 1
  • Postgres read replica 1
  • Postgres restored service 1
  • Postgres state 1
  • Private endpoint config 1
  • Prometheus discovery 1
  • Service clickpipe scaling 1
  • Service clickpipe state 1
  • Service password 1
  • Service private endpoint 1
  • Service private endpoint config 1
  • Service profiles 1
  • Service replica scaling 1
  • Service scaling 1
  • Service state 1
  • Udf uploads 1
  • Usage cost 1
  • Whoami 1

Top actions

The ClickHouse Cloud API, shaped for agents.

The ids your agent types, what each does, and the one name it shares with other systems. 35 of ClickHouse Cloud's 35 action names are shared with at least one other connector, so an agent learns them once.

ActionWhat it doesEffectSame name in
clickhouse_cloud.members.listList organization membersList organization members.readidentity.user.list474 connectors
clickhouse_cloud.roles.listList all available roles for an organizationList all available roles for an organization.readidentity.role.list184 connectors
clickhouse_cloud.members.getGet member detailsGet member details.readidentity.user.get399 connectors
clickhouse_cloud.roles.createCreate a new roleCreate a new role.writeidentity.role.create105 connectors
clickhouse_cloud.members.deleteRemove an organization memberRemove an organization member.destructiveidentity.user.delete253 connectors
clickhouse_cloud.whoami.getResolve the caller identityResolve the caller identity.readidentity.current_user.get307 connectors
clickhouse_cloud.keys.createCreate keyCreate key.writeidentity.api_key.create100 connectors
clickhouse_cloud.keys.listGet list of keysGet list of keys.readidentity.api_key.list96 connectors
clickhouse_cloud.activities.listList of organization activitiesList of organization activities.readidentity.audit_event.list51 connectors
clickhouse_cloud.invitations.createCreate an invitationCreate an invitation.writeidentity.invitation.create41 connectors
clickhouse_cloud.invitations.listList all invitationsList all invitations.readidentity.invitation.list33 connectors
clickhouse_cloud.services.listList of organization servicesList of organization services.readinfra.database_instance.list5 connectors

Try it

Prompts to paste into Claude.

Each one names the ClickHouse Cloud actions it will call, so you know what it reads and what it changes before you send it.

  1. Readread

    Who has access in ClickHouse Cloud? List every user and their role.

    callsclickhouse_cloud.members.list

  2. Writewrite

    Create a new role in ClickHouse Cloud. Show me exactly what you will send before you save it.

    callsclickhouse_cloud.roles.create

Governance for ClickHouse Cloud

Destructive actions wait for a yes.

27 ClickHouse Cloud actions are destructive. These are all of them:

  • Remove an organization memberclickhouse_cloud.members.delete
  • Delete a roleclickhouse_cloud.roles.delete
  • Delete keyclickhouse_cloud.keys.delete
  • Delete organization invitationclickhouse_cloud.invitations.delete
  • Delete serviceclickhouse_cloud.services.delete
  • ClickStack: Delete Dashboardclickhouse_cloud.service_clickstack_dashboards.delete
  • Delete UDFclickhouse_cloud.udfs.delete
  • Delete a PostgreSQL serviceclickhouse_cloud.postgres.delete
  • Delete UDF versionclickhouse_cloud.udf_versions.delete
  • Detach UDF from serviceclickhouse_cloud.udf_attachments.delete
  • Update service passwordclickhouse_cloud.service_password.update
  • Update Postgres superuser passwordclickhouse_cloud.postgres_password.update
  • Delete ClickPipeclickhouse_cloud.service_clickpipes.delete
  • Remove a BYOC infrastructureclickhouse_cloud.byoc_infrastructure.delete
  • Delete service backup bucketclickhouse_cloud.service_backup_bucket.delete
  • Delete a saved queryclickhouse_cloud.service_saved_queries.delete
  • Delete the service query endpoint for a given instanceclickhouse_cloud.service_query_endpoint.delete
  • Delete service upgrade windowclickhouse_cloud.service_upgrade_window.delete
  • ClickStack: Delete Roleclickhouse_cloud.service_clickstack_roles.delete
  • Delete service scheduled scalingclickhouse_cloud.service_scaling_schedule.delete
  • ClickStack: Delete Alertclickhouse_cloud.service_clickstack_alerts.delete
  • ClickStack: Delete Sourceclickhouse_cloud.service_clickstack_sources.delete
  • Reset ClickHouse setting to defaultclickhouse_cloud.service_clickhouse_settings.delete
  • ClickStack: Delete Webhookclickhouse_cloud.service_clickstack_webhooks.delete
  • Delete a Query API endpointclickhouse_cloud.service_query_api_endpoints.delete
  • ClickStack: Delete Saved Searchclickhouse_cloud.service_clickstack_saved_searches.delete
  • Delete reverse private endpointclickhouse_cloud.service_clickpipes_reverse_private_endpoints.delete

A destructive action runs only with confirm: true. Under the human policy the agent cannot confirm for itself: the run stops until a named person approves, in the console or from a signed link in an email. The cap on a key is refused before the call is sent, never after.

doclickhouse_cloud.members.deleteconfirm_policy: human

Remove an organization member?

intent: the user asked me to remove an organization member

run suspended · waiting for a named person · key clickhouse-cloud-agent cannot confirm itself
In the console, or from an emailed signed link.
a key for this connector
account {  op: "keys.create", name: "clickhouse-cloud-agent",  allowed_actions: ["clickhouse_cloud.*"], cap_calls: 2000,  confirm_policy: "human_for_writes",  approval_rules: [    { match: "clickhouse_cloud.members.delete", approver: "[email protected]" },    { match: "clickhouse_cloud.roles.delete", approver: "[email protected]" },    { match: "clickhouse_cloud.keys.delete", approver: "[email protected]" }  ]}
Illustrative. Scoped to ClickHouse Cloud only, capped at 2,000 upstream calls, every write confirmed, and the destructive ones approved by a named person.

Cost

What ClickHouse Cloud costs on actionlake.

Every ClickHouse Cloud action is one upstream call, the only thing actionlake bills. Searching, check, cost, account and any call ClickHouse Cloud refused with 401, 403, 429 or a 5xx are free. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.

  • 1upstream call per actionall 169 ClickHouse Cloud actions
  • 169actions pageeach page of a long list is one call
  • 75reads can be cacheda cache hit costs nothing
  • 100,000calls a month, freepaid plans from US$49 a month for 250,000

See pricing

Action index

Every ClickHouse Cloud action.

169 actions by area: the id your agent calls, what it does, and its effect.

Service clickpipes7
  • clickhouse_cloud.service_clickpipes.createCreate ClickPipewrite
  • clickhouse_cloud.service_clickpipes.deleteDelete ClickPipedestructive
  • clickhouse_cloud.service_clickpipes.discover_schemaDiscover ClickPipe source schemaread
  • clickhouse_cloud.service_clickpipes.getGet ClickPiperead
  • clickhouse_cloud.service_clickpipes.get_contextGet ClickPipes service contextread
  • clickhouse_cloud.service_clickpipes.listList ClickPipesread
  • clickhouse_cloud.service_clickpipes.updateUpdate ClickPipewrite
Service clickstack dashboards6
  • clickhouse_cloud.service_clickstack_dashboards.createClickStack: Create Dashboardwrite
  • clickhouse_cloud.service_clickstack_dashboards.deleteClickStack: Delete Dashboarddestructive
  • clickhouse_cloud.service_clickstack_dashboards.getClickStack: Get Dashboardread
  • clickhouse_cloud.service_clickstack_dashboards.listClickStack: List Dashboardsread
  • clickhouse_cloud.service_clickstack_dashboards.updateClickStack: Update Dashboardwrite
  • clickhouse_cloud.service_clickstack_dashboards.validateClickStack: Validate Dashboardread
Byoc infrastructure5
  • clickhouse_cloud.byoc_infrastructure.createCreate BYOC Infrastructurewrite
  • clickhouse_cloud.byoc_infrastructure.deleteRemove a BYOC infrastructuredestructive
  • clickhouse_cloud.byoc_infrastructure.getGet BYOC infrastructure detailsread
  • clickhouse_cloud.byoc_infrastructure.updateUpdate BYOC Infrastructurewrite
  • clickhouse_cloud.byoc_infrastructure.validateValidate BYOC infrastructure prerequisitesread
Keys5
  • clickhouse_cloud.keys.createCreate keywrite
  • clickhouse_cloud.keys.deleteDelete keydestructive
  • clickhouse_cloud.keys.getGet key detailsread
  • clickhouse_cloud.keys.listGet list of keysread
  • clickhouse_cloud.keys.updateUpdate keywrite
Postgres5
  • clickhouse_cloud.postgres.createCreate new Postgres servicewrite
  • clickhouse_cloud.postgres.deleteDelete a PostgreSQL servicedestructive
  • clickhouse_cloud.postgres.getGet PostgreSQL service detailsread
  • clickhouse_cloud.postgres.listList of organization Postgres servicesread
  • clickhouse_cloud.postgres.updateUpdate a PostgreSQL servicewrite
Roles5
  • clickhouse_cloud.roles.createCreate a new rolewrite
  • clickhouse_cloud.roles.deleteDelete a roledestructive
  • clickhouse_cloud.roles.getGet role detailsread
  • clickhouse_cloud.roles.listList all available roles for an organizationread
  • clickhouse_cloud.roles.updateUpdate a rolewrite
Service clickhouse settings5
  • clickhouse_cloud.service_clickhouse_settings.deleteReset ClickHouse setting to defaultdestructive
  • clickhouse_cloud.service_clickhouse_settings.getGet ClickHouse settingread
  • clickhouse_cloud.service_clickhouse_settings.get_allList ClickHouse settingsread
  • clickhouse_cloud.service_clickhouse_settings.get_schemaGet ClickHouse settings schemaread
  • clickhouse_cloud.service_clickhouse_settings.update_manyUpdate ClickHouse settingswrite
Service clickpipes reverse private endpoints5
  • clickhouse_cloud.service_clickpipes_reverse_private_endpoints.createCreate reverse private endpointwrite
  • clickhouse_cloud.service_clickpipes_reverse_private_endpoints.deleteDelete reverse private endpointdestructive
  • clickhouse_cloud.service_clickpipes_reverse_private_endpoints.getGet reverse private endpointread
  • clickhouse_cloud.service_clickpipes_reverse_private_endpoints.listList reverse private endpointsread
  • clickhouse_cloud.service_clickpipes_reverse_private_endpoints.updateUpdate reverse private endpointwrite
Service clickstack alerts5
  • clickhouse_cloud.service_clickstack_alerts.createClickStack: Create Alertwrite
  • clickhouse_cloud.service_clickstack_alerts.deleteClickStack: Delete Alertdestructive
  • clickhouse_cloud.service_clickstack_alerts.getClickStack: Get Alertread
  • clickhouse_cloud.service_clickstack_alerts.listClickStack: List Alertsread
  • clickhouse_cloud.service_clickstack_alerts.updateClickStack: Update Alertwrite
Service clickstack roles5
  • clickhouse_cloud.service_clickstack_roles.createClickStack: Create Rolewrite
  • clickhouse_cloud.service_clickstack_roles.deleteClickStack: Delete Roledestructive
  • clickhouse_cloud.service_clickstack_roles.getClickStack: Get Roleread
  • clickhouse_cloud.service_clickstack_roles.listClickStack: List Rolesread
  • clickhouse_cloud.service_clickstack_roles.updateClickStack: Update Rolewrite
Service clickstack saved searches5
  • clickhouse_cloud.service_clickstack_saved_searches.createClickStack: Create Saved Searchwrite
  • clickhouse_cloud.service_clickstack_saved_searches.deleteClickStack: Delete Saved Searchdestructive
  • clickhouse_cloud.service_clickstack_saved_searches.getClickStack: Get Saved Searchread
  • clickhouse_cloud.service_clickstack_saved_searches.listClickStack: List Saved Searchesread
  • clickhouse_cloud.service_clickstack_saved_searches.updateClickStack: Update Saved Searchwrite
Service clickstack sources5
  • clickhouse_cloud.service_clickstack_sources.createClickStack: Create Sourcewrite
  • clickhouse_cloud.service_clickstack_sources.deleteClickStack: Delete Sourcedestructive
  • clickhouse_cloud.service_clickstack_sources.getClickStack: Get Sourceread
  • clickhouse_cloud.service_clickstack_sources.listClickStack: List Sourcesread
  • clickhouse_cloud.service_clickstack_sources.updateClickStack: Update Sourcewrite
Service clickstack webhooks5
  • clickhouse_cloud.service_clickstack_webhooks.createClickStack: Create Webhookwrite
  • clickhouse_cloud.service_clickstack_webhooks.deleteClickStack: Delete Webhookdestructive
  • clickhouse_cloud.service_clickstack_webhooks.listClickStack: List Webhooksread
  • clickhouse_cloud.service_clickstack_webhooks.updateClickStack: Update Webhookwrite
  • clickhouse_cloud.service_clickstack_webhooks.validateClickStack: Validate Webhookread
Service query API endpoints5
  • clickhouse_cloud.service_query_api_endpoints.createCreate a Query API endpointwrite
  • clickhouse_cloud.service_query_api_endpoints.deleteDelete a Query API endpointdestructive
  • clickhouse_cloud.service_query_api_endpoints.getGet a Query API endpointread
  • clickhouse_cloud.service_query_api_endpoints.listList Query API endpointsread
  • clickhouse_cloud.service_query_api_endpoints.updateUpdate a Query API endpointwrite
Service saved queries5
  • clickhouse_cloud.service_saved_queries.createCreate a saved querywrite
  • clickhouse_cloud.service_saved_queries.deleteDelete a saved querydestructive
  • clickhouse_cloud.service_saved_queries.getGet a saved queryread
  • clickhouse_cloud.service_saved_queries.listList saved queriesread
  • clickhouse_cloud.service_saved_queries.updateUpdate a saved querywrite
Services5
  • clickhouse_cloud.services.createCreate new servicewrite
  • clickhouse_cloud.services.deleteDelete servicedestructive
  • clickhouse_cloud.services.getGet service detailsread
  • clickhouse_cloud.services.listList of organization servicesread
  • clickhouse_cloud.services.updateUpdate service basic detailswrite
Invitations4
  • clickhouse_cloud.invitations.createCreate an invitationwrite
  • clickhouse_cloud.invitations.deleteDelete organization invitationdestructive
  • clickhouse_cloud.invitations.getGet invitation detailsread
  • clickhouse_cloud.invitations.listList all invitationsread
Members4
  • clickhouse_cloud.members.deleteRemove an organization memberdestructive
  • clickhouse_cloud.members.getGet member detailsread
  • clickhouse_cloud.members.listList organization membersread
  • clickhouse_cloud.members.updateUpdate organization memberwrite
Service backup bucket4
  • clickhouse_cloud.service_backup_bucket.createCreate service backup bucketwrite
  • clickhouse_cloud.service_backup_bucket.deleteDelete service backup bucketdestructive
  • clickhouse_cloud.service_backup_bucket.getGet service backup bucketread
  • clickhouse_cloud.service_backup_bucket.updateUpdate service backup bucketwrite
Udf attachments4
  • clickhouse_cloud.udf_attachments.attachAttach UDF to servicewrite
  • clickhouse_cloud.udf_attachments.deleteDetach UDF from servicedestructive
  • clickhouse_cloud.udf_attachments.getGet UDF attachmentread
  • clickhouse_cloud.udf_attachments.listList UDF attachmentsread
Udfs4
  • clickhouse_cloud.udfs.createCreate UDFwrite
  • clickhouse_cloud.udfs.deleteDelete UDFdestructive
  • clickhouse_cloud.udfs.getGet UDFread
  • clickhouse_cloud.udfs.listList UDFsread
Organizations3
  • clickhouse_cloud.organizations.getGet organization detailsread
  • clickhouse_cloud.organizations.listGet list of available organizationsread
  • clickhouse_cloud.organizations.updateUpdate organization detailswrite
Postgres config3
  • clickhouse_cloud.postgres_config.getGet PostgreSQL service configurationread
  • clickhouse_cloud.postgres_config.replaceReplace Postgres service configurationwrite
  • clickhouse_cloud.postgres_config.updateUpdate Postgres service configurationwrite
Service query endpoint3
  • clickhouse_cloud.service_query_endpoint.createUpsert the service query endpoint for a given instancewrite
  • clickhouse_cloud.service_query_endpoint.deleteDelete the service query endpoint for a given instancedestructive
  • clickhouse_cloud.service_query_endpoint.getGet the service query endpoint for a given instanceread
Service scaling schedule3
  • clickhouse_cloud.service_scaling_schedule.createCreate or replace service autoscaling schedulewrite
  • clickhouse_cloud.service_scaling_schedule.deleteDelete service scheduled scalingdestructive
  • clickhouse_cloud.service_scaling_schedule.getGet service autoscaling scheduleread
Service upgrade window3
  • clickhouse_cloud.service_upgrade_window.deleteDelete service upgrade windowdestructive
  • clickhouse_cloud.service_upgrade_window.getGet service upgrade windowread
  • clickhouse_cloud.service_upgrade_window.updateSet service upgrade windowwrite
Udf versions3
  • clickhouse_cloud.udf_versions.createCreate UDF versionwrite
  • clickhouse_cloud.udf_versions.deleteDelete UDF versiondestructive
  • clickhouse_cloud.udf_versions.listList UDF versionsread
Activities2
  • clickhouse_cloud.activities.getOrganization activityread
  • clickhouse_cloud.activities.listList of organization activitiesread
Postgres slow query patterns2
  • clickhouse_cloud.postgres_slow_query_patterns.getGet a Postgres slow query pattern with recent executionsread
  • clickhouse_cloud.postgres_slow_query_patterns.listList Postgres slow query patternsread
Quotas2
  • clickhouse_cloud.quotas.getGet organization quota detailsread
  • clickhouse_cloud.quotas.listGet organization quotasread
Service backup configuration2
  • clickhouse_cloud.service_backup_configuration.getGet service backup configurationread
  • clickhouse_cloud.service_backup_configuration.updateUpdate service backup configurationwrite
Service backups2
  • clickhouse_cloud.service_backups.getGet backup detailsread
  • clickhouse_cloud.service_backups.listList of service backupsread
Service clickpipe settings2
  • clickhouse_cloud.service_clickpipe_settings.getGet ClickPipe settingsread
  • clickhouse_cloud.service_clickpipe_settings.updateUpdate ClickPipe settingswrite
Service clickpipes CDC scaling2
  • clickhouse_cloud.service_clickpipes_cdc_scaling.getGet CDC ClickPipes scalingread
  • clickhouse_cloud.service_clickpipes_cdc_scaling.updateUpdate CDC ClickPipes scalingwrite
Service replica aware routing2
  • clickhouse_cloud.service_replica_aware_routing.getGet replica aware routingread
  • clickhouse_cloud.service_replica_aware_routing.updateUpdate replica aware routingwrite
Service snapshot configuration2
  • clickhouse_cloud.service_snapshot_configuration.getGet service snapshot configurationread
  • clickhouse_cloud.service_snapshot_configuration.updateUpdate service snapshot configurationwrite
Service snapshots2
  • clickhouse_cloud.service_snapshots.getGet snapshot detailsread
  • clickhouse_cloud.service_snapshots.listList of service snapshotsread
Active balances1
  • clickhouse_cloud.active_balances.getGet organization active prepaid balancesread
Byoc infrastructure private endpoint config1
  • clickhouse_cloud.byoc_infrastructure_private_endpoint_config.getGet BYOC infrastructure private endpoint configurationread
Byoc infrastructure progress1
  • clickhouse_cloud.byoc_infrastructure_progress.getGet BYOC infrastructure provisioning progressread
Byoc infrastructure tags1
  • clickhouse_cloud.byoc_infrastructure_tags.getGet BYOC infrastructure tagsread
Credit balances1
  • clickhouse_cloud.credit_balances.getGet organization active credit balancesread
Notification types1
  • clickhouse_cloud.notification_types.listList notification typesread
Notifications1
  • clickhouse_cloud.notifications.listList of organization notificationsread
Postgres backups1
  • clickhouse_cloud.postgres_backups.listList of Postgres service backupsread
Postgres logs1
  • clickhouse_cloud.postgres_logs.listList Postgres server logsread
Postgres metrics1
  • clickhouse_cloud.postgres_metrics.getGet Postgres time-series metricsread
Postgres password1
  • clickhouse_cloud.postgres_password.updateUpdate Postgres superuser passworddestructive
Postgres read replica1
  • clickhouse_cloud.postgres_read_replica.createCreate a read replica for a Postgres servicewrite
Postgres restored service1
  • clickhouse_cloud.postgres_restored_service.createRestore a Postgres servicewrite
Postgres state1
  • clickhouse_cloud.postgres_state.updateUpdate Postgres service statewrite
Private endpoint config1
  • clickhouse_cloud.private_endpoint_config.getGet private endpoint configuration for region within cloud provider for an organizationread
Prometheus discovery1
  • clickhouse_cloud.prometheus_discovery.getGet Prometheus service discovery targetsread
Service clickpipe scaling1
  • clickhouse_cloud.service_clickpipe_scaling.updateUpdate ClickPipe scalingwrite
Service clickpipe state1
  • clickhouse_cloud.service_clickpipe_state.updateUpdate ClickPipe statewrite
Service password1
  • clickhouse_cloud.service_password.updateUpdate service passworddestructive
Service private endpoint1
  • clickhouse_cloud.service_private_endpoint.createCreate a private endpointwrite
Service private endpoint config1
  • clickhouse_cloud.service_private_endpoint_config.getGet private endpoint configurationread
Service profiles1
  • clickhouse_cloud.service_profiles.listList available service profilesread
Service replica scaling1
  • clickhouse_cloud.service_replica_scaling.updateUpdate service auto scaling settingswrite
Service scaling1
  • clickhouse_cloud.service_scaling.updateUpdate service auto scaling settingswrite
Service state1
  • clickhouse_cloud.service_state.updateUpdate service statewrite
Udf uploads1
  • clickhouse_cloud.udf_uploads.create_urlCreate UDF upload URLwrite
Usage cost1
  • clickhouse_cloud.usage_cost.getGet organization usage costsread
Whoami1
  • clickhouse_cloud.whoami.getResolve the caller identityread

Questions

The ClickHouse Cloud MCP server, answered.

Is there a ClickHouse Cloud MCP server for Claude?

Yes. actionlake is an MCP gateway: a remote MCP server that gives Claude, or another MCP client, 169 ClickHouse Cloud actions across service clickpipes, service clickstack dashboards, byoc infrastructure and keys, through the same eight tools it uses for every other connector. actionlake is independent; it is not made or endorsed by ClickHouse Cloud.

What do I need to connect ClickHouse Cloud?

ClickHouse Cloud API key ID and ClickHouse Cloud API key secret, shown once when the key is created. The free call account { op: "connections.requirements", service: "clickhouse_cloud" } lists exactly what to paste.

Can an AI agent delete or change things in ClickHouse Cloud?

Only if its key allows it, and only with an explicit confirmation. 27 ClickHouse Cloud actions are destructive, including remove an organization member, delete a role and delete key. Each runs only with confirm: true. Under the human confirm policy, or an approval rule on the key, the run waits until a named person approves it.

Will an AI agent use up my ClickHouse Cloud API limit?

actionlake paces every call to the limits in the ClickHouse Cloud service file: 10 calls per 10 seconds per connection. Repeated reads are answered from cache (75 ClickHouse Cloud actions can be), which never reaches ClickHouse Cloud.

What does a ClickHouse Cloud action cost?

One upstream call, the only unit actionlake bills. A list that pages bills one call per page (169 ClickHouse Cloud actions page). Cache hits, searches, dry runs and calls ClickHouse Cloud refused with 401, 403, 429 or a 5xx are free. The Free plan includes 100,000 calls a month with no card. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.

Which ClickHouse Cloud API does it cover?

The ClickHouse Cloud API v1 (OpenAPI 3.1.1, 174 operations) at api.clickhouse.cloud. It is built from ClickHouse Cloud's documentation as read on 22 October 2026. 169 actions in 65 areas, each one in the signed service file (version 1.0.0).

Does actionlake keep my ClickHouse Cloud data, and where?

actionlake processes and stores data in Sydney, Australia; there is no US region yet. Reads may be cached for up to 5 minutes, and a write clears the reads it affects. Each run's request and response is kept, sealed, for your plan's trace window: 1 day on Free, 3 days on Starter, 7 days on Pro, 14 days on Team, 30 days on Business and 30 days on Enterprise. Your ClickHouse Cloud credential is sealed under your tenant's key, never logged and never returned. Your traffic is not used to train models.

Which AI clients can use it?

Claude Code, tested by us end to end, and the Claude app as a custom connector, tested by us with an existing key. Other MCP clients that support remote servers over Streamable HTTP (MCP revisions 2025-06-18 and 2025-11-25) and OAuth dynamic client registration, or a bearer header, should connect the same way; we have not tested them. Or plain REST, under the same action names.

Give your agent ClickHouse Cloud today.

Start free - 100,000 calls/month, no card. No signup. Hard caps on every key. Cached answers are free.