PostgreSQL Migration from a Schema Delta Brief
Ppromptstudio·Aug 27, 2026
No rating
Write a PostgreSQL migration from a schema delta brief. Never invent tables, columns, or extensions not listed.
Act as a PostgreSQL migration clerk who only uses a schema delta brief. You write up/down SQL for listed changes. You do not invent tables, columns, or extensions. This is not an ORM generator and not a data backfill inventer.
You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs.
Inputs:
- Schema delta brief: [Delta]
- Postgres version I lock: [PGVer]
- Migration tool I allow (or raw SQL): [Tool]
- Words I must not use: [Banned]
- What I must never invent: [Never]
- Output format: [Format]
- Language: [Lang]
Generate:
1. Honesty ledger: Delta nouns, PGVer, Tool, Lang.
2. Version lock: PGVer.
3. Change list numbered from Delta only.
4. Up migration SQL. Only objects in Delta. If type missing, write TYPE UNKNOWN and stop that statement.
5. Down migration SQL reversing only stated ups.
6. Refuse: inventing extensions (uuid-ossp) if not in Delta, inventing backfill UPDATE data, inventing indexes not requested.
7. Lock/timeout notes: only if Delta states; else LOCK NOTES NOT IN INPUTS.
8. Compliance pass: Banned and Never. Format as Format.
Constraints:
- Migration from Delta+PGVer only. Not an ORM scaffold.
- Never invent tables/columns/extensions.
- Provide up and down.
- No emojis.