huawei-cloud-rds-list

Query the list of Huawei Cloud RDS (Relational Database Service, 云数据库) instances under the current tenant / project and return the RDS instance NAMES. By default the skill prints only the instance names (one per line); with extra flags it also returns id, status, engine type, flavor, private IPs and created time. Supports filtering by instance name, id, type (Single/Ha/Replica), datastore engine (MySQL/PostgreSQL/SQLServer/MariaDB) and VPC, plus pagination via limit/offset. Uses the KooCLI command hcloud RDS ListInstances --cli-region={region} (primary) or the huaweicloudsdkrds Python SDK (fallback). Read-only — never creates, modifies, deletes, restarts or stops any RDS instance. Use this skill whenever the user wants to list/inspect the RDS instances of the tenant or query the RDS instance name list, e.g. for database inventory, daily inspection, or cost review. Triggers include: "list RDS", "RDS list", "query RDS names", "RDS实例列表", "查询RDS", "RDS实例名称", "rds list", "how many RDS", "RDS inventory", "list database instances", "云数据库实例".

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

text

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:

Operation	Method	API Path
List RDS instances	GET	/v3/{project_id}/instances

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 不提供该能力。

写意图检测（Write Intent Detection）

本 Skill 严格只读，不提供任何写入能力。在使用本 Skill 前，必须 对用户输入进行写意图检测。检测规则如下：

检测规则

用户输入包含以下关键词/意图时，判定为写意图，禁止调用脚本：

类别	中文关键词	英文关键词
创建	创建、新建、开通、申请、购买、新增、部署、搭建、建立	create、new、provision、deploy、setup、launch、buy、purchase、build
删除	删除、移除、释放、销毁、清理、清理掉、干掉	delete、remove、drop、destroy、cleanup、release、terminate、remove
修改	修改、更新、变更、调整、升级、降级、扩容、缩容、编辑	update、modify、change、alter、edit、upgrade、resize、scale
重启/停止	重启、停止、关闭、启动、开机、关机	restart、stop、start、shutdown、reboot、power off
其他写入	导入、导出、迁移、备份、恢复、克隆、复制	import、export、migrate、backup、restore、clone、copy

处理流程

1. 接收用户输入后，使用上述规则进行意图分类
2. 判定为写意图 → 立刻返回只读提示，不调用 list_rds_instances.py
3. 判定为查询意图 → 正常调用脚本执行查询

响应模板（中文）

当检测到写意图时，返回以下格式（请用中文回复）：

本 Skill（huawei-cloud-rds-list）为 只读查询 工具，仅支持查询 RDS 实例列表， 不支持创建/删除/修改/重启等写入操作。

如需执行写入操作，请登录华为云控制台完成：

• RDS 控制台：https://console.huaweicloud.com/rds
• 或使用华为云 CLI（hcloud）相关命令

您可以查询以下只读信息：

• 查询所有 RDS 实例列表
• 按名称/ID/类型/引擎/状态过滤 RDS 实例
• 查看实例规格、IP、创建时间等详情

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 <Service> <Operation> --cli-region=<region> [--key=value]

List all RDS instances (full JSON)

bash

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

List only the RDS instance names

bash

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

Compact fields: name, id, status, engine

bash

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

Filter by engine / type / name / VPC

bash

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

bash

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

Quality-reporting wrapper script (recommended)

bash

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

Parameter	Required	Description	Example
{region}	Yes	Huawei Cloud region	cn-north-4
--name	No	Instance name filter (exact or *fuzzy* match)	rds-prod
--id	No	Instance ID filter (exact or *fuzzy* match)	e229f7f2...in01
--type	No	Instance type: Single/Ha/Replica	Ha
--datastore_type	No	Engine: MySQL/PostgreSQL/SQLServer/MariaDB	MySQL
--vpc_id	No	VPC ID filter	81a7f347-...
--limit	No	Max records per page (1–100, default 100)	100
--offset	No	Index offset (≥ 0, default 0)	0
--names-only	No	Print only the instance names (one per line)	--names-only
--compact	No	Print name/id/status/engine as TSV rows	--compact

KooCLI Command Format Standard

The KooCLI command format is:

hcloud <Service> <Operation> --cli-region=<region> [--key=value ...]

Note: this is a generic format template, not an executable command — replace <Service>, <Operation>, <region> 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=<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 — KooCLI installation and authentication
• Verification Method — How to verify the skill works
• Dataflow Diagram — Request flow diagram
• Acceptance Criteria — Acceptance test checklist