database-lens

Database migration safety evaluation identifies table-locking implications, rollback hazards, and zero-downtime compatibility issues. It assesses migration scripts for idempotency and backfill correctness to prevent data loss and downtime during schema changes.

Schema and integrity assessment reviews constraints, indexes, column types, and referential integrity relative to access patterns. It checks appropriate defaults and data scale to prevent integrity regressions during feature rollouts.

Query and transaction review detects N+1 patterns, unbounded result sets, and improper transaction scoping by analyzing SQL files, ORM configurations, and connection settings to flag connection pool concerns and NULL-handling issues.

Yes, the database review process applies engine-specific analysis across ORM configurations, raw SQL files, and connection settings. It evaluates schema changes and transaction handling in codebases undergoing refactors or new feature rollouts.

You need to evaluate migration idempotency and backfill correctness whenever a feature introduces schema changes or data migrations. This prevents data loss and integrity regressions by ensuring migrations can safely re-run and populate columns correctly.