SupaForge vs. pgAdmin / DBeaver Schema Compare
Supabase-aware diffing versus general-purpose database tools.
npm install -g @akal/supaforge. A hosted dashboard is on the way - to hear when it opens.What pgAdmin and DBeaver Offer
pgAdmin and DBeaver are mature, general-purpose database tools, and their schema comparison features diff tables, columns, indexes, constraints and other objects between two PostgreSQL databases. They're excellent for exploring a database and inspecting differences visually.
But they see a Supabase project as a plain database:
- Auth settings, storage buckets and Edge Functions live outside the tables they compare.
- They don't know which of Supabase's own schemas and roles to leave alone, and which grants matter for the Data API.
- Comparison is something you run interactively - not a step in a pipeline that fails when environments diverge.
What SupaForge Adds
| Feature | pgAdmin / DBeaver | SupaForge |
|---|---|---|
| Schema diff | ✅ Visual comparison | ✅ Generated SQL, applied in one transaction |
| RLS | As schema objects | ✅ Policies, and tables with RLS off |
| Grants for anon / authenticated | - | ✅ |
| Auth settings | - | ✅ |
| Storage | - | ✅ Buckets, settings, policies |
| Cron, webhooks, Realtime, Vault | - | ✅ |
| Edge Functions | - | ✅ Deployed versions |
| Reference data | Export and compare by hand | ✅ Row by row |
| CI / automation | - | ✅ diff --ci, JSON, exit codes |
| Applying | Copy the SQL across | ✅ --apply, rehearsed with --prove |
| History | - | ✅ Local run log (supaforge report) |
Quick Start
npm install -g @akal/supaforge{
"environments": {
"staging": {
"dbUrl": "$STAGING_DATABASE_URL",
"projectRef": "STAGING_REF",
"accessToken": "$SUPABASE_ACCESS_TOKEN"
},
"production": {
"dbUrl": "$PRODUCTION_DATABASE_URL",
"projectRef": "PROD_REF",
"accessToken": "$SUPABASE_ACCESS_TOKEN"
}
},
"source": "staging",
"target": "production"
}supaforge diffWhen pgAdmin / DBeaver Is the Right Choice
For exploring data, writing queries or looking at one table's structure, a GUI is often the quickest tool. SupaForge is for keeping environments in step: repeatable, automated, and covering everything Supabase manages.
Summary
pgAdmin and DBeaver compare Postgres schemas visually. SupaForge compares whole Supabase projects, applies the fixes safely and runs in CI.
Ready to try SupaForge?
Install the CLI and run your first diff in a minute. Nothing is changed until you add --apply.
npm install -g @akal/supaforge