timescale-lifecycle-ops

What problem does it solve?

This Skill automates the data lifecycle operations needed to avoid storage bloat and performance degradation in TimescaleDB hypertables by prescribing compression, retention, and downsampling policies.

Core Features & Use Cases

• Policy-as-code guidance for creating compression policies, retention rules, and continuous aggregate downsampling to protect long-term performance.
• Targeted scope for tables used as logs, audits, and sales history in high-volume transactional systems where space and query speed are critical.
• Operational best practices such as segment-by keys, configurable intervals, and using continuous aggregates for historical reporting while deleting raw data when appropriate.

Quick Start

Create compression and retention policies for the ventas and sync_logs hypertables with a 30-day compression interval and a 3-month retention policy.