Fetch raw JSON for ad creatives, apps, rankings, market data, and download or revenue estimates.
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
- Confirm region, resource identifiers, and desired action.
- Discover API list and required parameters (see references).
- Call API with SDK or OpenAPI Explorer.
- Verify results with describe/list APIs.
AccessKey priority (must follow)
- Environment variables:
ALICLOUD_ACCESS_KEY_ID/ALICLOUD_ACCESS_KEY_SECRET/ALICLOUD_REGION_IDRegion policy:ALICLOUD_REGION_IDis an optional default. If unset, decide the most reasonable region for the task; if unclear, ask the user. - 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
- Inventory/list: prefer
List*/Describe*APIs to get current resources. - Change/configure: prefer
Create*/Update*/Modify*/Set*APIs for mutations. - Status/troubleshoot: prefer
Get*/Query*/Describe*StatusAPIs 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, optionalALICLOUD_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
Create or revise Draw.io, Mermaid, and Excalidraw diagrams from natural-language requirements.
Search, read, query, and—with explicit approval—modify content in connected Notion workspaces.
Read and manage Google Merchant Center resources through v1 APIs with managed OAuth and approval-gated writes.
Convert Chinese finance questions into checked Tushare research workflows, summaries, and data files.
Access supported Square resources through managed OAuth for read and approved administrative operations.