SQL Review CI

Automated SQL review validates your migration files during pull/merge requests, catching issues before they reach production. See SQL Review for how checks work and how to interpret findings, or follow the GitOps tutorial for a complete example. Release-based Plans do not run the UI Plan checks. Run SQL Review in CI before the deployment job and require its result before merge when it should act as a gate.

What Gets Validated

Automated checks include:

SQL syntax validation
Policy rule enforcement (200+ configurable rules)
Naming convention compliance
Risk assessment for dangerous operations
Schema compatibility checks

SQL Review Policy

Configure 200+ linting rules for automated validation

Setup

Prerequisites:

Set up SQL Review Policy - Define your SQL standards
Install GitOps Integration - Connect Bytebase to your VCS

Use a compatible bytebase-action image. For Bytebase Cloud, use bytebase/bytebase-action:cloud. For self-hosted Bytebase, replace :cloud with your Bytebase server version, for example :3.14.0.

CI/CD Integration Examples

GitHub Actions
GitLab CI
Azure DevOps
Bitbucket Pipelines

# .github/workflows/sql-review.yml
name: SQL Review
on:
  pull_request:
    paths:
      - 'migrations/**'

jobs:
  sql-review:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4

      - name: SQL Review
        uses: bytebase/sql-review-action@v1
        with:
          bytebase-url: ${{ secrets.BYTEBASE_URL }}
          bytebase-token: ${{ secrets.BYTEBASE_SERVICE_ACCOUNT_TOKEN }}
          file-pattern: 'migrations/**/*.sql'

GitHub Tutorial

GitHub Example

# .gitlab-ci.yml
sql-review:
  image: bytebase/bytebase-action:cloud
  stage: test
  only:
    - merge_requests
  script:
    - |
      bytebase-action check \
        --url $BYTEBASE_URL \
        --service-account $BYTEBASE_SERVICE_ACCOUNT \
        --service-account-secret $BYTEBASE_SERVICE_ACCOUNT_SECRET \
        --file-pattern "migrations/**/*.sql"

GitLab Example

# azure-pipelines.yml
trigger: none
pr:
  branches:
    include:
      - main
  paths:
    include:
      - migrations/**

jobs:
  - job: SQLReview
    pool:
      vmImage: 'ubuntu-latest'
    steps:
      - task: Docker@2
        inputs:
          command: run
          arguments: >
            -e BYTEBASE_URL=$(BYTEBASE_URL)
            -e BYTEBASE_SERVICE_ACCOUNT=$(BYTEBASE_SERVICE_ACCOUNT)
            -e BYTEBASE_SERVICE_ACCOUNT_SECRET=$(BYTEBASE_SERVICE_ACCOUNT_SECRET)
            -v $(System.DefaultWorkingDirectory):/workspace
            bytebase/bytebase-action:cloud
            check --file-pattern "/workspace/migrations/**/*.sql"

Azure Tutorial

Azure Example

# bitbucket-pipelines.yml
pipelines:
  pull-requests:
    '**':
      - step:
          name: SQL Review
          image: bytebase/bytebase-action:cloud
          script:
            - |
              bytebase-action check \
                --url $BYTEBASE_URL \
                --service-account $BYTEBASE_SERVICE_ACCOUNT \
                --service-account-secret $BYTEBASE_SERVICE_ACCOUNT_SECRET \
                --file-pattern "migrations/**/*.sql"

Bitbucket Tutorial

Bitbucket Example

Review Bot Feedback

SQL Review reports findings through your configured CI integration. Set --check-release=FAIL_ON_ERROR to fail on errors or FAIL_ON_WARNING to fail on warnings too. The default SKIP reports findings without failing the job because of their severity. Feedback includes:

✅ Passed checks - Migration meets all policy requirements
⚠️ Warnings - Findings to assess under your chosen failure threshold
❌ Errors - Violations that fail checks configured with FAIL_ON_ERROR or FAIL_ON_WARNING
📊 Risk assessment - Evaluation of potential impact
📝 Detailed explanations - Why rules failed with fix suggestions

Database CI/CD

UI-Driven Workflow

GitOps Workflow

Appendix

What Gets Validated

SQL Review Policy

Setup

CI/CD Integration Examples

GitHub Tutorial

GitHub Example

GitLab Example

Azure Tutorial

Azure Example

Bitbucket Tutorial

Bitbucket Example

Review Bot Feedback

Next Steps

Release

SQL Review Rules

​What Gets Validated

SQL Review Policy

​Setup

​CI/CD Integration Examples

GitHub Tutorial

GitHub Example

GitLab Example

Azure Tutorial

Azure Example

Bitbucket Tutorial

Bitbucket Example

​Review Bot Feedback

​Next Steps

Release

SQL Review Rules

What Gets Validated

Setup

CI/CD Integration Examples

Review Bot Feedback

Next Steps