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