database▌

You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.

DrugBank is a comprehensive bioinformatics and cheminformatics database containing detailed information on drugs and drug targets. This skill enables programmatic access to DrugBank data including ~9,591 drug entries (2,037 FDA-approved small molecules, 241 biotech drugs, 96 nutraceuticals, and 6,000+ experimental compounds) with 200+ data fields per entry.

Execute database migrations across ORMs with zero-downtime strategies and rollback procedures. \n \n Supports three major ORMs: Sequelize, TypeORM, and Prisma, with migration syntax and CLI commands for each \n Covers schema transformations including column additions, renames, type changes, and data restructuring with multi-step approaches for large tables \n Includes transaction-based and checkpoint-based rollback strategies to safely recover from failed migrations \n Provides zero-downtime dep