Software Development

Setup TimescaleDB Hypertables

Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. **Trigger when user asks to:** - Create or design SQL schemas/tables AND Timescale/TimescaleDB/TigerData/Tiger Cloud is available - Set up hypertables, compression, retention policies, or continuous aggregates - Configure partition columns, segment_by, order_by, or chunk intervals - Optimize time-series database performance or storage - Create tables for sensors, metrics, telemetry, events, or transaction logs **Keywords:** CREATE TABLE, hypertable, Timescale, TimescaleDB, time-series, IoT, metrics, sensor data, compression policy, continuous aggregates, columnstore, retention policy, chunk interval, segment_by, order_by Step-by-step instructions for hypertable creation, column selection, compression policies, retention, continuous aggregates, and indexes.

Publisher / source

timescale/pg-aiguide (found on GitHub top repositories)

Upstream record

timescale/pg-aiguide

Version

Version 1

Published

2026-11-08

Publication review

Approved for publication · recorded passed scan 2026-11-08

Content fingerprint

dcfce6a31d21f427f852eb030e36a30ff5d38f5ad06176beb35f02f0485e2098