soft-delete-strategy
CommunityReversible deletion patterns for SaaS data.
Software Engineering#postgresql#audit-trail#soft-delete#data-retention#cascading-delete#deleted_at#paranoid-delete
Authormarquesfelip
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Reversible deletion patterns enable teams to delete SaaS records safely while preserving the ability to undo, archive for records, and purge data in a compliant, auditable manner.
Core Features & Use Cases
- Soft delete via a deleted_at timestamp to keep historical context without exposing deleted rows in normal queries.
- Restore/undelete workflows with transactional integrity and conflict checks when restoring (e.g., slug or unique constraints).
- Hard purge scheduling with a retention window to meet data-minimization and compliance requirements, including cascading deletes across related entities.
Quick Start
Add a deleted_at column to your tables, set up a partial index for active records, and implement the soft delete, restore, and purge workflows.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: soft-delete-strategy Download link: https://github.com/marquesfelip/agents-and-skills/archive/main.zip#soft-delete-strategy Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.