Can I use ClickHouse Cloud as a CLI?

Yes. KosmoKrator exposes a ClickHouse Cloud CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose ClickHouse Cloud through MCP?

Yes. The KosmoKrator MCP gateway can expose selected ClickHouse Cloud tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are ClickHouse Cloud credentials stored?

ClickHouse Cloud credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for ClickHouse Cloud MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

data

ClickHouse Cloud MCP Gateway for AI Agents

Expose ClickHouse Cloud tools to Claude Code, Cursor, Codex, and other MCP clients through the local KosmoKrator MCP gateway.

ClickHouse Cloud MCP Gateway

Expose ClickHouse Cloud to MCP clients with `kosmokrator mcp:serve --integration=clickhouse-cloud`.

If the client has never used KosmoKrator before, install it first, then register this integration as a stdio MCP server.

Install KosmoKrator

curl -fsSL https://raw.githubusercontent.com/OpenCompanyApp/kosmokrator/main/install.sh | bash

Install gateway entry

kosmokrator mcp:gateway:install --integration=clickhouse-cloud --write=deny --json

MCP configuration

{
  "mcpServers": {
    "kosmokrator-clickhouse-cloud": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=clickhouse-cloud",
        "--write=deny"
      ]
    }
  }
}

Serve manually

kosmokrator mcp:serve --integration=clickhouse-cloud --write=deny

Client Notes

Use one scoped MCP gateway entry, then adapt the config location to the client or framework.

Claude Code Connect local KosmoKrator integrations to Claude Code through one scoped MCP gateway entry. Claude Code can launch the local kosmo binary directly from the project MCP config.

Cursor Expose selected local integrations to Cursor through KosmoKrator without configuring each service as its own MCP server. Use the same KosmoKrator install and integration credentials that power terminal and headless runs.

Codex Use KosmoKrator as a local MCP proxy for Codex so coding sessions can reach selected integrations with explicit write policy. Keep write access denied or ask-based unless the workspace is trusted.

OpenAI Agents SDK Attach KosmoKrator integration tools to OpenAI Agents SDK workflows through a local MCP gateway. Use headless JSON commands for CI-style execution and MCP for agent tool discovery.

Claude Agent SDK Give Claude Agent SDK workflows access to KosmoKrator integrations through a local MCP server. Use a narrow integration list so the agent does not load unrelated tools.

Vercel AI SDK Use KosmoKrator as a local integration gateway for Vercel AI SDK agents and scripts. Prefer CLI JSON calls when a workflow only needs one deterministic integration operation.

LangChain Bridge LangChain agents to local KosmoKrator integration tools through MCP or headless CLI calls. Keep the gateway scoped to the integration and operation class needed by the chain.

LangGraph Run KosmoKrator integration calls from LangGraph nodes while preserving local credentials and permissions. Headless CLI calls fit repeatable graph edges; MCP fits exploratory agent nodes.

CrewAI Expose KosmoKrator integrations to CrewAI workers as scoped local tools. Use per-worker integration scopes to avoid giving every worker every tool.

Generic MCP Clients Connect any stdio-compatible MCP client to local KosmoKrator integration tools. Start with read-only write policy and expand only for trusted projects.

MCP Tool Names

KosmoKrator exposes integration tools through the gateway with stable names.

