mcpField
A
aliyun-adb-mysql

aliyun-adb-mysql

github.com/cinienceData & databases39658 installsUpdated 11w ago
Repository

About aliyun-adb-mysql

This skill manages AnalyticDB for MySQL resources through Alibaba Cloud OpenAPI, for cloud workflows that inspect, configure, or troubleshoot database resources. It emphasizes discovering APIs and parameters before acting, then verifying results.

Key features

  1. 01Discover OpenAPI methods and schemas
  2. 02List and describe resources
  3. 03Create or change resource settings
  4. 04Check status and troubleshoot
  5. 05Save operation evidence and response summaries

Use cases

  1. 01Inventory AnalyticDB for MySQL resources
  2. 02Create or adjust resource settings
  3. 03Inspect resource status and diagnose issues

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/cinience/alicloud-skills --skill aliyun-adb-mysql

After installing, type/aliyun-adb-mysqlin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

agents/
openai.yaml
references/
sources.md
scripts/
list_openapi_meta_apis.py

Details

From the project README

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: ALIBABACLOUD_ACCESS_KEY_ID / ALIBABACLOUD_ACCESS_KEY_SECRET / ALIBABACLOUD_REGION_ID Region policy: ALIBABACLOUD_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/aliyun-adb-mysql/

Validation

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

Pass criteria: command exits 0 and output/aliyun-adb-mysql/validate.txt is generated.

Output And Evidence

  • Save artifacts, command outputs, and API response summaries under output/aliyun-adb-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: ALIBABACLOUD_ACCESS_KEY_ID, ALIBABACLOUD_ACCESS_KEY_SECRET, optional ALIBABACLOUD_REGION_ID.
  • If region is unclear, ask the user before running mutating operations.

References

  • Sources: references/sources.md

Comments

Markdown supported