A robust Docker-based MySQL management skill for handling container lifecycles, database creation, and cross-instance data synchronization.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install mysql-manager
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 mysql-manager 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 MySQL Manager?
MySQL Manager is a specialized tool within the Openclaw Skills collection designed to manage shared MySQL Docker containers in local development environments. It provides a standardized way to handle database persistence, cross-instance data dumps, and lifecycle management, ensuring that developers have a consistent and isolated database environment that integrates seamlessly with other services like proxy-manager and worktree-manager.
By leveraging Docker volumes and a unified networking layer, this skill allows for rapid spinning up of databases for specific git worktrees or feature branches. It emphasizes security and reliability by enforcing strict regex validation for database names and pinning specific MySQL versions to prevent environment drift.
MySQL Manager Use Cases
- Creating isolated database instances for different git worktrees or development branches.
- Migrating or snapshotting production-like data from a main database to a feature-specific instance.
- Automating the startup sequence of development stacks involving proxies, databases, and application containers.
- Standardizing local database configurations across a distributed development team using Openclaw Skills.
How MySQL Manager Works
- The user initiates the skill via a trigger command which interacts with the run.sh script.
- The script checks for the existence of the shared Docker network (nginx-proxy_net) and joins it.
- A MySQL 8.0 container is deployed with a persistent volume to ensure data survives container restarts.
- Administrative commands allow the user to create, drop, or list databases using secure SQL execution patterns.
- For data synchronization, the skill utilizes a two-step docker exec process to dump data from a source database and pipe it into a destination database safely.
MySQL Manager Setup
To install and configure this component of Openclaw Skills, ensure Docker is installed and follow these steps:
# Navigate to the skill directory
cd mysql-manager
# Start the MySQL container
./run.sh start
# (Optional) Create a .env file to customize the root password or port
echo "MYSQL_ROOT_PASSWORD=your_secure_password" > .env
MySQL Manager Data Schema & Taxonomy
The skill organizes data and configuration through a combination of environment variables and Docker volumes:
| Component | Type | Description |
|---|---|---|
| mysql_data | Docker Volume | Named volume for persistent database storage. |
| codai_db | Container | The default hostname for backend connections. |
| .env | Configuration | Local file for overrides (Password, Port, DB Name). |
| 127.0.0.1:3307 | Network | Default host binding for local database access. |
MySQL Manager Advanced Features
- Multi-agent synchronization: Designed to work in a specific startup order behind proxy-manager.
- Automatic Recovery: Uses restart policies to ensure the database resumes after Docker daemon restarts.
- Security Hardening: Includes protection against shell injection and binds only to the local loopback interface.
- Validation Logic: Strict regex checking for all database operations to maintain system integrity within Openclaw Skills.
SKILL.md
Loading
Related Openclaw Skills
Proxy Manager
A specialized Docker-based routing hub that auto-discovers application containers and manages shared networks for seamless development environments.
PostgreSQL Manager
A specialized tool for managing a shared PostgreSQL Docker lifecycle, including container persistence, database creation, and cross-instance snapshots.
Codai
Codai is a centralized orchestration skill for managing local development environments, routing complex commands to specialized database and proxy managers.
Suspicious Message Safety Check
A specialized safety workflow designed to triage suspicious communications and identify potential fraud or phishing attempts without interacting with dangerous content.
Campbell Soup History and Analysis
A comprehensive analytical skill for researching the historical evolution, business model, and cultural impact of the Campbell Soup Company.
Bouygues Industrial Intelligence
A comprehensive intelligence skill for analyzing the Bouygues Group, a French industrial titan spanning construction, media, and telecommunications.
Featured*
