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
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
AI-driven multi-format SVG content generation system for presentations, social media graphics, and marketing materials. Use when creating PPTs, posters, or v...
DuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".
Fast Apple Mail search via SQLite on macOS. Search emails by subject, sender, date, attachments - results in ~50ms vs 8+ minutes with AppleScript. Use when asked to find, search, or list emails.
Use Redis effectively for caching, queues, and data structures with proper expiration and persistence.