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.

来源