COMPARISON

SupaForge vs. pgAdmin / DBeaver Schema Compare

Supabase-aware diffing versus general-purpose database tools.

The SupaForge CLI is open source and on npm: 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

FeaturepgAdmin / DBeaverSupaForge
Schema diff✅ Visual comparison✅ Generated SQL, applied in one transaction
RLSAs 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 dataExport and compare by hand✅ Row by row
CI / automation-✅ diff --ci, JSON, exit codes
ApplyingCopy the SQL across✅ --apply, rehearsed with --prove
History-✅ Local run log (supaforge report)

Quick Start

Install
npm install -g @akal/supaforge
supaforge.config.json
{
  "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"
}
Compare everything
supaforge diff

When 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
View on GitHub →