skills.rest
xongtao
xongtaoCOMMUNITY
Explore all skills by this author →
GitHub

relational-database-mcp-cloudbase

Provision, query, and manage MySQL databases via MCP with security rules.

Updated Mar 10, 2026
Search Tags:#mcp#relational-database#security-rules#cloudbase#schema-initialization#sql-management#mysql-provisioning
One-click install
npx skills add https://github.com/xongtao/openclaw-backup --skill relational-database-mcp-cloudbase-xongtao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: relational-database-mcp-cloudbase
Source: https://github.com/xongtao/openclaw-backup/tree/main/skills/cloudbase/references/relational-database-tool
Command: npx skills add https://github.com/xongtao/openclaw-backup --skill relational-database-mcp-cloudbase-xongtao

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

CloudBase Relational Database management can require coordinating provisioning, runtime SQL actions, and security governance across multiple tools. This skill provides an authoritative workflow for CloudBase Relational Database management using MCP, unifying provisioning, query, schema initialization, and security-rule updates into a safe, repeatable process.

Core Features & Use Cases

  • Provision MySQL for an environment
  • Destroy MySQL when it's no longer needed
  • Run read-only SQL queries to inspect data
  • Execute mutating SQL statements and initialize schemas
  • Read and write per-table security rules to enforce access control

Quick Start

Begin by checking the current MySQL instance with querySqlDatabase(action="getInstanceInfo"), provision the instance if needed with manageSqlDatabase(action="provisionMySQL", confirm=true), and then manage data and schema using appropriate MCP tools while verifying security with readSecurityRule and writeSecurityRule.

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 provisioning and queries in MCP workflows?▼

You can manage CloudBase relational database in MCP workflows using tools to provision MySQL, run read-only or mutating SQL queries, initialize schemas, and modify per-table security rules.

Can I update per-table security rules for my CloudBase MySQL instance through MCP?▼

Yes, you can use readSecurityRule to inspect current per-table security rules and writeSecurityRule to modify them, enforcing access control directly within your MCP agent workflows.

How do I provision a new MySQL instance on CloudBase using an MCP agent?▼

To provision a new MySQL instance, use manageSqlDatabase with action="provisionMySQL" and confirm=true, which enforces an explicit safety prompt for the destructive or state-changing action.

What's the best way to inspect SQL data in CloudBase before modifying the schema?▼

The best way to inspect SQL data is using querySqlDatabase to execute read-only SQL statements against the CloudBase relational database, allowing safe data retrieval before schema initialization.

Are there safety mechanisms for destructive SQL management actions in MCP?▼

Yes, the MCP tools enforce safety prompts for destructive actions and require explicit confirmation for operations like destroying MySQL or executing mutating SQL statements to prevent data loss.

Does CloudBase MCP support initializing database schemas with mutating SQL statements?▼

Yes, CloudBase MCP supports executing mutating SQL statements to initialize database schemas, allowing agents to apply structural changes alongside standard data queries and security rule updates.

Related Skills

Explore More Software Engineering Skills→
xongtaoxongtao

relational-database-web-cloudbase

Initialize a shared CloudBase relational database client for browser queries.

Community
Intermediate
FunnelEnvyFunnelEnvy
1

bq-query-optimization

Optimize and debug BigQuery SQL queries for performance and cost.

Official
Advanced
lance-doniflance-donif

relational-database-mcp-cloudbase

Manage CloudBase Relational Database instances and permissions through MCP tools.

Community
Intermediate
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate