skills.rest
baiyongping
baiyongpingCOMMUNITY
Explore all skills by this author →
GitHub

relational-database-mcp-cloudbase

Execute SQL and manage security rules on CloudBase Relational Database via MCP tools.

Updated Dec 24, 2025
Search Tags:#sql#relational-database#mcp-tools#data-management#security-rules#cloudbase
One-click install
npx skills add https://github.com/baiyongping/cowork-platform --skill relational-database-mcp-cloudbase-baiyongping
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: relational-database-mcp-cloudbase
Source: https://github.com/baiyongping/cowork-platform/tree/main/.claude/skills/relational-database-tool
Command: npx skills add https://github.com/baiyongping/cowork-platform --skill relational-database-mcp-cloudbase-baiyongping

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Enables MCP agents to operate on CloudBase Relational Database solely through MCP tools, avoiding standard application SDKs and reducing risk when executing data manipulation and schema changes.

Core Features & Use Cases

  • Read-only data exploration with executeReadOnlySQL to list rows and inspect schema without modifying data.
  • Write operations and DDL through executeWriteSQL, including INSERT, UPDATE, DELETE, CREATE TABLE, and ALTER TABLE, with guidance to include _openid for per-user access control.
  • Security governance via readSecurityRule and writeSecurityRule to view and modify table access rules.
  • Clear safety prompts: summarize destructive actions and verify preconditions before executing changes.

Quick Start

Run an MCP task to query the users table with a safe SELECT and review results before any modification.

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 execute SQL queries on CloudBase Relational Database using MCP tools?▼

You can execute SQL queries on CloudBase Relational Database by using the executeReadOnlySQL MCP tool for data inspection and executeWriteSQL for data modifications or schema changes.

What is the safest way to manage CloudBase database security rules with an MCP agent?▼

Managing CloudBase database security rules safely involves using the readSecurityRule and writeSecurityRule MCP tools to view and modify table access controls without SDK initialization.

Can I use standard application SDKs to modify schemas in CloudBase Relational Database?▼

No, for relational tasks you must use MCP tools exclusively. The skill enforces strict usage of MCP tools and forbids standard SDK initialization to reduce risks during schema changes.

How do I prevent accidental data loss when running destructive SQL operations in CloudBase?▼

To prevent data loss, the MCP tools require explicit safety checks and prompt you to summarize destructive actions and verify preconditions before executing operations like DELETE or ALTER TABLE.

Do I need to include _openid when inserting data into CloudBase tables via MCP tools?▼

Yes, when performing write operations like INSERT through the executeWriteSQL MCP tool, you should include the _openid field to ensure proper per-user access control.

What are the limitations of using MCP tools for CloudBase SQL execution?▼

Limitations include a strict prohibition on standard SDK initialization for relational tasks and a mandatory safety check requirement that blocks destructive operations until preconditions are explicitly verified.

Related Skills

Explore More Software Engineering Skills→
neitui-coderneitui-coder

relational-database-web-cloudbase

Initialize CloudBase Relational Database in Web apps using @cloudbase/js-sdk.

Community
Intermediate
hackeshackeshackeshackes
6

data-analysis

Analyze Excel and CSV files with SQL queries and statistical summaries.

Community
Intermediate
dang0705dang0705

cloudbase

Automate Tencent CloudBase authentication, database, functions, hosting, and AI integration.

Community
Advanced
SoltusSoltus
1

relational-database-mcp-cloudbase

Manage CloudBase Relational Database operations via MCP tools.

Community
Advanced