migrate-create

Migrate Create

Generate a new database migration with sequential numbering and up/down SQL file pair.

When to use

When you need to create a new database migration for schema changes such as creating tables, adding columns, creating indexes, or modifying constraints.

Steps

1. Determine next number -- use Glob to scan the migrations directory for existing migration files and find the highest number, then increment by 1 (zero-pad to 3 digits)
2. Select template -- based on the <name>, choose the appropriate SQL template:
   • Names starting with create_ -> CREATE TABLE template
   • Names starting with add_ -> ALTER TABLE ADD COLUMN template
   • Names starting with drop_ -> DROP with safety checks
   • Names containing index -> CREATE INDEX template
   • Other -> generic migration template with placeholder comments
3. Generate up migration -- write NNN_<name>.up.sql with the appropriate SQL using IF NOT EXISTS for idempotency
4. Generate down migration -- write NNN_<name>.down.sql with the reverse operation using IF EXISTS