alicloud-database-analyticdb-mysqlManage Alibaba Cloud AnalyticDB for MySQL (adb) via OpenAPI/SDK. Use for listing resources, creating or updating configurations, querying status, and troubleshooting workflows for this product.
Install via ClawdBot CLI:
clawdbot install cinience/alicloud-database-analyticdb-mysqlCategory: service
Use Alibaba Cloud OpenAPI (RPC) with official SDKs or OpenAPI Explorer to manage resources for AnalyticDB for MySQL.
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.
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
adb2019-03-151) 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.
Use metadata-first discovery before calling business APIs:
python scripts/list_openapi_meta_apis.pyOptional overrides:
python scripts/list_openapi_meta_apis.py --product-code <ProductCode> --version <Version>The script writes API inventory artifacts under the skill output directory.
If you need to save responses or generated artifacts, write them under:
output/alicloud-database-analyticdb-mysql/
references/sources.mdGenerated Mar 1, 2026
AnalyticDB for MySQL is used to manage large-scale data warehouses for enterprises requiring real-time analytics. This scenario involves creating and configuring clusters, scaling resources based on workload demands, and monitoring performance to optimize query execution and data storage efficiency.
Organizations leverage this skill to automate the setup and maintenance of databases for BI tools, enabling seamless data ingestion and transformation. It supports generating reports, dashboards, and ad-hoc queries by ensuring high availability and fast query responses for decision-making processes.
In IoT applications, this skill helps handle streaming data from devices by configuring AnalyticDB for MySQL to store and analyze time-series data. It involves setting up clusters, tuning parameters for high-throughput ingestion, and troubleshooting latency issues to support real-time monitoring and predictive maintenance.
SaaS providers use this skill to manage isolated database instances for different clients, ensuring data security and performance. It includes automating resource provisioning, scaling based on tenant usage patterns, and implementing backup and recovery strategies to maintain service level agreements.
Offer a managed service where customers pay a monthly fee for access to AnalyticDB for MySQL with automated scaling, monitoring, and support. This model generates recurring revenue by providing value-added features like performance optimization and security enhancements tailored to client needs.
Provide expert services to help businesses integrate AnalyticDB for MySQL into their infrastructure, including setup, migration, and customization. Revenue comes from project-based fees for design, deployment, and training, with potential upsells for ongoing maintenance and optimization contracts.
Leverage Alibaba Cloud's pricing to offer a flexible model where clients pay only for the database resources they consume, such as compute and storage. This attracts startups and variable workloads by minimizing upfront costs, with revenue derived from margins on cloud resource usage and management fees.
💬 Integration Tip
Ensure environment variables for access keys are set before API calls to avoid authentication errors, and use the provided scripts for API discovery to streamline workflow execution.
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Manage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme; read/search/list from the local Things database). Use when a user asks Clawdbot to add a task to Things, list inbox/today/upcoming, search tasks, or inspect projects/areas/tags.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Query, design, migrate, and optimize SQL databases. Use when working with SQLite, PostgreSQL, or MySQL — schema design, writing queries, creating migrations, indexing, backup/restore, and debugging slow queries. No ORMs required.