GitHub Actions

 1on:
 2  pull_request:
 3    types: [opened, synchronize]  # Show SQL diff
 4  push:
 5    branches: [preview]           # Auto-apply
 6  workflow_dispatch:              # Manual trigger
 7    inputs:
 8      environment:
 9        type: choice
10        options: [production, preview]

1- name: Generate schema diff
2  run: |
3    DIFF_OUTPUT=$(pnpm exec prisma migrate diff \
4      --from-schema-datasource prisma/schema.prisma \
5      --to-schema-datamodel prisma/schema.prisma \
6      --script || echo "No pending migrations")
7    echo "diff_output=$DIFF_OUTPUT" >> $GITHUB_OUTPUT
8  env:
9    DATABASE_URL: ${{ secrets.PRODUCTION_DATABASE_URL }}

 1# Require backup confirmation
 2- name: Verify backup
 3  if: github.event.inputs.confirm_backup != 'true'
 4  run: |
 5    echo "❌ Must confirm backup exists"
 6    exit 1
 7
 8# Dry run first
 9- name: Preview changes
10  run: pnpm exec prisma migrate diff --script
11
12# Apply migration
13- name: Run migration
14  run: pnpm exec prisma migrate deploy