postgres-migration-author

by AgentsRoomVerified by AgentsRoomNo install yetNo like yetUpdated May 7, 2026Category: Engineering

What it does

Use when authoring a PostgreSQL migration. Enforces backwards-compatible patterns and concurrent index creation.

Install opens this entry in your AgentsRoom desktop app. If the app is not installed yet, you will be sent to the download page.

SKILL.md

---
name: postgres-migration-author
description: Use when authoring a PostgreSQL migration. Enforces backwards-compatible patterns and concurrent index creation.
---

# PostgreSQL migration author

When asked to write a migration:

1. NEVER drop or rename a column in the same release that introduces a new use of it. Two-step it.
2. Use `CREATE INDEX CONCURRENTLY` outside transactions.
3. Backfill in batches; refuse to write a single `UPDATE` over millions of rows without explicit confirmation.
4. Always add a `down` migration unless the user opts out with a comment.
5. Default new boolean columns with a value, never NULL — saves a NULL-safety pass downstream.