AI AgentsCategoriesCode Reviewer

AI Migration Safety Agent

Reads every database migration and flags lock-risk, missing rollbacks, breaking column drops, and unindexed foreign keys before the migration ships.
STATUS · LIVE
v1

01 / Invocation - the dream begins

AI Migration Safety Agent

Reads every database migration and flags lock-risk, missing rollbacks, breaking column drops, and unindexed foreign keys before the migration ships.

Start with AI
// the dream begins · roots anchor data · intelligence awakens

AI Migration Safety Agent on Taskade Genesis. Database migrations are where boring code meets 3am outages. This agent reads every migration PR and flags the patterns that historically cause downtime.

What's Included

  • Lock Detector: Flags ADD COLUMN NOT NULL, DROP COLUMN, ADD INDEX without CONCURRENTLY on large tables
  • Rollback Checker: Every UP migration must have a matching DOWN — flagged if missing
  • Backfill Detector: UPDATE-all-rows statements get flagged with a 'consider batched backfill' suggestion
  • FK Index Audit: Foreign keys without indexes get flagged (will cause sequential scans on JOIN)
  • Migration Timing Estimate: Reads row count + change type, estimates downtime window

Why It Matters

Most migration outages are not from clever code — they're from a forgotten CONCURRENTLY or an unindexed FK at scale. This agent encodes the senior-engineer review pattern into automation.

How To Use

  1. Clone this app
  2. Connect GitHub + your migration framework (Rails / Django / Knex / Alembic) via webhook
  3. The migration agent reviews every migration PR and posts findings

▲ ■ ● Memory · Intelligence · Execution.

Discover more

More Code Reviewer AI Agents

View all Code Reviewer AI Agents