relational-database-mcp-cloudbase

Manage CloudBase MySQL instances and security rules via MCP tools.

1|1|Updated Mar 18, 2026
One-click install
npx skills add https://github.com/xianmingyao/openclaw-CaySon --skill relational-database-mcp-cloudbase-xianmingyao
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: relational-database-mcp-cloudbase
Source: https://github.com/xianmingyao/openclaw-CaySon/tree/main/skills/cloudbase/references/relational-database-tool
Command: npx skills add https://github.com/xianmingyao/openclaw-CaySon --skill relational-database-mcp-cloudbase-xianmingyao

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The MCP-based CloudBase Relational Database workflow can be complex and error-prone. This Skill provides a canonical, tool-driven approach to query data, provision and destroy MySQL instances, initialize schemas, and manage security rules through MCP tools, ensuring safe and auditable operations.

Core Features & Use Cases

  • Obtain read-only visibility into provisioning state via querySqlDatabase with action="getInstanceInfo".
  • Provision, destroy, and mutate MySQL instances using manageSqlDatabase (e.g., provisionMySQL, destroyMySQL, runStatement, initializeSchema).
  • Inspect and update table security rules using readSecurityRule and writeSecurityRule.
  • Ensure safety with pre-checks, explicit confirmations for destructive actions, and status polling with describeCreateResult and describeTaskStatus.

Quick Start

Begin by inspecting the MySQL provisioning status with MCP tools and proceed to provision, initialize the schema, and set appropriate security rules as needed.

Frequently Asked Questions about relational-database-mcp-cloudbase

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage CloudBase Relational Database instances using MCP workflows?

You can manage CloudBase Relational Database instances using MCP workflows by applying canonical tooling to query data, provision MySQL, and mutate instances with safeguards like readiness checks and explicit confirmations for destructive actions.

How do I provision and destroy MySQL instances through MCP tools safely?

To provision and destroy MySQL instances safely through MCP tools, you use manageSqlDatabase with pre-checks, explicit confirmations for destructive actions, and asynchronous status polling via describeCreateResult and describeTaskStatus.

How do I read and update security rules for CloudBase SQL databases?

You read and update security rules for CloudBase SQL databases by applying the readSecurityRule and writeSecurityRule tooling within your MCP workflow to inspect and mutate table-level access controls.

Does MCP SQL management support asynchronous task status polling?

MCP SQL management supports asynchronous task status polling using the describeTaskStatus and describeCreateResult tools to verify database readiness and ensure safe, auditable operations across environments.

What's the best way to execute SQL statements on a provisioned CloudBase MySQL instance?

The best way to execute SQL statements on a provisioned CloudBase MySQL instance is using the manageSqlDatabase tool with action runStatement, ensuring operations remain auditable within the MCP workflow.