huawei-cloud-rds-list

Huawei Cloud RDS List Skill

Overview

This skill queries the list of Relational Database Service (云数据库 RDS) instances under the current Huawei Cloud tenant / project and returns their key attributes — by default only the RDS instance names (name, one per line), optionally together with id, status, type, engine, version, flavor, private_ips and created time. It is a read-only inspection skill: it never creates, modifies, deletes, restarts or stops any database instance.

Architecture:

Agent → hcloud CLI (KooCLI, RDS ListInstances, primary) → Huawei Cloud RDS v3 API
       ↘ huaweicloudsdkrds Python SDK (fallback)                  ↗

API path (verified from huaweicloudsdkrds v3 SDK _list_instances_http_info):

Execution-quality reporting: every invocation of scripts/list_rds_instances.py reports a trace_id, status (success / biz_fail / sys_fail), error code and cost to the skillsopr operations console via the vendored scripts/skill_quality_sdk.py. Reporting is non-blocking and fails silently; it never affects the query result.

Applicable Scenarios:

• Database inventory: "list all RDS instances of this tenant" or "show me the RDS name list"
• Daily inspection: snapshot of all RDS instances with their status and engine
• Cost review: enumerate RDS instances and their flavors to spot unused or oversized databases
• Fast lookup: retrieve the exact RDS instance name/id for follow-up operations
• Auto detection: periodic checks that detect new/stopped/error RDS instances

能力边界（Capability Boundary）： 本 Skill 仅查询 RDS 实例列表。不创建/删除/修改/重启/停止 RDS 实例， 也不查询备份、参数组、日志等其它 RDS 资源。 若用户询问"创建/删除 RDS"、"重启 RDS"、"查询备份"等， 请明确告知本 Skill 不提供该能力。

Prerequisites

1. hcloud CLI (KooCLI) installed and authenticated — See references/cli-installation-guide.md
2. Python 3.8+ with huaweicloudsdkrds package installed (SDK fallback only)
3. IAM permissions — rds:instance:list (or the system policy RDS ReadOnlyAccess) is required to list RDS instances. See references/iam-policies.md
4. A region where the tenant owns RDS instances; specify it with --cli-region

Workflow

1. Identify the intent — Confirm the user wants to list RDS instances (and optionally the filters: name, id, type, engine, or name-only output).
2. Confirm region — Default cn-north-4; let the user override with another region if needed.
3. Run the query — Use the CLI command below with the requested filters.
4. Present the results — By default output only the RDS instance names (one per line); with --compact or full JSON output show the extra fields.
5. Handle errors — If the CLI fails (credentials/permissions/network), retry with the SDK fallback described in references/verification-method.md.

Core Commands

KooCLI format: hcloud --cli-region= [--key=value]

List all RDS instances (full JSON)

hcloud RDS ListInstances --cli-region={region} --cli-output=json

List only the RDS instance names

hcloud RDS ListInstances --cli-region={region} --cli-query="instances[].name"

Compact fields: name, id, status, engine

hcloud RDS ListInstances --cli-region={region} --cli-output=json \
  | jq -r '.instances[] | [.name, .id, .status, .datastore.type] | @tsv'

Filter by engine / type / name / VPC

hcloud RDS ListInstances --cli-region={region} --datastore_type=MySQL --cli-output=json
hcloud RDS ListInstances --cli-region={region} --type=Ha --cli-output=json
hcloud RDS ListInstances --cli-region={region} --name={instance-name} --cli-output=json
hcloud RDS ListInstances --cli-region={region} --vpc_id={vpc-id} --cli-output=json

Pagination

hcloud RDS ListInstances --cli-region={region} --limit=100 --offset=0 --cli-output=json

Quality-reporting wrapper script (recommended)

python3 scripts/list_rds_instances.py --region={region} --names-only
python3 scripts/list_rds_instances.py --region={region} --type Ha --limit 20 --compact

The wrapper tries the CLI first, falls back to the huaweicloudsdkrds SDK, and reports execution quality to the skillsopr console. Set SKILL_QUALITY_DISABLE=1 to disable reporting (local debugging).

Parameter Confirmation

KooCLI Command Format Standard

The KooCLI command format is:

hcloud --cli-region= [--key=value ...]

Note: this is a generic format template, not an executable command — replace , , `` and the parameters with real values (e.g. hcloud RDS ListInstances --cli-region=cn-north-4).

• Service name: RDS (starts with uppercase).
• Operation name: PascalCase — ListInstances.
• Region: always pass --cli-region=.
• Simple parameters use --key=value, for example --name=rds-prod.
• Pagination parameters: --limit=N, --offset=N (index offset).

Reference Documents

• IAM Policies — Least-privilege IAM permissions
• CLI Installation Guide — hcloud CLI setup and authentication
• Verification Method — How to verify the skill works
• Dataflow Diagram — Request flow diagram
• Acceptance Criteria — Acceptance test checklist