Schema Dump or Live Catalog: Two Positions on AI SQL Review Inputs

Description and use

Problem: AI reviewer uses an outdated schema dump, causing deployment failures. Solution: enforce dump freshness and optionally review against the live catalog.

Problem

AI reviewers may approve schema changes based on stale dumps, causing runtime failures when live catalog differs.

Outcome

Adds a deterministic, reproducible input for AI review and a policy to prevent stale dumps from being used, reducing deployment failures.

Workflow

• Capture a schema dump with timestamp and hash
• Store a manifest with captured_at_utc, sha256, and bytes
• Fail the review job if dump age exceeds policy window
• Optionally connect to a read replica to fetch live catalog metadata
• Run AI review against the dump or live catalog as configured

Evidence

The AI reviewer approved the file because its schema dump was eleven days old and lacked that index.

Source