setup-timescaledb-hypertables

SKILL.md

Instructions for insert-heavy data patterns where data is inserted but rarely changed:

Must be time-based (TIMESTAMP/TIMESTAMPTZ/DATE) or integer (INT/BIGINT) with good temporal/sequential distribution.

Less ideal: ingestedat (when data entered system - use only if it's your primary query dimension) Avoid: updatedat (breaks time ordering unless it's primary query dimension)

Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention policies, and continuous aggregates. Instructions for selecting: partition columns, segment_by columns, order_by columns, chunk time interval, real-time aggregation. Source: timescale/pg-aiguide.

View raw