SQL Anti-Patterns

Goal

Detect SQL anti-patterns and return safe PostgreSQL-first remediations with verifiable migration plans.

Default Posture

• Preserve relational guarantees (types, keys, constraints).
• Prefer one logical model + physical optimization (indexes/partitioning), not schema cloning.
• Keep migrations reversible and fail-closed.

Workflow

1. Classify mode: design, review, or migration.
2. Always read references/review-checklist.md.
3. For migration/production DDL/backfill/cutover, also read references/migration-playbook.md.
4. Load only symptom-relevant anti-pattern references.
5. Prioritize integrity risk before operational risk.