db-migration

Design PostgreSQL/PostGIS schemas and create safe database migrations with rollback plans, spatial column design, index strategy, and zero-downtime deployment patterns. Use this skill whenever someone asks to create a table, modify a schema, write a migration, design a data model, add an index, or says things like "create a migration for X", "add a column to Y", "design the database schema", "what indexes do I need", "plan the data model", or "how do I safely change this column type". Also trigger when someone mentions zero-downtime migrations, expand-and-contract pattern, PostGIS spatial columns, or large table migration strategy.

By Kaakati schedule Updated 2/27/2026