relational-database-mcp-cloudbase
This is the required documentation for agents operating on the CloudBase Relational Database. It lists the only four supported tools for running SQL and managing security rules. Read the full content to understand why you must NOT use standard Application SDKs and how to safely execute INSERT, UPDATE, or DELETE operations without corrupting production data.
Security Assessment
About relational-database-mcp-cloudbase
The 'relational-database-mcp-cloudbase' skill provides a set of tools for agents to safely interact with CloudBase Relational Database via MCP (Managed Cloud Platform) tools. This skill is designed to address the need for controlled, secure operations on the database without risking data corruption, especially when performing data modifications like INSERT, UPDATE, or DELETE operations. It highlights the importance of using MCP tools instead of standard SDKs to interact with the database, ensuring safe and consistent management of data, schema, and security rules in production environments.
FAQ
When should I use this skill?
You should use this skill when an agent needs to interact with CloudBase Relational Database for tasks such as querying data, modifying tables, or managing security rules via MCP tools. This skill is not for building web or Node.js applications or managing user authentication.
Can I use standard SDKs with this skill?
No, you should not use standard SDKs for CloudBase Relational Database when operating within the MCP context. This skill relies on MCP tools like 'executeReadOnlySQL' and 'executeWriteSQL' for interacting with the database.
What happens if I need to modify data in the database?
For modifying data or schema (INSERT, UPDATE, DELETE), use the 'executeWriteSQL' tool. Always ensure you've verified the data via 'executeReadOnlySQL' before running destructive queries. Additionally, confirm that the correct target tables and conditions are set before performing any write operations.
How do I manage security rules for a table?
To manage security rules, use the 'readSecurityRule' tool to inspect current permissions, and the 'writeSecurityRule' tool to update or configure new rules. It is recommended to use standard rule types like 'READONLY' or 'PRIVATE' before opting for custom logic.
What specific column must be included when creating new tables?
When creating a new table, include the '_openid' column for per-user access control. The server automatically populates this column based on the authenticated user's session, so you do not need to manually set it in INSERT operations.
Install relational-database-mcp-cloudbase
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
TencentCloudBase/CloudBase-MCP