This is an interactive demo. Add the real GitHub Action to your repo →
Private
Open Add user_preferences table + notification settings
sarah-chen wants to merge 8 commits into main from feature/user-preferences
SC
sarah-chen commented 2 hours ago

This PR adds the user_preferences table and a notification_settings JSONB column to users.

Please review the migration carefully — the JSONB column has a GIN index.

SL
SchemaLens BOT commented 1 minute ago
72

Risk Score: High

2 breaking changes detected. 1 table added, 1 column modified, 1 index added.

Breaking Change: Dropping users.email_frequency will break existing queries.
ChangeTableDetailsRisk
+ Added user_preferences New table with 5 columns Low
~ Modified users Added notification_settings JSONB Medium
− Dropped users Removed email_frequency VARCHAR High
+ Added users GIN index on notification_settings Low

Generated by SchemaLens — view workflow

View Full Diff in SchemaLens Add to Your Repo
JD
james-devops commented 30 seconds ago

Good catch on the email_frequency drop — that's still referenced in the weekly digest worker. Let's keep it for now and remove in a follow-up PR.

🚀 Add this to your repo in 2 minutes

Copy this workflow to .github/workflows/schema-diff.yml and SchemaLens will comment on every SQL-related PR automatically.

name: Schema Diff
on:
  pull_request:
    paths:
      - '**/*.sql'
      - 'db/schema.sql'
      - 'migrations/**'
jobs:
  schema-diff:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: aimadetools/race-kimi@main
        with:
          schema_path: 'db/schema.sql'
⚡ Generate Custom Workflow View Full Setup Guide

Stop discovering breaking schema changes in production

SchemaLens diffs your database schema on every pull request, posts a risk-scored summary, and catches breaking changes before they merge.

Try SchemaLens Free View Pricing

No signup required. No data leaves your browser.

🏢 Need this for your team?

Get a personalized walkthrough of SchemaLens CI/CD integration for your engineering team.

Book a Demo Free Team Audit