skills.rest
LYC1197060211
LYC1197060211COMMUNITY
Explore all skills by this author →
WebsiteGitHub

relational-database-mcp-cloudbase

Execute SQL queries and manage security rules for CloudBase Relational Databases via MCP tools.

Updated Aug 23, 2026
Search Tags:#security#database#mcp#data management#sql#cloudbase
One-click install
npx skills add https://github.com/LYC1197060211/jxj --skill relational-database-mcp-cloudbase-lyc1197060211
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: relational-database-mcp-cloudbase
Source: https://github.com/LYC1197060211/jxj/tree/main/web-admin/.claude/skills/relational-database-tool
Command: npx skills add https://github.com/LYC1197060211/jxj --skill relational-database-mcp-cloudbase-lyc1197060211

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides agents with the necessary tools to securely interact with and manage CloudBase Relational Databases, ensuring data integrity and controlled access.

Core Features & Use Cases

  • Data Querying: Execute read-only SQL queries to inspect data.
  • Data Modification: Safely perform INSERT, UPDATE, DELETE, and DDL operations.
  • Security Rule Management: Read and write security rules for tables.
  • Use Case: An agent needs to update user roles in the users table and then verify the change by querying the table.

Quick Start

Use the relational-database-mcp-cloudbase skill to execute the SQL query SELECT * FROM users LIMIT 10.

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 read-only SQL queries on a CloudBase Relational Database?▼

Use the executeReadOnlySQL MCP tool to safely inspect data on a CloudBase Relational Database without risking unintended modifications. This ensures secure data verification and analysis.

Can I perform write SQL operations and schema changes in CloudBase?▼

Yes, you can perform write SQL operations including INSERT, UPDATE, DELETE, and DDL schema changes in CloudBase using the executeWriteSQL MCP tool. This enables safe data modification and schema management.

How do I manage security rules for CloudBase database tables?▼

Manage CloudBase database security rules by using the readSecurityRule and writeSecurityRule MCP tools to audit and update access controls. This ensures controlled access and data integrity for your tables.

Does this database management approach support access control auditing?▼

Yes, access control auditing is supported through the readSecurityRule MCP tool to inspect existing security rules. This allows agents to verify table access controls and ensure data integrity.

What are the limitations of using MCP tools for relational database management?▼

Using MCP tools for relational database management requires explicit tool calls like executeWriteSQL for operations, meaning agents cannot execute implicit SQL. You must explicitly define read, write, and security rule actions.

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
starlake-aistarlake-ai
209

parquet2csv

Convert Parquet files into CSV format for batch ETL pipelines.

Official
Intermediate
stacktapestacktape
79

stacktape

Deploy full-stack applications to AWS from a Stacktape configuration file.

Official
Intermediate
CarGDevCarGDev

Database Expert

Design database schemas and optimize SQL queries with execution plans.

Community
Advanced