Supabase Schemas

pip install supabase-schemas

export DATABASE_URL=postgresql://postgres.your-ref:password@aws-0-us-east-1.pooler.supabase.com:5432/postgres

# Create a new tenant schema
supabase-schemas create acme-corp

# List all tenant schemas
supabase-schemas list

# Run migrations for a specific tenant
supabase-schemas migrate acme-corp --migrations-dir ./migrations

# Run migrations for all tenants
supabase-schemas migrate-all --migrations-dir ./migrations

# Drop a tenant schema
supabase-schemas drop acme-corp

-- Created automatically by: supabase-schemas create acme-corp
CREATE SCHEMA app_acme_corp;

-- Each schema gets its own tables, functions, and policies
-- Row-level security is scoped per schema
-- auth.users view is wired automatically

-- app_acme_corp.schema_migrations
id | name                     | applied_at
1  | 001_create_users.sql     | 2025-01-15 10:00:00
2  | 002_add_settings.sql     | 2025-01-20 14:30:00