skills.rest
mrpersimmon
mrpersimmonCOMMUNITY
Explore all skills by this author →
GitHub

relational-database-mcp-cloudbase

Manage CloudBase Relational Database (MySQL) operations through MCP tools.

Updated Aug 23, 2026
Search Tags:#permissions#mcp#mysql#cloudbase#sql management#schema initialization#async provisioning
One-click install
npx skills add https://github.com/mrpersimmon/xiao-han-studio --skill relational-database-mcp-cloudbase-mrpersimmon
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: relational-database-mcp-cloudbase
Source: https://github.com/mrpersimmon/xiao-han-studio/tree/main/.agents/skills/cloudbase/references/relational-database-tool
Command: npx skills add https://github.com/mrpersimmon/xiao-han-studio --skill relational-database-mcp-cloudbase-mrpersimmon

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It helps an agent provision, inspect, and manage CloudBase Relational Database (MySQL) safely when only MCP tools are available.

Core Features & Use Cases

  • Provision and destroy MySQL with explicit confirmation and status polling for readiness or completion.
  • Run safe read/write SQL using the correct MCP tool for queries vs mutations and DDL/schema initialization.
  • Manage table permissions by querying and updating resource-level access rules (including permission review after new tables).

Quick Start

Ask your agent to provision MySQL if needed, initialize the required tables, and then verify and update permissions for the new tables using the CloudBase MCP tools.

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 a CloudBase MySQL database using an AI agent?▼

You can manage a CloudBase MySQL database using an agent by routing operations through MCP tools. This allows the agent to provision instances, execute SQL, initialize schemas, and update permissions safely.

What is the difference between runQuery and runStatement in MCP SQL management?▼

In MCP SQL management, runQuery handles safe read operations, while runStatement executes mutating write operations. The Skill automatically enforces this separation to ensure safe database interactions.

How do I initialize a database schema and check its creation status asynchronously?▼

To initialize a schema asynchronously, use the initializeSchema MCP tool, then poll readiness with describeCreateResult and describeTaskStatus. This verifies the schema initialization lifecycle status until completion.

Can I update table permissions for a newly created CloudBase MySQL table via MCP?▼

Yes, you can query and update resource-level access rules for new CloudBase MySQL tables via MCP. The Skill enforces permission audits and updates using queryPermissions and managePermissions tools.

Does this approach require explicit confirmation before destroying a MySQL instance?▼

Yes, destroying a MySQL instance requires explicit confirmation. The Skill provisions and destroys instances with explicit approval, polling the lifecycle status to ensure the operation completes safely.

What are the limitations of using MCP for CloudBase relational database operations?▼

Using MCP for CloudBase relational database operations is limited to the available tool-specific functions like runQuery, runStatement, and schema initialization. It relies on async status polling rather than synchronous execution.

Related Skills

Explore More Software Engineering Skills→
mahmoud20138mahmoud20138
10

mcp-integration

Configure Claude Code plugins to access external services via MCP servers.

Community
Advanced
xukrutdonutxukrutdonut

database

Execute SQL queries and manage schemas across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.

Community
Intermediate
MacPhobosMacPhobos

Supabase Backend Platform Skill

Provide PostgreSQL database, authentication, storage, realtime subscriptions, and edge functions.

Community
Advanced
lance-doniflance-donif

relational-database-mcp-cloudbase

Manage CloudBase Relational Database instances and permissions through MCP tools.

Community
Intermediate