GitHub Actions + PlanetScale example. Get DR number and deploy it.

DR deploy example.yml

    steps:
      - name: checkout
        uses: actions/checkout@v3
      - name: Setup pscale
        uses: planetscale/setup-pscale-action@v1
      - name: Get Deploy Requests
        if: github.event.pull_request.merged == true
        env:
          PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }}
          PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }}
        run: |
          pscale deploy-request list db-name --org orgname -f json > dr_output.txt
          deploy_request_number=$(jq --arg branch ${{ github.head_ref }} '.[] | select(.state == "open" and .branch == $branch) | .number' dr_output.txt)
          echo "DEPLOY_REQUEST_NUMBER=$deploy_request_number" >> $GITHUB_ENV

      - name: Deploy schema migrations
        if: ${{ env.DEPLOY_REQUEST_NUMBER }}
        env:
          PLANETSCALE_SERVICE_TOKEN_ID: ${{ secrets.PLANETSCALE_SERVICE_TOKEN_ID }}
          PLANETSCALE_SERVICE_TOKEN: ${{ secrets.PLANETSCALE_SERVICE_TOKEN }}
        run: |
          pscale deploy-request deploy db-name ${{ env.DEPLOY_REQUEST_NUMBER }} --wait --org org-name