A local-first AI coding agent skill designed to classify database migrations, expose runtime production risks, and recommend zero-downtime deployment sequences.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install database-migration-risk-review
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-risk-review 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 Risk Review?
The Database Migration Risk Review skill empowers AI coding agents to systematically evaluate database schema and data modifications before they hit production. Operating entirely in a local, self-contained standalone mode, this capability acts as an automated database administrator, screening changes for common deployment hazards. By analyzing the provided migration code, it helps developers prevent production downtime, data degradation, and performance bottlenecks without needing an external cloud connection.
At its core, this Openclaw Skills addition guides the agent to prioritize expand-contract (parallel design) sequencing over risky, destructive single-deploy updates. It ensures that every database modification is accompanied by concrete verification steps, dry-run plans, and strict monitoring criteria, helping modern development teams shift database reliability engineering left into their automated workflows.
Database Migration Risk Review Use Cases
- Pre-deployment Migration Auditing: Automatically scan raw SQL or ORM migration files during local development to catch unsafe structural changes.
- Zero-Downtime Rollout Planning: Convert potentially destructive database alterations into safe, multi-step expand-contract deployment phases.
- Risk Profiling for Code Reviews: Generate comprehensive risk reports highlighting lock durations, compatibility issues, and replication lag considerations for pull requests.
- Data Backfill Strategy Drafting: Design safe, batched data migration and backfill pathways that avoid overwhelming production database replicas.
How Database Migration Risk Review Works
- Migration Classification: The agent parses the provided migration code and classifies it into distinct operational types, such as additive schema, destructive schema, index additions, data backfills, constraints, or enum/type changes.
- Production Risk Identification: It meticulously evaluates the changes against a checklist of production risks, specifically focusing on exclusive table locks, backward/forward application compatibility, nullable/default value behaviors, replication lag, and read-model effects.
- Sequence Optimization: The skill enforces working principles that favor the smallest, safest change possible, substituting destructive immediate actions with a decoupled expand-contract sequence.
- Verification Strategy Formulation: It generates a robust verification blueprint encompassing database dry runs,
EXPLAINquery plan analysis, affected test identification, and specific canary or monitoring metrics. - Optional Knowledge Capture: Upon task completion, the agent assesses if any reusable architectural decisions or durable conventions were uncovered, offering to save them locally using the Open Knowledge Format (OKF).
Database Migration Risk Review Setup
This skill operates locally in standalone mode and does not require a mandatory platform connection. Simply instruct your AI coding agent to execute the migration review process using the framework provided by Openclaw Skills.
To upgrade the workflow with deep workspace discovery, structured cross-team exploration, and team alignment gates, you can optionally configure the cloud integration:
# Install the global command-line interface
npm install -g @ritualai/cli
# Initialize the workspace connection
ritual init
# Verify your connectivity and status
ritual status
Database Migration Risk Review Data Schema & Taxonomy
The skill runs statelessly by default but can programmatically capture engineering insights. When a reusable pattern or migration risk is discovered and approved by the user, it structures and saves a portable Open Knowledge Format (OKF) markdown file under the following taxonomy:
knowledge/engineering/<slug>.md
Metadata Frontmatter Schema
| Field | Type | Description |
|---|---|---|
type |
String | The category of knowledge captured (e.g., API Convention, DB Pattern). |
title |
String | A concise, single-line title of the engineering rule. |
description |
String | A brief summary explaining what was learned during the migration task. |
resource |
String | A relative file path pointing to the original migration or evidence file. |
tags |
Array | Relevant taxonomy labels for categorization. |
timestamp |
String | The execution date and time formatted in ISO 8601. |
File Content Taxonomy
Each generated markdown note adheres to a strict structural layout including a Summary (1-2 lines of the rule), Applies to (scope of enforcement), Evidence (raw source observations), and Use in future agent work (explicit execution logic for subsequent agent runs).
Database Migration Risk Review Advanced Features
- Local-First Isolation: Complete local execution guarantee ensuring no private migration code, schema structures, or credential metadata are transmitted to external services.
- Expand-Contract Sequencing Enforcement: Automated structural split suggestions that isolate additive steps from cleanup phases to maintain continuous application uptime.
- Open Knowledge Format (OKF) Engine: Automatic generation of portable, version-controlled repository notes that make codebase context systematically smarter for future agent interactions.
- Cloud Integration Hooks: Seamless operational upgrades to transition standalone local risk reviews into multi-service workspace discoveries and cross-team rollout readiness gates.
SKILL.md
Loading
Related Openclaw Skills
Skill Optimizer
A dedicated agent skill designed to automatically modify, update, and optimize your local agent workflows based on real-world execution feedback.
Debug TypeScript Error
A local-first, standalone engineering skill designed to translate complex TypeScript errors into plain English and implement surgical, safe type fixes without relying on lazy type suppression.
Generate Storybook Story
An AI-powered local development skill that automatically generates clean, minimal, and highly realistic Storybook stories for frontend components.
API Change Review
An automated development skill that reviews API diffs for compatibility, security, and schema evolution, classifying changes as additive, behavior-changing, or breaking.
Mac Disk Audit Advisor
A secure, developer-centric macOS storage auditing and optimization tool that scans disk usage, detects massive files, and generates actionable, non-destructive cleaning commands.
Backend Test Plan
An AI-powered development skill that automatically converts backend code changes into verifiable success criteria and a minimum useful test plan.
Featured*
