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 Confluence doc. The Supabase project has applied forty-one migrations. You need: version, name, and execution order — in an Excel workbook — so you can compare them side by side.
The slow version:
- You write a query against
supabase_migrations.schema_migrationsin the Supabase SQL editor - You run it, copy the result as CSV
- You open Excel, import the CSV — the import wizard takes five minutes to configure
- The column names are
versionandname— fine, but you manually add an order column with sequential numbers - You cross-reference with Confluence 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 workbook, so you do not have to write SQL or import a CSV.
Open the SheetXAI sidebar and type:
List the full migration history for Supabase project abc123. Write migration version, name, and execution order into this workbook — 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 Confluence 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
List the migration history for Supabase project abc123 and write order, version, and name into this workbook. In column D, flag any migration applied in the last 7 days with "THIS RELEASE."
When you need to count migrations per naming prefix
List the migration history for Supabase project abc123 and write order, version, and name into this workbook. In column D, extract the prefix before the first underscore and label it "Area." In cell E1, write the count of migrations per area.
When you want to compare staging and production
List the migration history for Supabase project abc123 (production) and write version and name into columns A and B. List the history for project xyz789 (staging) and write version and name into columns D and E. In column G, flag any version in production but not in staging as "MISSING FROM STAGING."
When you need the reconciliation, release diff, and risk summary in one shot
List the migration history for Supabase project abc123 and write order, version, and name into the History tab. In the Release tab, list only migrations applied in the last 14 days. In the Risk tab, list migrations whose name contains "drop," "delete," or "alter" with a one-sentence note about rollback risk.
The pattern: the prompt does the reconciliation logic so the workbook is ready to hand to the release manager.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, 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 schema as a data dictionary or the Supabase in Excel overview.