Engineering · Skill
Database Migration
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
Open in PhởWhat the skill covers
The sections of its instructions, in order.
- 01 When to Use This Skill
- 02 ORM Migrations
- Sequelize Migrations
- TypeORM Migrations
- Prisma Migrations
- 03 Schema Transformations
- Adding Columns with Defaults
- Renaming Columns (Zero Downtime)
- Changing Column Types
- 04 Data Transformations
- Complex Data Migration
- 05 Rollback Strategies
- Transaction-Based Migrations
- Checkpoint-Based Rollback
- 06 Additional patterns and templates
Reference files
1 file Phở can open while it uses the skill.
- references/details.md
More in Backend architecture
- Architecture Patterns
Implement proven backend architecture patterns including Clean Architecture, Hexagonal Architecture, and Domain-Driven Design. Use this skill when designing clean architecture…
- CQRS Implementation
Implement Command Query Responsibility Segregation for scalable architectures. Use when separating read and write models, optimizing query performance, or building event-sourced…
- Event Store Design
Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence…
- Microservices Patterns
Design microservices architectures with service boundaries, event-driven communication, and resilience patterns. Use when building distributed systems, decomposing monoliths, or…
- Projection Patterns
Build read models and projections from event streams. Use when implementing CQRS read sides, building materialized views, or optimizing query performance in event-sourced systems.
- Saga Orchestration
Implement saga patterns for distributed transactions and cross-aggregate workflows. Use this skill when implementing distributed transactions across microservices where 2PC is…
- Temporal Python Testing Strategies
Test Temporal workflows with pytest, time-skipping, and mocking strategies. Covers unit testing, integration testing, replay testing, and local development setup. Use when…
- Workflow Orchestration Patterns
Design durable workflows with Temporal for distributed systems. Covers workflow vs activity separation, saga patterns, state management, and determinism constraints. Use when…
- FastAPI Project Templates
Create production-ready FastAPI projects with async patterns, dependency injection, and comprehensive error handling. Use when building new FastAPI applications or setting up…
- Authentication & Authorization Implementation Patterns
Master authentication and authorization patterns including JWT, OAuth2, session management, and RBAC to build secure, scalable access control systems. Use when implementing auth…
- Error Handling Patterns
Master error handling patterns across languages including exceptions, Result types, error propagation, and graceful degradation to build resilient applications. Use when…
- SQL Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries…
- Node.js Backend Patterns
Build production-ready Node.js backend services with Express/Fastify, implementing middleware patterns, error handling, authentication, database integration, and API design best…
- .NET Backend Development Patterns
Master C#/.NET backend development patterns for building robust APIs, MCP servers, and enterprise applications. Covers async/await, dependency injection, Entity Framework Core…
- PostgreSQL Table Design
Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Similar engineering skills
Frequently asked questions
What does Database Migration do?
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
Is Database Migration free to use?
Yes. Database Migration is published by Seth Hobson under the MIT licence, and you can use it with a free Phở account.
How do I use Database Migration in Phở?
Press Open in Phở, then Try to apply it to your next message, or add the Backend architecture set so Phở loads it whenever a request matches.
Does Database Migration need other tools?
No. It works in a normal Phở chat with what you type or upload.
Copied unchanged from wshobson/agents at commit 7e2fb55 and credited to Seth Hobson, who is not affiliated with Phở. The full instructions and licence text ship with the skill inside Phở.