Alicloud Database Analyticdb Mysql

Manage Alibaba Cloud AnalyticDB for MySQL (ADB) via OpenAPI/SDK. Use whenever the user needs AnalyticDB resource lifecycle and configuration operations, stat...

Security Scan

The skill's code and runtime instructions align with its stated purpose of managing Alibaba Cloud AnalyticDB (it fetches public OpenAPI metadata and instructs using Alibaba Cloud credentials), with only a minor metadata omission about required environment variables.

Purpose & Capability

Name/description match the included files: SKILL.md explains using Alibaba Cloud OpenAPI/SDK for AnalyticDB; the provided script enumerates OpenAPI metadata for the adb product. The requested capabilities (calling OpenAPI, using SDKs) are appropriate for this purpose.

Instruction Scope

SKILL.md stays on-task: it documents discovery-first workflows, outlines credential sources, suggests verifications, and limits outputs to a skill-specific output/ path. It does not instruct reading unrelated system files or exfiltrating data to external endpoints other than aliyun api endpoints referenced for API metadata.

Install Mechanism

No install spec is provided (instruction-only plus a small script). The included Python script is small, uses standard library urllib, and only fetches from official api.aliyun.com URLs. No downloads from untrusted URLs or archive extraction.

Credentials

SKILL.md sensibly requires Alibaba Cloud credentials (ALICLOUD_ACCESS_KEY_ID, ALICLOUD_ACCESS_KEY_SECRET, optional ALICLOUD_REGION_ID) which are appropriate for making API calls. However, the registry metadata lists no required env vars or primary credential — this mismatch is a minor but noteworthy omission that could mislead users about the need to provide credentials.

Persistence & Privilege

Skill is not always-enabled, is user-invocable, and does not request system-wide changes. It writes artifacts only under a skill-scoped output path. No elevated persistence or modification of other skills/configs is present.

Assessment

This skill appears to do what it claims: it helps discover and call Alibaba Cloud AnalyticDB OpenAPI endpoints. Before installing, ensure you: (1) provide least-privilege Alibaba Cloud credentials (ALICLOUD_ACCESS_KEY_ID and ALICLOUD_ACCESS_KEY_SECRET) to the agent environment or the shared ~/.alibabacloud/credentials file; (2) confirm the agent will ask or you will provide the correct region before any mutating operations; and (3) review the output directory (output/alicloud-database-analyticdb-mysql/) for saved artifacts. The only inconsistency is that the registry metadata does not declare the env vars the SKILL.md expects — treat the credentials requirement as real even though it's not listed in the metadata.

Category: service

AnalyticDB for MySQL

Use Alibaba Cloud OpenAPI (RPC) with official SDKs or OpenAPI Explorer to manage resources for AnalyticDB for MySQL.

Workflow

1. Confirm region, resource identifiers, and desired action.
2. Discover API list and required parameters (see references).
3. Call API with SDK or OpenAPI Explorer.
4. Verify results with describe/list APIs.

AccessKey priority (must follow)

1. Environment variables: ALICLOUD_ACCESS_KEY_ID / ALICLOUD_ACCESS_KEY_SECRET / ALICLOUD_REGION_ID Region policy: ALICLOUD_REGION_ID is an optional default. If unset, decide the most reasonable region for the task; if unclear, ask the user.
2. Shared config file: ~/.alibabacloud/credentials

API discovery

• Product code: adb
• Default API version: 2021-12-01
• Use OpenAPI metadata endpoints to list APIs and get schemas (see references).

High-frequency operation patterns

1. Inventory/list: prefer List* / Describe* APIs to get current resources.
2. Change/configure: prefer Create* / Update* / Modify* / Set* APIs for mutations.
3. Status/troubleshoot: prefer Get* / Query* / Describe*Status APIs for diagnosis.

Minimal executable quickstart

Use metadata-first discovery before calling business APIs:

python scripts/list_openapi_meta_apis.py

Optional overrides:

python scripts/list_openapi_meta_apis.py --product-code <ProductCode> --version <Version>

The script writes API inventory artifacts under the skill output directory.

Output policy

If you need to save responses or generated artifacts, write them under: output/alicloud-database-analyticdb-mysql/

Validation

mkdir -p output/alicloud-database-analyticdb-mysql
for f in skills/database/analyticdb/alicloud-database-analyticdb-mysql/scripts/*.py; do
  python3 -m py_compile "$f"
done
echo "py_compile_ok" > output/alicloud-database-analyticdb-mysql/validate.txt

Pass criteria: command exits 0 and output/alicloud-database-analyticdb-mysql/validate.txt is generated.

Output And Evidence

• Save artifacts, command outputs, and API response summaries under output/alicloud-database-analyticdb-mysql/.
• Include key parameters (region/resource id/time range) in evidence files for reproducibility.

Prerequisites

• Configure least-privilege Alibaba Cloud credentials before execution.
• Prefer environment variables: ALICLOUD_ACCESS_KEY_ID, ALICLOUD_ACCESS_KEY_SECRET, optional ALICLOUD_REGION_ID.
• If region is unclear, ask the user before running mutating operations.

References

• Sources: references/sources.md