How do I install the Database Cascade Management Devforge skill?

Run npx skillmds@latest add construct-ai-primary/database-cascade-management-devforge in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Database Cascade Management Devforge safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Database Cascade Management Devforge?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Database Cascade Management Devforge free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Database Cascade Management Devforge?

Construct-AI-primary (@construct-ai-primary) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Database Cascade Management Devforge by construct-ai-primary

Name: Database Cascade Management Devforge
Rating: 4.2 (5 reviews)
Author: Construct-AI-primary

Database Cascade Management Devforge

Use when database foreign key cascade issues occur, deletion operations fail with constraint violations, or data model changes require cascade path updates. Handles company deletion CASCADE failures, orphaned records, and migration planning.

Construct-AI-primary Updated Sep 8, 2026 0 repo stars

File contents

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)

Core Procedures

Cascade Fix Workflow

Identify Blocking Constraints - Run deletion, capture FK violation errors
Map Dependency Graph - Trace all tables referencing the target entity
Determine Cascade Strategy - Decide CASCADE vs SET NULL vs manual deletion order
Write Migration - Add ON DELETE CASCADE to appropriate FK constraints
Test Deletion - Verify full cascade works with realistic test data
Add Integration Test - Ensure deletion path is covered

Common Blocking Tables

activity_log.run_id → heartbeat_runs.id
cost_events.heartbeat_run_id → heartbeat_runs.id
issue_read_states.issue_id → issues.id
agent_wakeup_requests → agents / heartbeat_runs
goals → blocked by projects.goal_id

Agent Assignment

Primary Agent: devcore-devforge-core-development Company: DevForge AI Role: Database Cascade Specialist Reports To: devcore-devforge-core-development Backup Agents: schema-devforge-data-schema-management, database-infraforge-database-infrastructure

Success Metrics

Company deletion completes without manual SQL intervention
All dependent tables properly cascaded
No orphaned records after deletion
Deletion covered by integration tests

Error Handling

Error: CASCADE would delete unintended data Response: Use soft delete pattern or manual ordered deletion instead
Error: Circular FK prevents CASCADE Response: Break circular dependency, use deferred constraints

Cross-Team Integration

Gigabrain Tags: devforge, database, cascade, foreign-key, migration, deletion Related Skills: devcore-devforge-core-development, schema-devforge-data-schema-management, database-infraforge-database-infrastructure Last Updated: 2026-04-07

---name: database-cascade-management-devforgedescription: Use when database foreign key cascade issues occur, deletion operations fail with constraint violations, or data model changes require cascade path updates. Handles company deletion CASCADE failures, orphaned records, and migration planning.---# Database Cascade Management - DevForge AI## OverviewHandles 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)## Core Procedures### Cascade Fix Workflow1. **Identify Blocking Constraints** - Run deletion, capture FK violation errors2. **Map Dependency Graph** - Trace all tables referencing the target entity3. **Determine Cascade Strategy** - Decide CASCADE vs SET NULL vs manual deletion order4. **Write Migration** - Add ON DELETE CASCADE to appropriate FK constraints5. **Test Deletion** - Verify full cascade works with realistic test data6. **Add Integration Test** - Ensure deletion path is covered### Common Blocking Tables- `activity_log.run_id` → `heartbeat_runs.id`- `cost_events.heartbeat_run_id` → `heartbeat_runs.id`- `issue_read_states.issue_id` → `issues.id`- `agent_wakeup_requests` → `agents` / `heartbeat_runs`- `goals` → blocked by `projects.goal_id`## Agent Assignment**Primary Agent:** devcore-devforge-core-development**Company:** DevForge AI**Role:** Database Cascade Specialist**Reports To:** devcore-devforge-core-development**Backup Agents:** schema-devforge-data-schema-management, database-infraforge-database-infrastructure## Success Metrics- Company deletion completes without manual SQL intervention- All dependent tables properly cascaded- No orphaned records after deletion- Deletion covered by integration tests## Error Handling- **Error:** CASCADE would delete unintended data **Response:** Use soft delete pattern or manual ordered deletion instead- **Error:** Circular FK prevents CASCADE **Response:** Break circular dependency, use deferred constraints## Cross-Team Integration**Gigabrain Tags:** devforge, database, cascade, foreign-key, migration, deletion**Related Skills:** devcore-devforge-core-development, schema-devforge-data-schema-management, database-infraforge-database-infrastructure**Last Updated:** 2026-04-07

Frequently asked questions