A comprehensive tool for managing database lifecycles and migrations within the Openclaw Skills ecosystem.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install database-migration-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 database-migration-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 Database Migration Manager?
The Database Migration Manager is a robust solution designed to streamline database schema management within your Openclaw Skills environment. It acts as an intelligent intermediary that detects your project's specific ORM or migration framework, such as Prisma, Drizzle, or Alembic, and provides a standardized workflow for evolving your data layer. By incorporating this skill into your development process, you gain a high-level interface for generating migrations, applying changes safely, and maintaining consistency across development, staging, and production environments. Using this specific skill allows your AI agent to handle complex data operations while adhering to industry-standard safety protocols, making it a cornerstone for teams leveraging Openclaw Skills for full-stack automation.
Database Migration Manager Use Cases
- Generating and running migrations for popular ORMs like Prisma, Drizzle, and TypeORM.
- Safely rolling back database changes to a previous state during troubleshooting.
- Synchronizing schemas between different environments to ensure parity in your Openclaw Skills projects.
- Creating realistic, environment-aware seed data for testing and local development.
- Implementing complex, multi-deploy schema changes without taking your application offline.
How Database Migration Manager Works
- Scans the project directory to identify the active migration tool or ORM by detecting signature files like schema.prisma, drizzle.config.ts, or manage.py.
- Analyzes the user's request to classify the required operation, such as generation, application, rollback, or seeding.
- Sources database credentials from existing local environment files (.env, .env.local) to ensure secure connectivity without storing passwords.
- Executes the appropriate CLI commands for the detected tool, handling technical nuances like Prisma's deployment mode or Alembic's revision tracking.
- Performs safety checks, including mandatory backups for production databases and user confirmation for any destructive SQL operations.
Database Migration Manager Setup
To use this within your Openclaw Skills setup, ensure your project includes a supported migration tool and valid database credentials in your environment.
# Example: Prepare a Prisma project
npm install prisma --save-dev
npx prisma init
# Example: Prepare a Drizzle project
npm install drizzle-kit --save-dev
The skill will automatically utilize your existing .env file to connect to your database.
Database Migration Manager Data Schema & Taxonomy
The skill manages database metadata and migration files according to the detected framework's standards. Below is how common tools organize their data:
| Tool | Migration Path | Tracking Mechanism |
|---|---|---|
| Prisma | prisma/migrations/ |
_prisma_migrations table |
| Drizzle | drizzle/ |
Migration hash files |
| Alembic | alembic/versions/ |
alembic_version table |
| Django | [app]/migrations/ |
django_migrations table |
| Raw SQL | migrations/ |
_migrations custom table |
Database Migration Manager Advanced Features
- Support for the expand-contract pattern to ensure zero-downtime deployments within your Openclaw Skills workflow.
- Automated database backups for Postgres, MySQL, and SQLite before any destructive operations.
- Advanced schema diffing to detect drift between remote environments and local source code.
- Idempotent data seeding logic that supports environment-specific configurations.
- Concurrent index creation and safe foreign key addition to prevent production table locking.
SKILL.md
Loading
Related Openclaw Skills
Wyckoff Stock Diagnostic Tool
A sophisticated A-Share stock diagnostic tool implementing the Wyckoff 2.0 methodology for automated technical analysis and structural identification.
Xiaomi MiMo TTS Proxy
A local proxy service that converts OpenAI TTS API requests into Xiaomi MiMo platform calls with integrated FFmpeg transcoding.
Video Maker AI Free
An advanced AI skill that transforms scripts, images, and raw ideas into polished, production-ready videos without manual editing.
Umeng Mini-Program Campaign Manager
A command-line skill for managing Umeng Mini-Program promotion links, campaigns, and channel assets.
Bilibili Danmaku Sentiment Analysis
A specialized tool for extracting Bilibili danmaku and performing automated sentiment and rhythm analysis using large language models.
Ravi SSO
A specialized tool for generating short-lived identity verification tokens to authenticate with third-party services using your Ravi profile.
Featured*
