create_clickhouse
ActiveTool of cloud.redu/mcp
declared in 2.0.0
Provisions a managed ClickHouse database (OLAP / columnar analytics engine, Apache-2.0) on a dedicated VM on your private network — its OWN resource, NOT a relational database. Use it for analytics / observability workloads that need a column store (PostHog, Langfuse, event analytics, time-series). It is PRIVATE — reachable only from another instance on the same private network, via the DB's internal/private IP on the ClickHouse HTTP port 8123 (CLICKHOUSE_HOST/PORT/USER/PASSWORD/DB env, http://host:8123). Get the ids from list_flavors (use m1.small+ — ClickHouse needs >=2GB RAM), list_private_networks, list_keypairs. Provisioning takes ~5 min; poll list_clickhouse_databases until status='ready'.
Parameters schema
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"name",
"flavor_id",
"network_id",
"keypair_name"
],
"properties": {
"name": {
"type": "string",
"maxLength": 63,
"minLength": 1,
"description": "Name for the managed ClickHouse database (lowercase letters, numbers, hyphens)."
},
"db_name": {
"type": "string",
"default": "analytics",
"maxLength": 63,
"minLength": 1,
"description": "The database to create (default 'analytics')."
},
"db_user": {
"type": "string",
"default": "appuser",
"maxLength": 63,
"minLength": 1,
"description": "The database user (default 'appuser')."
},
"flavor_id": {
"type": "string",
"minLength": 1,
"description": "Instance size for the ClickHouse VM — from list_flavors. ClickHouse is RAM-hungry; pick m1.small (2GB) or larger."
},
"network_id": {
"type": "string",
"minLength": 1,
"description": "Private network id — from list_private_networks. The DB is reachable only from this network."
},
"db_password": {
"type": "string",
"maxLength": 128,
"minLength": 8,
"description": "Password for the db user (letters/numbers/_/- only). Auto-generated and returned once if omitted."
},
"keypair_name": {
"type": "string",
"minLength": 1,
"description": "SSH keypair name — from list_keypairs."
},
"idempotency_key": {
"type": "string",
"minLength": 8
},
"security_group_names": {
"type": "array",
"items": {
"type": "string"
},
"default": [
"default"
]
}
},
"additionalProperties": false
}Parent server
cloud.redu/mcp
1/7 registries