What is schema drift in the context of Rails?

Schema drift occurs when a schema.rb file includes changes (like new columns or indexes) from other branches or local experiments that aren't part of the current Pull Request's migrations.

How does this skill detect drift?

It identifies all migration files changed in the PR, extracts their timestamps and logic, and then verifies that every diff in the schema.rb file corresponds exactly to those specific migrations.

When is the best time to use the Schema Drift Detector?

It is best used during the initial review of a PR that includes database changes, before more detailed logic or data integrity reviews take place.

Which frameworks does it support?

It is specifically optimized for Ruby on Rails and ActiveRecord environments that use the db/schema.rb file for database versioning.

Can it fix the drift automatically?

While it primarily detects issues, it provides the specific git and rails commands required to reset your schema and regenerate it using only the migrations present in your branch.

Schema Drift Detector

Name: Schema Drift Detector
Author: gvkhosla

bygvkhosla

•

データベース管理

Identifies and filters out unrelated database schema changes in Pull Requests to maintain clean version control history.

The Schema Drift Detector is a specialized tool for Ruby on Rails and ActiveRecord developers that solves the common problem of 'schema pollution' in Pull Requests. By cross-referencing changes in schema.rb against the specific migrations included in a PR, it automatically detects stray columns, indexes, or version increments that originated from other branches or local database updates. This ensures that database schema files remain strictly synchronized with relevant migrations, preventing merge conflicts and keeping the project's data modeling history accurate and professional.

主な機能

01Detection of unrelated table, column, and index additions

0235 GitHub stars

03Automated migration-to-schema cross-referencing

04Validation of schema version numbers against migration timestamps

05Seamless integration into the standard PR review workflow

06Clear reporting of drift indicators with actionable fix instructions

ユースケース

01Debugging unexpected schema conflicts after merging from a main branch

02Reviewing Pull Requests containing database migrations to ensure schema integrity

03Cleaning up schema.rb files polluted by local development database state

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gvkhosla/compound-engineering-pi schema-drift-detector

For use in Claude.ai and ChatGPT

Download Skill