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/mcpdo { 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.
- 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 - 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 IDkey_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 - 03
Make the first call. Check before a write.
Ask in plain words; Claude picks the action. Before anything changes,
checkvalidates 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
Service clickpipes
74 read · 2 write · 1 destructive
Create ClickPipe · Discover ClickPipe source schema · List ClickPipes · Get ClickPipe
Service clickstack dashboards
63 read · 2 write · 1 destructive
ClickStack: List Dashboards · ClickStack: Create Dashboard · ClickStack: Get Dashboard · ClickStack: Update Dashboard
Byoc infrastructure
52 read · 2 write · 1 destructive
Create BYOC Infrastructure · Validate BYOC infrastructure prerequisites · Get BYOC infrastructure details · Update BYOC Infrastructure
Keys
52 read · 2 write · 1 destructive
Create key · Get list of keys · Get key details · Delete key
Postgres
52 read · 2 write · 1 destructive
Create new Postgres service · List of organization Postgres services · Get PostgreSQL service details · Update a PostgreSQL service
Roles
52 read · 2 write · 1 destructive
List all available roles for an organization · Create a new role · Get role details · Update a role
Service clickhouse settings
53 read · 1 write · 1 destructive
Get ClickHouse setting · List ClickHouse settings · Get ClickHouse settings schema · Update ClickHouse settings
Service clickpipes reverse private endpoints
52 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.
| Action | What it does | Effect | Same name in |
|---|---|---|---|
clickhouse_cloud.members.listList organization members | List organization members. | read | identity.user.list474 connectors |
clickhouse_cloud.roles.listList all available roles for an organization | List all available roles for an organization. | read | identity.role.list184 connectors |
clickhouse_cloud.members.getGet member details | Get member details. | read | identity.user.get399 connectors |
clickhouse_cloud.roles.createCreate a new role | Create a new role. | write | identity.role.create105 connectors |
clickhouse_cloud.members.deleteRemove an organization member | Remove an organization member. | destructive | identity.user.delete253 connectors |
clickhouse_cloud.whoami.getResolve the caller identity | Resolve the caller identity. | read | identity.current_user.get307 connectors |
clickhouse_cloud.keys.createCreate key | Create key. | write | identity.api_key.create100 connectors |
clickhouse_cloud.keys.listGet list of keys | Get list of keys. | read | identity.api_key.list96 connectors |
clickhouse_cloud.activities.listList of organization activities | List of organization activities. | read | identity.audit_event.list51 connectors |
clickhouse_cloud.invitations.createCreate an invitation | Create an invitation. | write | identity.invitation.create41 connectors |
clickhouse_cloud.invitations.listList all invitations | List all invitations. | read | identity.invitation.list33 connectors |
clickhouse_cloud.services.listList of organization services | List of organization services. | read | infra.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.
- Readread
Who has access in ClickHouse Cloud? List every user and their role.
calls
clickhouse_cloud.members.list - Writewrite
Create a new role in ClickHouse Cloud. Show me exactly what you will send before you save it.
calls
clickhouse_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 member
clickhouse_cloud.members.delete - Delete a role
clickhouse_cloud.roles.delete - Delete key
clickhouse_cloud.keys.delete - Delete organization invitation
clickhouse_cloud.invitations.delete - Delete service
clickhouse_cloud.services.delete - ClickStack: Delete Dashboard
clickhouse_cloud.service_clickstack_dashboards.delete - Delete UDF
clickhouse_cloud.udfs.delete - Delete a PostgreSQL service
clickhouse_cloud.postgres.delete - Delete UDF version
clickhouse_cloud.udf_versions.delete - Detach UDF from service
clickhouse_cloud.udf_attachments.delete - Update service password
clickhouse_cloud.service_password.update - Update Postgres superuser password
clickhouse_cloud.postgres_password.update - Delete ClickPipe
clickhouse_cloud.service_clickpipes.delete - Remove a BYOC infrastructure
clickhouse_cloud.byoc_infrastructure.delete - Delete service backup bucket
clickhouse_cloud.service_backup_bucket.delete - Delete a saved query
clickhouse_cloud.service_saved_queries.delete - Delete the service query endpoint for a given instance
clickhouse_cloud.service_query_endpoint.delete - Delete service upgrade window
clickhouse_cloud.service_upgrade_window.delete - ClickStack: Delete Role
clickhouse_cloud.service_clickstack_roles.delete - Delete service scheduled scaling
clickhouse_cloud.service_scaling_schedule.delete - ClickStack: Delete Alert
clickhouse_cloud.service_clickstack_alerts.delete - ClickStack: Delete Source
clickhouse_cloud.service_clickstack_sources.delete - Reset ClickHouse setting to default
clickhouse_cloud.service_clickhouse_settings.delete - ClickStack: Delete Webhook
clickhouse_cloud.service_clickstack_webhooks.delete - Delete a Query API endpoint
clickhouse_cloud.service_query_api_endpoints.delete - ClickStack: Delete Saved Search
clickhouse_cloud.service_clickstack_saved_searches.delete - Delete reverse private endpoint
clickhouse_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.
Remove an organization member?
intent: the user asked me to remove an organization member
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]" } ]}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
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 ClickPipewriteclickhouse_cloud.service_clickpipes.deleteDelete ClickPipedestructiveclickhouse_cloud.service_clickpipes.discover_schemaDiscover ClickPipe source schemareadclickhouse_cloud.service_clickpipes.getGet ClickPipereadclickhouse_cloud.service_clickpipes.get_contextGet ClickPipes service contextreadclickhouse_cloud.service_clickpipes.listList ClickPipesreadclickhouse_cloud.service_clickpipes.updateUpdate ClickPipewrite
Service clickstack dashboards6
clickhouse_cloud.service_clickstack_dashboards.createClickStack: Create Dashboardwriteclickhouse_cloud.service_clickstack_dashboards.deleteClickStack: Delete Dashboarddestructiveclickhouse_cloud.service_clickstack_dashboards.getClickStack: Get Dashboardreadclickhouse_cloud.service_clickstack_dashboards.listClickStack: List Dashboardsreadclickhouse_cloud.service_clickstack_dashboards.updateClickStack: Update Dashboardwriteclickhouse_cloud.service_clickstack_dashboards.validateClickStack: Validate Dashboardread
Byoc infrastructure5
clickhouse_cloud.byoc_infrastructure.createCreate BYOC Infrastructurewriteclickhouse_cloud.byoc_infrastructure.deleteRemove a BYOC infrastructuredestructiveclickhouse_cloud.byoc_infrastructure.getGet BYOC infrastructure detailsreadclickhouse_cloud.byoc_infrastructure.updateUpdate BYOC Infrastructurewriteclickhouse_cloud.byoc_infrastructure.validateValidate BYOC infrastructure prerequisitesread
Keys5
clickhouse_cloud.keys.createCreate keywriteclickhouse_cloud.keys.deleteDelete keydestructiveclickhouse_cloud.keys.getGet key detailsreadclickhouse_cloud.keys.listGet list of keysreadclickhouse_cloud.keys.updateUpdate keywrite
Postgres5
clickhouse_cloud.postgres.createCreate new Postgres servicewriteclickhouse_cloud.postgres.deleteDelete a PostgreSQL servicedestructiveclickhouse_cloud.postgres.getGet PostgreSQL service detailsreadclickhouse_cloud.postgres.listList of organization Postgres servicesreadclickhouse_cloud.postgres.updateUpdate a PostgreSQL servicewrite
Roles5
clickhouse_cloud.roles.createCreate a new rolewriteclickhouse_cloud.roles.deleteDelete a roledestructiveclickhouse_cloud.roles.getGet role detailsreadclickhouse_cloud.roles.listList all available roles for an organizationreadclickhouse_cloud.roles.updateUpdate a rolewrite
Service clickhouse settings5
clickhouse_cloud.service_clickhouse_settings.deleteReset ClickHouse setting to defaultdestructiveclickhouse_cloud.service_clickhouse_settings.getGet ClickHouse settingreadclickhouse_cloud.service_clickhouse_settings.get_allList ClickHouse settingsreadclickhouse_cloud.service_clickhouse_settings.get_schemaGet ClickHouse settings schemareadclickhouse_cloud.service_clickhouse_settings.update_manyUpdate ClickHouse settingswrite
Service clickpipes reverse private endpoints5
clickhouse_cloud.service_clickpipes_reverse_private_endpoints.createCreate reverse private endpointwriteclickhouse_cloud.service_clickpipes_reverse_private_endpoints.deleteDelete reverse private endpointdestructiveclickhouse_cloud.service_clickpipes_reverse_private_endpoints.getGet reverse private endpointreadclickhouse_cloud.service_clickpipes_reverse_private_endpoints.listList reverse private endpointsreadclickhouse_cloud.service_clickpipes_reverse_private_endpoints.updateUpdate reverse private endpointwrite
Service clickstack alerts5
clickhouse_cloud.service_clickstack_alerts.createClickStack: Create Alertwriteclickhouse_cloud.service_clickstack_alerts.deleteClickStack: Delete Alertdestructiveclickhouse_cloud.service_clickstack_alerts.getClickStack: Get Alertreadclickhouse_cloud.service_clickstack_alerts.listClickStack: List Alertsreadclickhouse_cloud.service_clickstack_alerts.updateClickStack: Update Alertwrite
Service clickstack roles5
clickhouse_cloud.service_clickstack_roles.createClickStack: Create Rolewriteclickhouse_cloud.service_clickstack_roles.deleteClickStack: Delete Roledestructiveclickhouse_cloud.service_clickstack_roles.getClickStack: Get Rolereadclickhouse_cloud.service_clickstack_roles.listClickStack: List Rolesreadclickhouse_cloud.service_clickstack_roles.updateClickStack: Update Rolewrite
Service clickstack saved searches5
clickhouse_cloud.service_clickstack_saved_searches.createClickStack: Create Saved Searchwriteclickhouse_cloud.service_clickstack_saved_searches.deleteClickStack: Delete Saved Searchdestructiveclickhouse_cloud.service_clickstack_saved_searches.getClickStack: Get Saved Searchreadclickhouse_cloud.service_clickstack_saved_searches.listClickStack: List Saved Searchesreadclickhouse_cloud.service_clickstack_saved_searches.updateClickStack: Update Saved Searchwrite
Service clickstack sources5
clickhouse_cloud.service_clickstack_sources.createClickStack: Create Sourcewriteclickhouse_cloud.service_clickstack_sources.deleteClickStack: Delete Sourcedestructiveclickhouse_cloud.service_clickstack_sources.getClickStack: Get Sourcereadclickhouse_cloud.service_clickstack_sources.listClickStack: List Sourcesreadclickhouse_cloud.service_clickstack_sources.updateClickStack: Update Sourcewrite
Service clickstack webhooks5
clickhouse_cloud.service_clickstack_webhooks.createClickStack: Create Webhookwriteclickhouse_cloud.service_clickstack_webhooks.deleteClickStack: Delete Webhookdestructiveclickhouse_cloud.service_clickstack_webhooks.listClickStack: List Webhooksreadclickhouse_cloud.service_clickstack_webhooks.updateClickStack: Update Webhookwriteclickhouse_cloud.service_clickstack_webhooks.validateClickStack: Validate Webhookread
Service query API endpoints5
clickhouse_cloud.service_query_api_endpoints.createCreate a Query API endpointwriteclickhouse_cloud.service_query_api_endpoints.deleteDelete a Query API endpointdestructiveclickhouse_cloud.service_query_api_endpoints.getGet a Query API endpointreadclickhouse_cloud.service_query_api_endpoints.listList Query API endpointsreadclickhouse_cloud.service_query_api_endpoints.updateUpdate a Query API endpointwrite
Service saved queries5
clickhouse_cloud.service_saved_queries.createCreate a saved querywriteclickhouse_cloud.service_saved_queries.deleteDelete a saved querydestructiveclickhouse_cloud.service_saved_queries.getGet a saved queryreadclickhouse_cloud.service_saved_queries.listList saved queriesreadclickhouse_cloud.service_saved_queries.updateUpdate a saved querywrite
Services5
clickhouse_cloud.services.createCreate new servicewriteclickhouse_cloud.services.deleteDelete servicedestructiveclickhouse_cloud.services.getGet service detailsreadclickhouse_cloud.services.listList of organization servicesreadclickhouse_cloud.services.updateUpdate service basic detailswrite
Invitations4
clickhouse_cloud.invitations.createCreate an invitationwriteclickhouse_cloud.invitations.deleteDelete organization invitationdestructiveclickhouse_cloud.invitations.getGet invitation detailsreadclickhouse_cloud.invitations.listList all invitationsread
Members4
clickhouse_cloud.members.deleteRemove an organization memberdestructiveclickhouse_cloud.members.getGet member detailsreadclickhouse_cloud.members.listList organization membersreadclickhouse_cloud.members.updateUpdate organization memberwrite
Service backup bucket4
clickhouse_cloud.service_backup_bucket.createCreate service backup bucketwriteclickhouse_cloud.service_backup_bucket.deleteDelete service backup bucketdestructiveclickhouse_cloud.service_backup_bucket.getGet service backup bucketreadclickhouse_cloud.service_backup_bucket.updateUpdate service backup bucketwrite
Udf attachments4
clickhouse_cloud.udf_attachments.attachAttach UDF to servicewriteclickhouse_cloud.udf_attachments.deleteDetach UDF from servicedestructiveclickhouse_cloud.udf_attachments.getGet UDF attachmentreadclickhouse_cloud.udf_attachments.listList UDF attachmentsread
Udfs4
clickhouse_cloud.udfs.createCreate UDFwriteclickhouse_cloud.udfs.deleteDelete UDFdestructiveclickhouse_cloud.udfs.getGet UDFreadclickhouse_cloud.udfs.listList UDFsread
Organizations3
clickhouse_cloud.organizations.getGet organization detailsreadclickhouse_cloud.organizations.listGet list of available organizationsreadclickhouse_cloud.organizations.updateUpdate organization detailswrite
Postgres config3
clickhouse_cloud.postgres_config.getGet PostgreSQL service configurationreadclickhouse_cloud.postgres_config.replaceReplace Postgres service configurationwriteclickhouse_cloud.postgres_config.updateUpdate Postgres service configurationwrite
Service query endpoint3
clickhouse_cloud.service_query_endpoint.createUpsert the service query endpoint for a given instancewriteclickhouse_cloud.service_query_endpoint.deleteDelete the service query endpoint for a given instancedestructiveclickhouse_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 schedulewriteclickhouse_cloud.service_scaling_schedule.deleteDelete service scheduled scalingdestructiveclickhouse_cloud.service_scaling_schedule.getGet service autoscaling scheduleread
Service upgrade window3
clickhouse_cloud.service_upgrade_window.deleteDelete service upgrade windowdestructiveclickhouse_cloud.service_upgrade_window.getGet service upgrade windowreadclickhouse_cloud.service_upgrade_window.updateSet service upgrade windowwrite
Udf versions3
clickhouse_cloud.udf_versions.createCreate UDF versionwriteclickhouse_cloud.udf_versions.deleteDelete UDF versiondestructiveclickhouse_cloud.udf_versions.listList UDF versionsread
Activities2
clickhouse_cloud.activities.getOrganization activityreadclickhouse_cloud.activities.listList of organization activitiesread
Postgres slow query patterns2
clickhouse_cloud.postgres_slow_query_patterns.getGet a Postgres slow query pattern with recent executionsreadclickhouse_cloud.postgres_slow_query_patterns.listList Postgres slow query patternsread
Quotas2
clickhouse_cloud.quotas.getGet organization quota detailsreadclickhouse_cloud.quotas.listGet organization quotasread
Service backup configuration2
clickhouse_cloud.service_backup_configuration.getGet service backup configurationreadclickhouse_cloud.service_backup_configuration.updateUpdate service backup configurationwrite
Service backups2
clickhouse_cloud.service_backups.getGet backup detailsreadclickhouse_cloud.service_backups.listList of service backupsread
Service clickpipe settings2
clickhouse_cloud.service_clickpipe_settings.getGet ClickPipe settingsreadclickhouse_cloud.service_clickpipe_settings.updateUpdate ClickPipe settingswrite
Service clickpipes CDC scaling2
clickhouse_cloud.service_clickpipes_cdc_scaling.getGet CDC ClickPipes scalingreadclickhouse_cloud.service_clickpipes_cdc_scaling.updateUpdate CDC ClickPipes scalingwrite
Service replica aware routing2
clickhouse_cloud.service_replica_aware_routing.getGet replica aware routingreadclickhouse_cloud.service_replica_aware_routing.updateUpdate replica aware routingwrite
Service snapshot configuration2
clickhouse_cloud.service_snapshot_configuration.getGet service snapshot configurationreadclickhouse_cloud.service_snapshot_configuration.updateUpdate service snapshot configurationwrite
Service snapshots2
clickhouse_cloud.service_snapshots.getGet snapshot detailsreadclickhouse_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.