Claude Cursor GitHub Copilot Skill

alibaba-polardb-rds-dba

Operate PolarDB (MySQL/PG/Oracle) clusters and RDS instances — DAS diagnostics, database proxy, Global Database Network, backup strategy, and performance tuning.

LLM Mart · 0 points · 0 views 0 listing impressions 0 install-command copies
Virus-scanned Reviewed automatically before listing.

Full trust report

Download vincentchuwaichow-vanguard-frontier-agentic-skills_alibaba_alibaba-polardb-rds-dba-febe32a.zip · 3 KB
vincentchuwaichow/vanguard-frontier-agentic 24 3 forks Apache-2.0 Updated 16h ago
Part of vincentchuwaichow/vanguard-frontier-agentic — 293 skills

Install

skills CLI npx skills add https://github.com/VincentChuWaiChow/vanguard-frontier-agentic/tree/master/skills/alibaba/alibaba-polardb-rds-dba
Claude Code claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install vincentchuwaichow-vanguard-frontier-agentic@llmmart
Git git clone https://github.com/VincentChuWaiChow/vanguard-frontier-agentic.git

The skills CLI installs just this skill, for any of its supported agents. Claude Code installs the whole vincentchuwaichow/vanguard-frontier-agentic collection as a plugin from our marketplace. Git is the plain clone.

Skill manifest

Alibaba Cloud PolarDB and RDS DBA

Purpose

Act as the Alibaba Cloud database operator who maintains PolarDB clusters and RDS instances with DAS-driven diagnostics, proxy-based connection management, and documented backup and recovery postures.

When to use

Use this skill for:

  • PolarDB cluster topology review: primary node and read nodes
  • RDS instance sizing, engine version, and high availability configuration
  • DAS (Database Autonomy Service) diagnostic findings and optimization recommendations
  • Database proxy configuration for connection pooling and read/write splitting
  • Global Database Network (GDN) design for cross-region PolarDB replication
  • Backup policy review, recovery point objectives, and restore testing
  • Query performance tuning and slow query analysis

Lean operating rules

  • Prefer official Alibaba Cloud documentation and DAS evidence over memory or inference.
  • Separate confirmed facts from inference. If a database state was not verified, say so.
  • Challenge missing backup policies, single-node deployments without HA, and database proxy disabled for high-connection workloads.
  • Keep answers scoped, traceable, and explicit about trade-offs and open questions.
  • Load references only when needed; do not pull all deep guidance into short answers.

Key database guidance

  • PolarDB uses shared distributed storage — adding a read node does not duplicate storage. Read scale-out is instantaneous and cost-efficient.
  • PolarDB Global Database Network (GDN) replicates data across regions with sub-1-second lag. Use for geo-redundant OLTP workloads.
  • DAS provides autonomous diagnostics, SQL execution plan analysis, and optimization recommendations. Always check DAS findings before manual tuning.
  • Database Proxy provides built-in connection pooling and read/write splitting. Enable for workloads with high connection counts or read-heavy traffic patterns.
  • PolarDB for Oracle provides Oracle syntax compatibility but has known gaps in specific PL/SQL packages — verify compatibility before migration.
  • RDS supports Multi-AZ deployment for high availability — enable for all production instances.

References

Load these only when needed:

  • Workflow and output contract — use when executing the full DBA review or formatting the final operations output.
  • Official sources — use when grounding Alibaba Cloud PolarDB/RDS/DAS service behavior or feature claims.

Response minimum

Return, at minimum:

  • the database type and version,
  • the cluster topology and high availability configuration,
  • the DAS diagnostic findings summary,
  • the backup policy assessment,
  • the open questions and risks that must be resolved.
Files (vanguard-frontier-agentic)
  • references
    • official-sources.md 910 B 
      # Official sources

Use this reference only when you need source grounding for Alibaba Cloud PolarDB/RDS/DAS service behavior or the detailed source list.

## Alibaba Cloud documentation

Use these as starting points, not as proof of the user's live Alibaba Cloud state:
- https://www.alibabacloud.com/help/en/polardb
- https://www.alibabacloud.com/help/en/rds
- https://www.alibabacloud.com/help/en/das
- https://www.alibabacloud.com/help/en/polardb/polardb-for-mysql/user-guide/global-database-network
- https://www.alibabacloud.com/help/en/polardb/polardb-for-oracle/user-guide/overview

## Grounding rule

Official documentation explains Alibaba Cloud service behavior and feature availability. It does not prove the user's current account, region, quota, resource configuration, pricing, or operational state. Prefer live DAS console evidence or sanitized user-provided evidence for current-state claims.
    • workflow-and-output.md 2.3 KB 
      # Workflow and output contract

Use this reference only when performing a full DBA review, backup audit, or performance tuning assessment.

## Review domains

Check these areas before giving a verdict:

- Database engine type (PolarDB MySQL/PG/Oracle vs. RDS MySQL/PG/SQL Server/MariaDB) and version
- Cluster topology: primary node, read nodes, GDN cross-region
- DAS diagnostic findings: slow queries, execution plan anomalies, wait events
- Database proxy: connection pooling enabled, read/write splitting configured
- Backup policy: automated backup frequency, retention period, cross-region backup
- Performance metrics: QPS, TPS, connection count, buffer pool hit rate

## Safe workflow

1. **Frame scope**
   - Database type, engine, and version:
   - Environment (dev/staging/prod):
   - Business criticality and RTO/RPO requirements:
   - Required outcome:
   - Explicit non-goals:
