# Manage CloudBase MySQL with MCP

CloudBase MySQL operations need clear tool choice and safety checks. This skill guides agents through MCP-based provisioning, querying, schema changes, and permission reviews.

## Install

```bash
npx skillstore add tencentcloudbase/relational-database-mcp-cloudbase
```

## Metadata

- Status: approved
- Slug: tencentcloudbase-relational-database-mcp-cloudbase
- Version: 2.23.8
- Author version: 2.23.8
- Skillstore revision: r1
- Version status: valid
- Tree hash: 45ae12ea08ba7b8d608cb5c767cce190f3075c98b508d3eefce125eb420ed4ee
- Author: tencentcloudbase
- GitHub username: tencentcloudbase
- License: MIT
- Repository: https://github.com/tencentcloudbase/skills/tree/main/skills/relational-database-tool
- Ref: 24b2fe42a456262f3fd0fb3df72e12d9ed2c32ec
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, network, filesystem
- Quality score: 71
- Public page: https://skillstore.pages.dev/skills/tencentcloudbase-relational-database-mcp-cloudbase
- Manifest: https://skillstore.pages.dev/api/skills/tencentcloudbase-relational-database-mcp-cloudbase/manifest

## Capabilities

- Selects the correct MCP tool for read-only queries, writes, provisioning, and permission changes.
- Guides MySQL provisioning and destroy workflows with confirmation and status checks.
- Explains safe SQL query, statement, and schema initialization workflows.
- Requires \_openid on new tables for per-user access control.
- Separates MCP database management from SDK-based application development.

## Use Cases

- Check Database Readiness: Confirm whether CloudBase MySQL exists and is ready before any SQL work begins.
- Review Table Permissions: Inspect and update SQL table permissions after creating or changing schema.
- Run Controlled SQL Maintenance: Plan read checks, targeted writes, schema initialization, and validation through MCP tools.

## Prompt Templates

### Check Database Status

```
Use this skill to check whether CloudBase MySQL is provisioned and ready. Report the status and next safe step.
```

### Run a Safe Read Query

```
Use this skill to inspect a table with a limited read-only query. Summarize the result and avoid write operations.
```

### Initialize a Secure Schema

```
Use this skill to plan schema initialization for CloudBase MySQL. Include _openid where user-scoped access is needed.
```

### Plan a Destructive Change

```
Use this skill to plan a destructive database action. Confirm the environment, explain impact, and define validation steps.
```

## Limitations

- Requires CloudBase MCP tools to be available in the agent environment.
- Does not provide SDK code for frontend or backend applications.
- Can guide destructive operations, so users must confirm the target environment and action.
- References remote fallback documentation for related skills.

## Best Practices

- Confirm environment and table names before writes, schema changes, or destroys.
- Run limited read-only queries before mutating data.
- Review table permissions after schema creation or permission updates.

## Anti Patterns

- Using SDK setup when MCP tools are available for the management task.
- Destroying MySQL without explicit user confirmation and status polling.
- Creating user-scoped tables without the \_openid access-control column.

## Security Audit

- Audited at: 2026-07-09T16:44:03.807\+00:00
- Summary: Most static command, filesystem, and blocker findings are false positives caused by Markdown formatting and static documentation references. The hardcoded remote fallback URLs are a confirmed low-risk network concern, and the remote instruction fallback is a medium supply-chain trust concern.

## Stats

- Views: 1
- Downloads: 8
- Favorites: 1
- Popularity score: 0