MCP tool	Source function	Type
`integration__clickhouse_cloud__clickhouse_cloud_organization_get_list`	`clickhouse-cloud.clickhouse_cloud_organization_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_organization_get`	`clickhouse-cloud.clickhouse_cloud_organization_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_organization_update`	`clickhouse-cloud.clickhouse_cloud_organization_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_organization_prometheus_get`	`clickhouse-cloud.clickhouse_cloud_organization_prometheus_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_organization_roles_get_list`	`clickhouse-cloud.clickhouse_cloud_organization_roles_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_organization_role_post`	`clickhouse-cloud.clickhouse_cloud_organization_role_post`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_organization_role_get`	`clickhouse-cloud.clickhouse_cloud_organization_role_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_organization_role_patch`	`clickhouse-cloud.clickhouse_cloud_organization_role_patch`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_organization_role_delete`	`clickhouse-cloud.clickhouse_cloud_organization_role_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_get_list`	`clickhouse-cloud.clickhouse_cloud_instance_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_instance_create`	`clickhouse-cloud.clickhouse_cloud_instance_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_get`	`clickhouse-cloud.clickhouse_cloud_instance_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_instance_update`	`clickhouse-cloud.clickhouse_cloud_instance_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_delete`	`clickhouse-cloud.clickhouse_cloud_instance_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_private_endpoint_config_get`	`clickhouse-cloud.clickhouse_cloud_instance_private_endpoint_config_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_instance_query_endpoint_get`	`clickhouse-cloud.clickhouse_cloud_instance_query_endpoint_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_instance_query_endpoint_upsert`	`clickhouse-cloud.clickhouse_cloud_instance_query_endpoint_upsert`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_query_endpoint_delete`	`clickhouse-cloud.clickhouse_cloud_instance_query_endpoint_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_state_update`	`clickhouse-cloud.clickhouse_cloud_instance_state_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_scaling_update`	`clickhouse-cloud.clickhouse_cloud_instance_scaling_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_replica_scaling_update`	`clickhouse-cloud.clickhouse_cloud_instance_replica_scaling_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_password_update`	`clickhouse-cloud.clickhouse_cloud_instance_password_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_private_endpoint_create`	`clickhouse-cloud.clickhouse_cloud_instance_private_endpoint_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_instance_prometheus_get`	`clickhouse-cloud.clickhouse_cloud_instance_prometheus_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_service_clickhouse_settings_list_get`	`clickhouse-cloud.clickhouse_cloud_service_clickhouse_settings_list_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_service_clickhouse_settings_update`	`clickhouse-cloud.clickhouse_cloud_service_clickhouse_settings_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_service_clickhouse_settings_schema_get`	`clickhouse-cloud.clickhouse_cloud_service_clickhouse_settings_schema_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_service_clickhouse_setting_get`	`clickhouse-cloud.clickhouse_cloud_service_clickhouse_setting_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_backup_get_list`	`clickhouse-cloud.clickhouse_cloud_backup_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_backup_get`	`clickhouse-cloud.clickhouse_cloud_backup_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_backup_configuration_get`	`clickhouse-cloud.clickhouse_cloud_backup_configuration_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_backup_configuration_update`	`clickhouse-cloud.clickhouse_cloud_backup_configuration_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_backup_bucket_get`	`clickhouse-cloud.clickhouse_cloud_backup_bucket_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_backup_bucket_create`	`clickhouse-cloud.clickhouse_cloud_backup_bucket_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_backup_bucket_update`	`clickhouse-cloud.clickhouse_cloud_backup_bucket_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_backup_bucket_delete`	`clickhouse-cloud.clickhouse_cloud_backup_bucket_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_openapi_key_get_list`	`clickhouse-cloud.clickhouse_cloud_openapi_key_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_openapi_key_create`	`clickhouse-cloud.clickhouse_cloud_openapi_key_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_openapi_key_get`	`clickhouse-cloud.clickhouse_cloud_openapi_key_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_openapi_key_update`	`clickhouse-cloud.clickhouse_cloud_openapi_key_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_openapi_key_delete`	`clickhouse-cloud.clickhouse_cloud_openapi_key_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_member_get_list`	`clickhouse-cloud.clickhouse_cloud_member_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_member_get`	`clickhouse-cloud.clickhouse_cloud_member_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_member_update`	`clickhouse-cloud.clickhouse_cloud_member_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_member_delete`	`clickhouse-cloud.clickhouse_cloud_member_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_invitation_get_list`	`clickhouse-cloud.clickhouse_cloud_invitation_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_invitation_create`	`clickhouse-cloud.clickhouse_cloud_invitation_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_invitation_get`	`clickhouse-cloud.clickhouse_cloud_invitation_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_invitation_delete`	`clickhouse-cloud.clickhouse_cloud_invitation_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_activity_get_list`	`clickhouse-cloud.clickhouse_cloud_activity_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_activity_get`	`clickhouse-cloud.clickhouse_cloud_activity_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_usage_cost_get`	`clickhouse-cloud.clickhouse_cloud_usage_cost_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_get_list`	`clickhouse-cloud.clickhouse_cloud_click_pipe_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_create`	`clickhouse-cloud.clickhouse_cloud_click_pipe_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_get`	`clickhouse-cloud.clickhouse_cloud_click_pipe_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_update`	`clickhouse-cloud.clickhouse_cloud_click_pipe_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_delete`	`clickhouse-cloud.clickhouse_cloud_click_pipe_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_settings_get`	`clickhouse-cloud.clickhouse_cloud_click_pipe_settings_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_settings_update`	`clickhouse-cloud.clickhouse_cloud_click_pipe_settings_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_scaling_update`	`clickhouse-cloud.clickhouse_cloud_click_pipe_scaling_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_state_update`	`clickhouse-cloud.clickhouse_cloud_click_pipe_state_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_cdc_scaling_get`	`clickhouse-cloud.clickhouse_cloud_click_pipe_cdc_scaling_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_cdc_scaling_update`	`clickhouse-cloud.clickhouse_cloud_click_pipe_cdc_scaling_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_list_dashboards`	`clickhouse-cloud.clickhouse_cloud_click_stack_list_dashboards`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_create_dashboard`	`clickhouse-cloud.clickhouse_cloud_click_stack_create_dashboard`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_get_dashboard`	`clickhouse-cloud.clickhouse_cloud_click_stack_get_dashboard`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_update_dashboard`	`clickhouse-cloud.clickhouse_cloud_click_stack_update_dashboard`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_delete_dashboard`	`clickhouse-cloud.clickhouse_cloud_click_stack_delete_dashboard`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_list_alerts`	`clickhouse-cloud.clickhouse_cloud_click_stack_list_alerts`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_create_alert`	`clickhouse-cloud.clickhouse_cloud_click_stack_create_alert`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_list_sources`	`clickhouse-cloud.clickhouse_cloud_click_stack_list_sources`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_get_alert`	`clickhouse-cloud.clickhouse_cloud_click_stack_get_alert`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_update_alert`	`clickhouse-cloud.clickhouse_cloud_click_stack_update_alert`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_delete_alert`	`clickhouse-cloud.clickhouse_cloud_click_stack_delete_alert`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_stack_list_webhooks`	`clickhouse-cloud.clickhouse_cloud_click_stack_list_webhooks`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_get_list`	`clickhouse-cloud.clickhouse_cloud_postgres_service_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_create`	`clickhouse-cloud.clickhouse_cloud_postgres_service_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_get`	`clickhouse-cloud.clickhouse_cloud_postgres_service_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_patch`	`clickhouse-cloud.clickhouse_cloud_postgres_service_patch`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_delete`	`clickhouse-cloud.clickhouse_cloud_postgres_service_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_certs_get`	`clickhouse-cloud.clickhouse_cloud_postgres_service_certs_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_instance_restore`	`clickhouse-cloud.clickhouse_cloud_postgres_instance_restore`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_set_password`	`clickhouse-cloud.clickhouse_cloud_postgres_service_set_password`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_service_patch_state`	`clickhouse-cloud.clickhouse_cloud_postgres_service_patch_state`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_instance_create_read_replica`	`clickhouse-cloud.clickhouse_cloud_postgres_instance_create_read_replica`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_instance_config_get`	`clickhouse-cloud.clickhouse_cloud_postgres_instance_config_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_instance_config_post`	`clickhouse-cloud.clickhouse_cloud_postgres_instance_config_post`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_postgres_instance_config_patch`	`clickhouse-cloud.clickhouse_cloud_postgres_instance_config_patch`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_organization_private_endpoint_config_get_list`	`clickhouse-cloud.clickhouse_cloud_organization_private_endpoint_config_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_organization_byoc_infrastructure_create`	`clickhouse-cloud.clickhouse_cloud_organization_byoc_infrastructure_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_organization_byoc_infrastructure_update`	`clickhouse-cloud.clickhouse_cloud_organization_byoc_infrastructure_update`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_organization_byoc_infrastructure_delete`	`clickhouse-cloud.clickhouse_cloud_organization_byoc_infrastructure_delete`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_reverse_private_endpoint_get_list`	`clickhouse-cloud.clickhouse_cloud_click_pipe_reverse_private_endpoint_get_list`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_reverse_private_endpoint_create`	`clickhouse-cloud.clickhouse_cloud_click_pipe_reverse_private_endpoint_create`	Write `write`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_reverse_private_endpoint_get`	`clickhouse-cloud.clickhouse_cloud_click_pipe_reverse_private_endpoint_get`	Read `read`
`integration__clickhouse_cloud__clickhouse_cloud_click_pipe_reverse_private_endpoint_delete`	`clickhouse-cloud.clickhouse_cloud_click_pipe_reverse_private_endpoint_delete`	Write `write`

Write Access

Start with --write=deny for read-only MCP clients. Use --write=ask or --write=allow only when the client and workspace are trusted.