database-migrationsSafe, zero-downtime database migration strategies — schema evolution, rollback planning, data migration, tooling, and anti-pattern avoidance for production systems. Use when planning schema changes, writing migrations, or reviewing migration safety.
Install via ClawdBot CLI:
clawdbot install wpank/database-migrationsGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
https://github.com/wpank/ai/tree/main/skills/api/database-migrationsAudited Apr 17, 2026 · audit v1.0
Generated Mar 21, 2026
An online retailer needs to add new product attributes like 'sustainability_score' and 'supplier_rating' to their database without downtime. Using additive-only and expand-contract patterns, they can safely introduce these columns while maintaining backward compatibility for existing APIs and ensuring continuous service during peak shopping seasons.
A fintech company must rename a column from 'ssn' to 'tax_id' to comply with new regulations. By implementing a dual-write strategy with expand-contract, they backfill historical data in batches, verify consistency, and cut over reads gradually, avoiding service disruption and ensuring data integrity for sensitive financial records.
A SaaS platform needs to split a monolithic user table into tenant-specific tables to improve performance. Using parallel change and background jobs, they replicate data, add foreign keys, and migrate large datasets lazily, allowing zero-downtime deployment and seamless scaling for enterprise clients.
A healthcare application must change data types for patient identifiers to support international standards. By adding a parallel column, casting data with batched backfills, and using blue-green database deployment, they ensure high availability and data accuracy during the migration, critical for regulatory compliance.
Companies offering database migration tools or consulting services on a recurring fee basis. Revenue is generated through monthly or annual subscriptions, with tiers based on features like advanced rollback strategies or CI/CD integration, targeting tech teams needing ongoing support.
Providing expert migration planning and execution for large organizations. Revenue comes from project-based contracts or retainer fees, focusing on high-risk scenarios like financial or healthcare systems where downtime costs are significant and compliance is strict.
Developing free migration tools like Prisma Migrate or Flyway, with revenue from premium features, support, or cloud hosting. This model leverages community adoption to upsell enterprises on enhanced capabilities such as automated testing or blue-green deployment automation.
💬 Integration Tip
Integrate migration tools into your CI/CD pipeline with automated up-down-up testing and production-like data snapshots to catch issues early and ensure idempotent deployments.
Scored Apr 19, 2026
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.
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.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
Write correct MySQL queries avoiding common pitfalls with character sets, indexes, and locking.