skills.rest
williamwang25
williamwang25COMMUNITY
Explore all skills by this author →
GitHub

relational-database-mcp-cloudbase

Manage CloudBase MySQL instances and SQL permissions via MCP tools.

Updated May 14, 2026
Search Tags:#mysql#permission management#cloudbase#mcp tools#sql management#schema initialization#async provisioning
One-click install
npx skills add https://github.com/williamwang25/ams-admin --skill relational-database-mcp-cloudbase-williamwang25
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: relational-database-mcp-cloudbase
Source: https://github.com/williamwang25/ams-admin/tree/main/.windsurf/skills/cloudbase/references/relational-database-tool
Command: npx skills add https://github.com/williamwang25/ams-admin --skill relational-database-mcp-cloudbase-williamwang25

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It solves the need to manage CloudBase Relational Database (MySQL) using MCP tools, including safely inspecting data, provisioning/destroying instances, initializing schema, and maintaining table permissions.

Core Features & Use Cases

  • SQL inspection and read-only querying: Run SELECT queries and check instance/provisioning state through MCP.
  • MySQL lifecycle management: Provision or destroy MySQL with confirmation, then poll async status until ready/complete.
  • Schema initialization and permission updates: Create tables/indexes via initialization flows and ensure per-table access rules are correctly set (including _openid requirements for per-user access control).

Quick Start

Use the relational-database-mcp-cloudbase skill to provision MySQL if missing, poll until READY, run initialization SQL, and then update table permissions for the required resource IDs.

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 provision and manage CloudBase MySQL instances via MCP?▼

To manage CloudBase MySQL via MCP, you use the manageSqlDatabase tool to provision or destroy instances, requiring explicit confirmation for destructive operations, and poll asynchronous status until the instance is READY.

Can I run read-only SQL queries on CloudBase Relational Database using MCP?▼

Yes, you can run read-only SQL queries on CloudBase Relational Database using the querySqlDatabase MCP tool to safely inspect instance state and execute SELECT statements without risking data modification.

How do I initialize schema and configure table permissions for CloudBase MySQL?▼

You initialize schema and configure table permissions for CloudBase MySQL by executing DDL via initialization flows, then using the managePermissions MCP tool to set per-table access rules including _openid requirements for per-user access control.

Do I need to avoid mixing SDK initialization when using MCP tools for CloudBase MySQL?▼

Yes, you must avoid mixing SDK initialization in the same management flow when using MCP tools for CloudBase MySQL, ensuring querySqlDatabase, manageSqlDatabase, and permission tools operate independently within the MCP workflow.

What is the best way to check asynchronous provisioning status for CloudBase MySQL?▼

The best way to check asynchronous provisioning status for CloudBase MySQL is polling the instance state through MCP tools until the provisioning process reaches READY or complete, ensuring safe execution of subsequent schema initialization.

Related Skills

Explore More Software Engineering Skills→
xongtaoxongtao

relational-database-web-cloudbase

Initialize a shared CloudBase relational database client for browser queries.

Community
Intermediate
mbpzmbpz

relational-database-mcp-cloudbase

Automate SQL execution and MySQL instance management for CloudBase Relational Database via MCP.

Community
Advanced
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