postgres-migration-author

作者：AgentsRoomAgentsRoom 已验证尚无安装尚无点赞更新于 2026年5月7日分类：工程

它能做什么

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

安装会在你的 AgentsRoom 桌面端打开这个条目。如果还没有安装应用，你会被带到下载页面。

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.

标签

backenddatabasepostgres