The Scenario
You are a tech lead. A sprint retrospective is scheduled for Friday afternoon. Before that meeting, you need to know which feature branches in your Supabase project are stale — linked to Git branches that were merged weeks ago but never cleaned up.
Your project has nineteen database branches. You need: branch name, linked Git branch, status, and created date — in a sheet, so you and the team can decide what to delete.
The slow version:
- You open the Supabase dashboard and navigate to database branches
- The UI shows branches in a list — no export
- You type them into a sheet by hand: nineteen rows, four columns
- You misread one status field and flag the wrong branch as stale
- You spend forty minutes on a task that should have taken five, and you still enter the retrospective unsure whether your list is accurate.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Supabase branch list directly and writes the full inventory into the sheet, so you do not have to type anything by hand or squint at a dashboard.
Open the SheetXAI sidebar and type:
List all database branches for Supabase project abc123. Write branch ID, name, git_branch, status, and created_at into this sheet — one row per branch. Flag any branches older than 30 days in column F with the label "STALE."
SheetXAI calls the Supabase branches API, retrieves all nineteen branches, writes the formatted table, and adds the stale flag in column F.
What You Get
A complete branch inventory ready for the retrospective:
- One row per branch — ID, name, linked Git branch, status, created date
- Stale branches flagged — column F marks anything older than 30 days
- All nineteen branches — no manual typing, no missed entries
The team can review the sheet before the meeting and decide which branches to delete. The retrospective discussion starts with facts, not guesses.
What If the Branch Audit Needs More Context
A branch list is the starting point. SheetXAI can enrich it in the same prompt.
When you want to cross-reference against merged Git branches
You have a list of merged branches in column A of a second tab and want to flag Supabase branches that match.
List all database branches for Supabase project abc123 and write them into the Branches tab. In column F, check whether the git_branch value matches any branch name in the Merged tab column A — if yes, label it "MERGED AND STALE," otherwise leave it blank.
When you want branches grouped by status
The status field has values like "active," "idle," and "expired" and you want to see them grouped.
List all database branches for Supabase project abc123 and write them into this sheet sorted by status, then by created_at within each status group. Add a summary row at the top of each status group showing the count.
When you want to flag branches with reset_on_push disabled
Security teams sometimes require all branches to have reset_on_push enabled.
List all branches for Supabase project abc123. Write branch name, git_branch, status, and reset_on_push into this sheet. Highlight any rows where reset_on_push is false in red.
When you need the full audit: raw list, stale flags, merge check, and a cleanup plan
List all branches for Supabase project abc123 and write raw data into the Raw tab. In the Audit tab, flag branches older than 21 days as STALE and branches older than 60 days as CRITICAL. In the Cleanup tab, list only the CRITICAL branches sorted by age descending, and add a one-sentence suggested action for each based on its status and git_branch name.
The pattern: the prompt does the conditional logic, so the sheet tells you what to do, not just what exists.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to list your Supabase database branches. The Supabase integration is included in every SheetXAI plan. For related workflows, see how to export your migration history or the Supabase in Google Sheets overview.