supabase.yml

name: Supabase schema

on:
  push:
    branches: [main, develop]
    paths:
      - 'supabase/**'
  pull_request:
    branches: [main, develop]
    paths:
      - 'supabase/**'

jobs:
  validate:
    name: Validate migrations
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4

      - uses: supabase/setup-cli@v1
        with:
          version: latest

      - name: Start Supabase local stack
        run: supabase start

      - name: Apply all migrations (forward)
        run: supabase db reset

      - name: Verify rollback scripts exist for every migration
        run: |
          missing=0
          for f in supabase/migrations/*.sql; do
            base=$(basename "$f" .sql)
            down="supabase/migrations/rollbacks/${base}.down.sql"
            if [ ! -f "$down" ]; then
              echo "Missing rollback: $down"
              missing=1
            fi
          done
          exit $missing

      - name: Stop Supabase local stack
        if: always()
        run: supabase stop