💻 Coding
PostgreSQL Migration from a Schema Delta Brief
Write a PostgreSQL migration from a schema delta brief. Never invent tables, columns, or extensions not listed.
0Reviews
Prompt
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.
Instructions
Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.
Examples
Example Input
Delta: Add table invoices (id bigserial PK, org_id bigint NOT NULL, total_cents integer NOT NULL, created_at timestamptz NOT NULL DEFAULT now()). Add index on invoices(org_id). No RLS. No extension. PGVer: 16 Tool: raw SQL Banned: invent uuid-ossp, invent backfill, invent RLS policy Never: invent columns, invent extensions, invent data UPDATEs, invent foreign keys not in Delta Format: ledger + lock + changes + up + down + refuse + gaps Lang: English
Example Output
1. Ledger. Delta: table invoices id bigserial PK, org_id bigint NOT NULL, total_cents integer NOT NULL, created_at timestamptz NOT NULL DEFAULT now(); index invoices(org_id); no RLS; no extension. PGVer 16. Tool raw SQL. Lang English. Forbidden: invent columns, invent extensions, invent UPDATEs, invent FKs, invent uuid-ossp, invent backfill, invent RLS. 2. Lock. PostgreSQL 16. 3. Changes. 1) CREATE TABLE invoices (...). 2) CREATE INDEX on invoices(org_id). 4. Up. CREATE TABLE invoices ( id bigserial PRIMARY KEY, org_id bigint NOT NULL, total_cents integer NOT NULL, created_at timestamptz NOT NULL DEFAULT now() ); CREATE INDEX invoices_org_id_idx ON invoices (org_id); 5. Down. DROP INDEX IF EXISTS invoices_org_id_idx; DROP TABLE IF EXISTS invoices; 6. Refuse. uuid-ossp invent refused. Backfill invent refused. RLS invent refused. FK invent refused. 7. Locks. LOCK NOTES NOT IN INPUTS. 8. Compliance. Banned cut. Gaps: FK to orgs, NOT VALID constraints, concurrent index note, grant roles, comment on table. Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.