create_relational_database
ActiveTool of cloud.redu/mcp
Provisions a managed MySQL (or MariaDB) database on a dedicated VM on your private network — the relational-database resource (use this instead of create_database when the app needs MySQL/MariaDB, e.g. WordPress, NextCloud, Matomo, many PHP/LAMP apps). It is PRIVATE — reachable only from another instance on the same private network, via the DB's internal/private IP (port 3306), not a public address. Get the ids from list_flavors, list_private_networks, list_keypairs. Provisioning takes ~5 min; poll list_relational_databases until status='ready', then the connection details (private_ip, port 3306, db_name, db_user) are populated. MySQL is created with mysql_native_password auth so older clients/apps connect cleanly. (ClickHouse is a separate resource — use create_clickhouse / list_clickhouse_databases.)
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 database (lowercase letters, numbers, hyphens)."
},
"engine": {
"enum": [
"mysql",
"mariadb"
],
"type": "string",
"default": "mysql",
"description": "Database engine: 'mysql' (default) or 'mariadb'. Both speak the MySQL protocol (mysql:// URL). Pick the one your app/stack uses. (For analytics/column-store needs use create_clickhouse instead — ClickHouse is not a relational DB.)"
},
"db_name": {
"type": "string",
"default": "app",
"maxLength": 63,
"minLength": 1,
"description": "The database to create (default 'app')."
},
"db_user": {
"type": "string",
"default": "appuser",
"maxLength": 63,
"minLength": 1,
"description": "The database user (default 'appuser')."
},
"version": {
"type": "string",
"description": "Engine version (e.g. mysql '8.0', mariadb '11.4'). Defaults to the engine's current major if omitted."
},
"flavor_id": {
"type": "string",
"minLength": 1,
"description": "Instance size for the DB VM — from list_flavors."
},
"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 (for operating the DB VM)."
},
"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