Soft Delete

Delete data without actually deleting it.

When to Use This Skill

• User account deletion (GDPR recovery period)
• Accidental deletion recovery
• Audit trail requirements
• Referential integrity preservation
• Undo functionality

How It Works

-- Instead of DELETE
UPDATE users SET deleted_at = NOW() WHERE id = '123';