A specialized skill for AI agents to search Alibaba Cloud databases and perform SQL operations via the DMS OpenAPI.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install alibabacloud-dms-skill
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install alibabacloud-dms-skill using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Alibaba Cloud DMS Database Read/Write Skill?
The Alibaba Cloud DMS Database Read/Write Skill allows AI agents to interact directly with databases managed by Alibaba Cloud Data Management Service (DMS). By integrating this skill into Openclaw Skills workflows, developers can search for database instances using keywords and execute SQL queries or data modifications through a secure command-line interface. It bridges the gap between AI-driven task management and cloud-hosted database administration.
This skill is designed with a focus on safety and precision, requiring strict session management and providing granular control over data operations. It leverages the Alibaba Cloud CLI to interact with DMS OpenAPI, making it an essential tool for automated cloud data management within the Openclaw Skills ecosystem.
Alibaba Cloud DMS Database Read/Write Skill Use Cases
- Searching for specific database IDs across large Alibaba Cloud environments using simple keywords.
- Fetching live data for analysis or reporting via SELECT and SHOW queries.
- Performing safe data modifications such as INSERT, UPDATE, or DELETE with mandatory safety flags.
- Automating routine database maintenance tasks within an AI-assisted DevOps pipeline.
How Alibaba Cloud DMS Database Read/Write Skill Works
- The agent initiates a search for the target database using a keyword to retrieve the unique Database ID.
- The system identifies the database schema, host, and port to ensure the correct target is selected.
- The user provides or confirms the SQL statement to be executed against the identified database.
- For read operations, the skill executes the query and returns the formatted data results.
- For write operations, the skill requires a dry-run preview or a force flag to proceed with modification.
- The session is closed by disabling AI-Mode to ensure security and prevent identity leakage.
Alibaba Cloud DMS Database Read/Write Skill Setup
To prepare the environment for this skill, follow these installation and configuration steps:
# Ensure Aliyun CLI >= 3.3.3 is installed
aliyun version
# Enable AI-Mode to initiate the session
aliyun configure ai-mode enable
# Register the specific skill User-Agent for tracking
aliyun configure ai-mode set-user-agent AlibabaCloud-Agent-Skills/alibabacloud-dms-skill
# Enable automatic plugin installation and update
aliyun configure set --auto-plugin-install true && aliyun plugin update
Alibaba Cloud DMS Database Read/Write Skill Data Schema & Taxonomy
The skill processes and returns data structured for easy programmatic consumption. Below is the metadata taxonomy used during database interactions:
| Attribute | Description | Format |
|---|---|---|
| database_id | The unique identifier for the target database | Positive Integer |
| schema_name | The name of the database schema | String |
| db_type | The engine type (e.g., MySQL, PostgreSQL) | String |
| sql_output | Results of the query execution | JSON Array |
| success_flag | Status of the executed command | Boolean |
Alibaba Cloud DMS Database Read/Write Skill Advanced Features
- Multi-stage write protection that blocks dangerous DDL operations like DROP or TRUNCATE by default.
- Dry-run capability allowing users to preview the impact of DML statements before execution.
- Logic database mode support for managing complex, distributed database architectures.
- Integrated AI-Mode lifecycle management which is a core security feature of Openclaw Skills.
- Built-in JSON output formatting to facilitate seamless integration with other data processing tools.
SKILL.md
Loading
Related Openclaw Skills
Work Style Memory
Transform repetitive manual tasks into a library of reusable, local SOPs that your AI agent proactively suggests and follows.
Dropbox Download
A specialized skill designed to programmatically retrieve and download files from Dropbox accounts using OAuth2 authentication.
Joy Growth Power
A sophisticated AI analysis tool designed to transform child-parent dialogues into actionable psychological insights and developmental tracking data.
Project Trident: Persistent Memory Architecture
Project Trident is a production-grade, four-tier persistent memory architecture designed to provide AI agents with long-term identity, session continuity, and disaster resilience.
SEAP Shopping Skill
A robust shopping automation skill for Openclaw Skills that enables AI agents to handle product searches and secure transactions for both immediate and scheduled needs.
Summon Translator
Translate compliance-critical files, safety procedures, and eLearning content into 137+ languages with AI precision.
Featured*
