schema-alignment

To detect schema drift, this skill extracts live database schemas and code models, compares them, and reports missing columns, type mismatches, and orphaned migrations. It produces a structured drift report to highlight inconsistencies between your database and ORM definitions.

Yes, schema alignment checks support cross-ORM drift detection for Django, Prisma, TypeORM, and SQLAlchemy. It extracts schema definitions from these ORMs and compares them against the database to find missing columns and naming inconsistencies across multi-project codebases.

The best way to find orphaned migrations and naming inconsistencies is to run a drift check that compares extracted database schemas against ORM code models. This process outputs a structured drift report detailing migration planning and specific schema mismatches.

Schema drift detection works by extracting database schemas from either live databases or migration files, then extracting code models from ORM definitions. It compares these two sources to produce an end-to-end drift report including missing columns and type mismatches.

After finding type mismatches and missing columns, you can use the generated drift report to follow the migration planning workflow. This workflow provides structured results and guidance to help correct schema drift and align your ORM models with the database.

Naming inconsistencies occur when database schemas and ORM code models drift apart over time. This skill identifies these mismatches by extracting and comparing live schemas with ORM definitions, outputting a detailed drift report to help correct the inconsistencies.