Setup Timescaledb Hypertables
timescale/pg-aiguide/skills/setup-timescaledb-hypertablesby timescale187be00d317a51210c132010d947f4546ffb5eefApache-2.0Listed Oct 9, 2026Updated Oct 9, 2026
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.
- 187be00d317a51210c132010d947f4546ffb5eefCurrentcommit 187be00Published Oct 9, 2026
Source and attribution
Source:timescale/pg-aiguideinskills/setup-timescaledb-hypertablesat commit187be00
License: Apache-2.0
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from timescale/pg-aiguide
Pgvector Semantic Search
timescale
Guides setup and tuning of pgvector vector similarity search in PostgreSQL for embeddings, RAG and semantic search.
Design Postgres Tables
timescale
Reference guidance for designing PostgreSQL tables, covering data types, constraints, indexes, JSONB and partitioning.
More in Data & Analytics
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.
Comps Analysis
anthropics
Builds institutional-grade comparable company analyses as Excel spreadsheets with operating metrics, valuation multiples and statistics.
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.
Comps Analysis
anthropics
Builds institutional-grade comparable company analyses as Excel spreadsheets with operating metrics, valuation multiples and statistics.
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.