relational-database-mcp-cloudbase

Name: relational-database-mcp-cloudbase
Author: TencentCloudBase

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.

TL;DR

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

What Is It

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.

Key Features

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.

How to Use

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