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

Описание и применение

Проблема: AI‑ревьюер использует устаревший дамп схемы, что приводит к ошибкам при деплое. Решение: проверять свежесть дампа и при необходимости использовать живой каталог.

Задача

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

Результат

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

Рабочий процесс

• 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

Доказательства

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

Источник