← All docs

Supabase

Supabase provides a PostgreSQL database with auth, storage, and realtime built in.

Connection

Use the direct connection string from your Supabase project settings (not the pooled/API URL).

Setup

# Get connection string from Supabase dashboard > Settings > Database
migrationpilot analyze migration.sql \
  --database-url "postgresql://postgres:[PASSWORD]@db.abcdefghijk.supabase.co:5432/postgres"

# Using Supabase CLI migrations
npx migrationpilot check supabase/migrations/

Tips

  • Supabase uses PostgreSQL 15 by default — set pgVersion: 15 in your config
  • The auth and storage schemas contain Supabase internals — only analyze your own schemas
  • Use supabase db diff to generate migration SQL from schema changes
  • Supabase CLI migrations are stored in supabase/migrations/