relational-database-mcp-cloudbase

Use MCP tools only for database operations; never use standard SDKs.

• Run SQL queries on CloudBase Relational Database via MCP tools.
• Manage table security rules (read/write).
• Supports SELECT, INSERT, UPDATE, DELETE, DDL.
• Only available in MCP agent context.

• Use `executeReadOnlySQL` for read-only queries.
• Use `executeWriteSQL` for writes and DDL.
• Use `readSecurityRule` to inspect table permissions.
• Use `writeSecurityRule` to update table security rules.
• Always avoid initializing CloudBase Relational Database SDKs.
• Must include `_openid` in new table definitions.
• Never use standard Application SDKs.
• Must confirm target tables and conditions before writes.

1. 1.Recognize MCP context: use only MCP tools, not SDKs.
2. 2.Pick correct tool: SELECT → executeReadOnlySQL, write → executeWriteSQL, rules → read/writeSecurityRule.
3. 3.Always be explicit about safety: summarize intent before destructive ops.
4. 4.Run read-only SELECT first to verify assumptions.
5. 5.Confirm table and condition accuracy before write operations.
6. 6.Explain intent and rationale for schema or rule changes.