概要
This skill provides a comprehensive framework for designing and implementing high-performance TimescaleDB schemas tailored for insert-heavy data patterns. It guides users through the critical decisions of selecting partition columns, defining segment_by and order_by keys to maximize compression ratios, and configuring sparse indexes for efficient query filtering. By automating the setup of retention policies and continuous aggregates for both short-term dashboards and long-term reporting, the skill ensures that time-series databases remain performant and cost-effective as they scale to billions of rows.
