Data & analysis

Alibaba Cloud Database Analyticdb Mysql

Manage and verify AnalyticDB for MySQL resources through Alibaba Cloud OpenAPI or official SDKs.

What it does

Manage Alibaba Cloud AnalyticDB for MySQL resources through RPC OpenAPI calls using official SDKs or OpenAPI Explorer. The workflow confirms region and resource IDs, discovers API schemas for product code `adb` and version `2021-12-01`, executes list or mutation operations, then verifies outcomes with describe/list APIs. Artifacts and response summaries are saved under the designated output directory.

When to use it

  • Inventorying AnalyticDB for MySQL resources
  • Creating or updating AnalyticDB configuration
  • Checking resource status and troubleshooting
  • Discovering ADB OpenAPI schemas

The skill document

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  --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

Questions people ask

How does it determine which AnalyticDB API and parameters to use?
It uses OpenAPI metadata endpoints to list APIs and retrieve schemas, defaulting to product code `adb` and API version `2021-12-01`.
Where does it get Alibaba Cloud credentials and the region?
It prioritizes `ALICLOUD_ACCESS_KEY_ID`, `ALICLOUD_ACCESS_KEY_SECRET`, and optional `ALICLOUD_REGION_ID` environment variables, then `~/.alibabacloud/credentials`. If the region is unclear, it asks before mutating resources.
How are operations checked and documented?
Results are verified with describe/list APIs. Artifacts, command output, response summaries, and reproducibility parameters are written under `output/alicloud-database-analyticdb-mysql/`.

Related skills

Fetch raw JSON for ad creatives, apps, rankings, market data, and download or revenue estimates.

4.3k installs296 stars

Create or revise Draw.io, Mermaid, and Excalidraw diagrams from natural-language requirements.

1.0k installs47 stars

Search, read, query, and—with explicit approval—modify content in connected Notion workspaces.

339 installs8 stars

Read and manage Google Merchant Center resources through v1 APIs with managed OAuth and approval-gated writes.

231 installs5 stars

Convert Chinese finance questions into checked Tushare research workflows, summaries, and data files.

559 installs33 stars

Access supported Square resources through managed OAuth for read and approved administrative operations.

229 installs3 stars