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