schema-validate

Database schema drift detection compares schemas between environments to catch discrepancies. This Skill automates that comparison using ORM-specific tools and bash scripting to ensure consistency across development, staging, and production databases.

Yes, schema validation supports Prisma, TypeORM, Django, SQLAlchemy, and Sequelize ORMs. It uses these ORM-specific tools to audit database schemas, verify constraints, and detect drift automatically.

Checking for missing indexes on foreign keys is handled through automated index analysis. The Skill scans your database schema to recommend and verify indexes on foreign keys and frequently queried fields to prevent runtime performance issues.

Validating foreign key constraints and cascade configurations is achieved through automated constraint validation. The Skill verifies foreign key relationships and checks cascade settings to ensure your database schema adheres to defined rules.

Yes, you can use bash scripting to audit database schemas as this Skill relies entirely on scripts with no external dependencies. It leverages ORM-specific tools within bash to perform schema validation and drift detection.

Database schema consistency validation fails when staging schemas do not match expected definitions or lack necessary indexes. Running this Skill identifies these mismatches and missing constraints before deployment to prevent runtime errors.