Agent skill · software engineering · aiskillstore
schema-alignment
Detect and report drift between database schema and code data models. Works with SQLAlchemy, Django ORM, Prisma, TypeORM, and other ORMs. Generic across any project.
Why this skill is useful
Adds specific commands and workflows for detecting schema drift across multiple ORMs that the AI wouldn't reliably generate on its own.
What it needs
Requires django, drizzle, prisma, sqlalchemy, typeorm installed locally. About 4k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Schema Alignment Skill Detect drift between database schemas and code data models. This skill identifies missing columns, type mismatches, orphaned migrations, and naming inconsistencies. Design Principle This skill is framework-generic. It works with any ORM or database: SQLAlchemy (Python) Django ORM (Python) Prisma (TypeScript/JavaScript) TypeORM (TypeScript) Drizzle (TypeScript) Alembic migrations Prisma migrations Django migrations Variables Variable Default Description ---------- --------- ------------- SCHEMASOURCE auto Schema source: auto, migrations, livedb, models SEVERITYTHRESHOLD medium Report issues at this level or higher AUTOFIX false Attempt to generate fix suggestions INCLUDETYPES true Include type mismatch detection Instructions MANDATORY - Follow the Workflow steps below in order. 1. Detect database technology and ORM in use 2. Extract schema from migrations or live database 3. Extract data models from code 4. Compare and identify drift 5. Generate alignment report Red Flags - STOP and Reconsider If you're about to: Modify the database schema directly without a migration Assume a column exists without checking the schema Skip type checking because "it works in tests" Ignore nullable/not-null mismatches STOP -> Check schema alignment -> Generate migration if needed -> Then proceed Workflow 1. Detect Stack Identify the database and ORM: 2. Extract Database Schema Option A: From Migrations (Preferred) Parse migration files to reconstruct current schema: Option B: From Live Database Query informationschema (if accessible): Option C: From Model Definitions Parse ORM model files directly. 3. Extract Code Models Parse model definitions from code: SQLAlchemy Prisma Pydantic/TypeScript Types Also extract related types: Pydantic models TypeScript interfaces BAML type definitions 4. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/schema-alignment