The Scenario
You are a database admin. A major release is scheduled for Friday. Before the deployment, you need to reconcile the migration history in your Supabase production project against the team's internal migration log.
Your team tracks migrations in a Notion doc. The Supabase project has applied forty-one migrations. You need: version, name, and execution order — in a Google Sheet — so you can compare them side by side.
The slow version:
- You open the Supabase dashboard and navigate to the database
- There is no migration history page in the dashboard
- You write a query against
supabase_migrations.schema_migrationsin the SQL editor - You run it, copy the result, paste it into a sheet
- The column names are version and name — fine, but you have to manually add an "order" column with sequential numbers
- You cross-reference with the Notion doc row by row
- You find a discrepancy in migration 38 at 11 PM the night before the release.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Supabase migration history directly and writes the formatted list into the sheet, so you do not have to run a SQL query or add manual numbering.
Open the SheetXAI sidebar and type:
List the full migration history for Supabase project abc123. Write migration version, name, and execution order into this sheet — sorted oldest to newest. Add a header row with readable labels: Order, Version, Migration Name.
SheetXAI calls the Supabase migrations API, retrieves all forty-one migrations, writes the formatted list with the sequential order column.
What You Get
A formatted migration history ready for reconciliation:
- One row per migration — execution order, version, migration name
- Sorted oldest to newest — the order they were applied
- Header row included — Order, Version, Migration Name
You cross-reference with the Notion doc in ten minutes. The discrepancy in migration 38 surfaces before you go home, not at 11 PM.
What If the Reconciliation Needs More Context
A flat migration list is the starting point. SheetXAI can enrich it in the same prompt.
When you want to flag migrations applied in the last 7 days
You want to see which migrations are part of this release versus older ones.
List the migration history for Supabase project abc123 and write order, version, and name into this sheet. In column D, flag any migration applied in the last 7 days with "THIS RELEASE."
When you need to count migrations per naming prefix
Your team names migrations by feature area: auth_, billing_, core_. You want to see the breakdown.
List the migration history for Supabase project abc123 and write order, version, and name into this sheet. In column D, extract the prefix (the part before the first underscore in the migration name) and write it as "Area." In cell E1, write the count of migrations per area.
When you want to compare two projects
You have a staging project and a production project and want to verify they are in sync.
List the migration history for Supabase project abc123 (production) and write version and name into columns A and B. Then list the migration history for Supabase project xyz789 (staging) and write version and name into columns D and E. In column G, flag any version that exists in production but not in staging as "MISSING FROM STAGING."
When you need the reconciliation, the release diff, and the risk summary in one shot
List the migration history for Supabase project abc123 and write order, version, and name into the History tab sorted oldest to newest. In the Release tab, list only migrations applied in the last 14 days. In the Risk tab, list any migration whose name contains "drop," "delete," or "alter" and add a one-sentence note explaining the risk of rolling it back.
The pattern: the prompt does the reconciliation logic, so the sheet is ready to hand to the release manager, not just ready to review yourself.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to export the migration history for your Supabase project. The Supabase integration is included in every SheetXAI plan. For related workflows, see how to export your full schema as a data dictionary or the Supabase in Google Sheets overview.