Database Cascade Management - DevForge AI

Overview

Handles database foreign key cascade issues in the Paperclip codebase. Resolves deletion operation failures caused by missing CASCADE constraints, plans safe migration paths for schema changes, and ensures data integrity during company/agent lifecycle operations.

When to Use

• When DELETE /api/companies/:id fails with FK constraint violations
• When orphaned records remain after parent entity deletion
• When schema migrations need CASCADE path additions
• When activity_log, cost_events, issue_read_states block deletion
• Don't use when: It's a query performance issue (use schema-devforge-data-schema-management)