🚀 Add to your pipeline — copy, paste, done

Free for open source and small teams. Upgrade to Team for Slack alerts, shared dashboards, and unlimited members.

# azure-pipelines.yml
trigger:
  branches:
    include:
      - main

pr:
  paths:
    include:
      - db/schema.sql
      - migrations/*.sql
      - **/*.sql

pool:
  vmImage: ubuntu-latest

steps:
  - checkout: self
    fetchDepth: 0

  - task: NodeTool@0
    inputs:
      versionSpec: "20.x"
    displayName: "Install Node.js"

  - script: |
      git fetch origin $(System.PullRequest.TargetBranch)
      git show origin/$(System.PullRequest.TargetBranch):db/schema.sql > /tmp/schema_base.sql 2>/dev/null || echo "-- No base schema" > /tmp/schema_base.sql
      node ci/schemalens-diff.js /tmp/schema_base.sql db/schema.sql --dialect=postgres --format=markdown --output=/tmp/report.md
      cat /tmp/report.md
    displayName: "SchemaLens Schema Diff"

  - task: PublishBuildArtifacts@1
    inputs:
      PathToPublish: "/tmp/report.md"
      ArtifactName: "schema-diff-report"
    displayName: "Publish diff report"
      

Download azure-pipelines.yml ⚡ Setup Wizard auto-detects schema files

💬 What the PR comment looks like

SchemaLens Bot

commented 2 minutes ago

🔍 SchemaLens Schema Diff Report

🟢 Tables Added	1
🔴 Tables Removed	0
🟡 Tables Modified	2
⚠️ Breaking Changes	1
📊 Risk Score	42/100 (Medium)

Generated Migration

ALTER TABLE users
  ADD COLUMN email_verified_at TIMESTAMP;

Generated by SchemaLens Azure DevOps

📦 What the pipeline artifact looks like

schema-diff-report/schema_diff_report.md 2.4 KB

Team members can download the full markdown report from the Build > Artifacts section of any Azure DevOps pipeline run. The report includes:

Complete diff summary with table counts
Breaking change list with severity levels
Generated migration SQL (full script with Pro)
Risk score and recommendation

Why add schema diff to Azure DevOps?

🛡️ Prevent production incidents

Breaking changes like dropped columns, removed indexes, or altered constraints get flagged before merge — not after deploy.

💬 PR comments, automatically

Every pull request gets a clear schema diff summary posted as a comment. Reviewers see exactly what changed without leaving Azure DevOps.

📦 Downloadable artifacts

The full markdown report is attached to every pipeline as an artifact. Download it for compliance docs, audits, or offline review.

⏭️ Smart skip

Path filters let the pipeline skip entirely when no .sql files were modified — saving build minutes.

⚡ Zero setup required

No database connections, no CLI installation, no license key. Just point the job at two SQL files.

🚦 Fail the pipeline on breaking changes

Set FAIL_ON_BREAKING: "true" and the pipeline fails if any dangerous schema changes are detected.

📊 Risk score at a glance

Every diff report includes a 0–100 risk score and a label like Low, Medium, High, or Critical.

🔒 Uses System.AccessToken

Post PR comments using Azure DevOps' built-in $(System.AccessToken) — no extra service connection required.

📋 Setup instructions

Copy the template

Download azure-pipelines.yml above or use the CI/CD Setup Wizard to customize it for your repo.

Add the SchemaLens diff script

Copy ci/schemalens-diff.js into your repository. It has zero npm dependencies and works in any Azure DevOps agent.

Download schemalens-diff.js

Grant PR comment permission

To post comments back to the pull request, enable the Contribute to pull requests permission for the Project Collection Build Service account, or use an Azure DevOps PAT stored as a secret variable.

Open a pull request

Modify any .sql file and open a PR. The pipeline runs, generates the diff report, and posts it as a PR comment.

🔧 Configuration reference

Variable	Default	Description
`SCHEMA_OLD_PATH`	`db/schema.sql`	Path to the base schema file in the target branch.
`SCHEMA_NEW_PATH`	`db/schema.sql`	Path to the current schema file in the PR branch.
`DIALECT`	`postgres`	SQL dialect: `postgres`, `mysql`, `sqlite`, `mssql`, `oracle`.
`FAIL_ON_BREAKING`	`false`	Set to `true` to fail the build when breaking changes are detected.
`POST_PR_COMMENT`	`true`	Set to `false` to skip posting the PR comment.

Need schema diff in a different CI platform?

SchemaLens works wherever Node.js runs. Pick your platform for a ready-to-use template.

GitHub Actions GitLab CI Bitbucket Jenkins CircleCI

Try SchemaLens free

Paste two schemas and see the diff instantly. No signup required.

Open SchemaLens App ⚡ Azure DevOps Wizard

SchemaLens Azure DevOps Free