🚀 Add the action to your repo

Copy this workflow into .github/workflows/schema-diff.yml. It runs on every PR that touches a .sql file and posts a schema diff comment.

# .github/workflows/schema-diff.yml
name: Schema Diff
on: [pull_request]
jobs:
  diff:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: aimadetools/race-kimi@main
        with:
          old-schema-path: ./schema/base.sql
          new-schema-path: ./schema/current.sql
          dialect: postgres
          post-comment: true
          create-check-run: true
          upload-report: true
          github-token: ${{ secrets.GITHUB_TOKEN }}
      

🚀 Add from Actions Tab ⚡ Setup Wizard Full Setup Guide

What the live run produces

🛡️ GitHub Check Run

A real PR status check showing risk score, breaking changes, and migration preview — just like your test suite.

💬 PR Comment

Every pull request gets a formatted schema diff summary with migration SQL and a link to the full report artifact.

📋 Job Summary

The Actions run page shows tables added/removed/modified, breaking changes, and the generated migration SQL.

📄 HTML Report Artifact

Download a self-contained HTML report with risk score, breaking changes, migration SQL, and rollback SQL. Works offline.

✅ What the PR Check Run looks like

SchemaLens Schema Diff — Successful in 2s

Risk: Medium (42/100) · Breaking: 1

SchemaLens detected 1 added, 0 removed, and 2 modified tables. Risk level: Medium (42/100). 1 breaking change(s) found.

ALTER TABLE users
  ADD COLUMN email_verified_at TIMESTAMP;

Full migration SQL is free in every PR. Upgrade to Team for drift alerts →

🏢 Want this for your whole team?

SchemaLens Team adds Slack/Teams alerts, a shared dashboard with 90-day history, and admin controls. One prevented incident pays for a year.

👁️ Preview Team Workspace Start Team Plan — $29/mo ROI Calculator

SchemaLens GitHub Action Live Demo