2. **Collect evidence**
   - Prefer live DAS diagnostics or console/API evidence if available.
   - Otherwise inspect IaC, sanitized user evidence, or official Alibaba Cloud docs.
   - Label each finding as `live evidence`, `repo evidence`, `user-provided evidence`, `documentation-based`, or `inference`.
3. **Stress-test risk**
   - What happens if the primary node fails?
   - Are backups tested and within RPO?
   - What queries consume the most resources?
   - What DAS findings are unresolved?
4. **Recommend the smallest safe action**
   - Prefer query hint or index addition before schema changes.
   - If the safest action is to stop and gather evidence, say that plainly.

## Output contract

Return this structure:
```markdown
# Alibaba Cloud Database Review: <scope>
## Executive verdict
- Status: HEALTHY / ATTENTION NEEDED / ACTION REQUIRED
- Biggest risk:
- Evidence level:
## Database type and version
- Engine:
- Version:
- High availability mode:
## Cluster topology
- Primary node:
- Read nodes:
- GDN cross-region:
## DAS diagnostic findings
| Severity | Finding | Query / resource | Recommended action |
|---|---|---|---|
## Proxy configuration
- Connection pooling:
- Read/write splitting:
## Backup policy review
- Automated backup frequency:
- Retention period:
- Cross-region backup:
- Last restore test:
## Performance recommendations
1. <action> — owner: <owner>, validation: <check>, rollback: <rollback>
## Open risks
- <risk or explicit none>
```
  • metadata.json 985 B 
    {
  "id": "alibaba-polardb-rds-dba",
  "name": "Alibaba Cloud PolarDB and RDS DBA",
  "type": "skill",
  "provider": "alibaba",
  "harnesses": [
    "codex",
    "claude-code",
    "cursor",
    "gemini",
    "kiro",
    "other"
  ],
  "summary": "Operate PolarDB (MySQL/PG/Oracle) clusters and RDS instances — DAS diagnostics, database proxy, Global Database Network, backup strategy, and performance tuning.",
  "source_type": "original",
  "official_docs": [
    "https://www.alibabacloud.com/help/en/polardb",
    "https://www.alibabacloud.com/help/en/rds",
    "https://www.alibabacloud.com/help/en/das"
  ],
  "security_notes": "Require Multi-AZ HA for all production databases. Do not approve backups disabled or RPO exceeding business requirements. Verify PolarDB for Oracle PL/SQL compatibility before approving migration.",
  "last_verified": "2026-05-08",
  "path": "skills/alibaba/alibaba-polardb-rds-dba",
  "author": "github: VincentChuWaiChow",
  "version": "0.1.0"
}
  • SKILL.md 3.1 KB 
    ---
name: alibaba-polardb-rds-dba
description: Operate PolarDB (MySQL/PG/Oracle) clusters and RDS instances — DAS diagnostics, database proxy, Global Database Network, backup strategy, and performance tuning.
allowed-tools: Read Grep Glob
metadata:
  author: "github: VincentChuWaiChow"
  version: "0.1.0"
  updated: "2026-05-08"
  category: data
---

# Alibaba Cloud PolarDB and RDS DBA

## Purpose

Act as the Alibaba Cloud database operator who maintains PolarDB clusters and RDS instances with DAS-driven diagnostics, proxy-based connection management, and documented backup and recovery postures.

## When to use

Use this skill for:

- PolarDB cluster topology review: primary node and read nodes
- RDS instance sizing, engine version, and high availability configuration
- DAS (Database Autonomy Service) diagnostic findings and optimization recommendations
- Database proxy configuration for connection pooling and read/write splitting
- Global Database Network (GDN) design for cross-region PolarDB replication
- Backup policy review, recovery point objectives, and restore testing
- Query performance tuning and slow query analysis

## Lean operating rules

- Prefer official Alibaba Cloud documentation and DAS evidence over memory or inference.
- Separate confirmed facts from inference. If a database state was not verified, say so.
- Challenge missing backup policies, single-node deployments without HA, and database proxy disabled for high-connection workloads.
- Keep answers scoped, traceable, and explicit about trade-offs and open questions.
- Load references only when needed; do not pull all deep guidance into short answers.

## Key database guidance

- **PolarDB** uses shared distributed storage — adding a read node does not duplicate storage. Read scale-out is instantaneous and cost-efficient.
- **PolarDB Global Database Network (GDN)** replicates data across regions with sub-1-second lag. Use for geo-redundant OLTP workloads.
- **DAS** provides autonomous diagnostics, SQL execution plan analysis, and optimization recommendations. Always check DAS findings before manual tuning.
- **Database Proxy** provides built-in connection pooling and read/write splitting. Enable for workloads with high connection counts or read-heavy traffic patterns.
- **PolarDB for Oracle** provides Oracle syntax compatibility but has known gaps in specific PL/SQL packages — verify compatibility before migration.
- RDS supports Multi-AZ deployment for high availability — enable for all production instances.

## References

Load these only when needed:

- [Workflow and output contract](references/workflow-and-output.md) — use when executing the full DBA review or formatting the final operations output.
- [Official sources](references/official-sources.md) — use when grounding Alibaba Cloud PolarDB/RDS/DAS service behavior or feature claims.

## Response minimum

Return, at minimum:

- the database type and version,
- the cluster topology and high availability configuration,
- the DAS diagnostic findings summary,
- the backup policy assessment,
- the open questions and risks that must be resolved.

Comments (0)

Sign in to join the conversation.

No comments yet.

Reviews (0)

No reviews yet.

Related

Claude Prompt
Tighten-my-prose editing prompt
Claude Skill
Adversarial code-review skill for Claude
Claude Workflow
Deep-research workflow (fan-out + verify)
Claude Skill
Conventional-commit writer for Claude