postgres-ttl-cleanup
CommunityClean up old Postgres data automatically.
AuthorOrionArchitekton
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the issue of unbounded data growth in PostgreSQL tables that lack native Time-To-Live (TTL) mechanisms, preventing performance degradation and excessive storage consumption.
Core Features & Use Cases
- Automated Data Pruning: Regularly deletes expired rows from critical tables like audit logs, idempotency keys, and subscriber events based on predefined retention periods (e.g., 90 days for logs, 30 days for invites).
- Auditing: Logs all deletion activities to a ClickHouse audit trail for traceability.
- Use Case: Ensure your database remains performant and cost-effective by automatically removing stale data that is no longer needed for operational or compliance purposes.
Quick Start
Run the postgres-ttl-cleanup skill to remove expired data from the database.
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: postgres-ttl-cleanup Download link: https://github.com/OrionArchitekton/cosmocrat-core/archive/main.zip#postgres-ttl-cleanup 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 223,000+ vetted skills library on demand.