8.3k

Check merge readiness

GitHub Actions workflow for validating main branch status and migration readiness

This workflow validates that the main branch is in a ready state for merging pull requests. It checks the migration status and ensures no pending migrations are running that could affect the merge process.

Workflow configuration

name: Check merge readiness

on:
  pull_request:
    types: [opened, synchronize, reopened]

jobs:
  check:
    runs-on: ubuntu-latest
    name: Xata dev branch
    steps:
      - uses: actions/checkout@v3

      - name: Install Xata CLI
        run: |
          curl -fsSL https://xata.io/install.sh | bash

      - name: Check Xata status
        run: |
          xata status
          xata roll status
          xata branch view

      - name: Check Xata main branch pgroll status
        id: xata-main-branch-roll-status
        run: |
          xata roll status | jq -r '.status'
          echo XATA_MAIN_BRANCH_ROLL_STATUS=`xata roll status | jq -r '.status'` >> $GITHUB_OUTPUT

      - name: Complete any pending migrations (inherited from main)
        if: ${{ steps.xata-main-branch-roll-status.outputs.XATA_MAIN_BRANCH_ROLL_STATUS == 'In progress' }}
        run: |
          echo "Warning: A migration is currently running on the main branch. Please wait for it to complete before merging this PR."
          exit 1

Authentication and environment variables

The workflow requires several environment variables to be set:

  • XATA_API_REFRESH_TOKEN: Your Xata API refresh token (set as a GitHub secret)
  • XATA_ORGANIZATIONID: Your Xata organization ID
  • XATA_PROJECTID: Your Xata project ID
  • XATA_BRANCHID: The ID of the main branch
  • XATA_BRANCHNAME: The name of the main branch
  • XATA_DATABASENAME: Your database name

If you have the Xata CLI configured with your project locally, you can obtain these values with the following commands:

# XATA_API_REFRESH_TOKEN
xata auth refresh-token

# XATA_ORGANIZATIONID
xata organization get id

# XATA_PROJECTID
xata project get id

# XATA_BRANCHID
xata branch get id

Workflow steps

1. Install Xata CLI

- name: Install Xata CLI
  run: |
    curl -fsSL https://xata.io/install.sh | bash

This step installs the Xata CLI using the official installer script and adds it to the GitHub Actions PATH.

2. Check Xata status

- name: Check Xata status
  run: |
    xata status
    xata roll status
    xata branch view

This step performs three checks:

  • Verifies CLI and connection status
  • Checks for any pending migrations
  • Views the current branch status

Concurrency control

The workflow uses GitHub Actions concurrency to prevent multiple runs from interfering with each other:

concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

This ensures that:

  • Only one workflow run per branch is active at a time
  • New runs cancel any in-progress runs
  • Prevents race conditions during status checks

Best practices

  1. Set appropriate timeout

    • The workflow has a 10-minute timeout
    • Adjust based on your maximum migration duration

  2. Use environment variables

    • Store sensitive information in GitHub secrets
    • Use environment variables for configuration

  3. Handle migration states

    • Check for in-progress migrations
    • Prevent merging during active migrations
    • Provide clear error messages