setup-timescaledb-hypertables
CommunityDesign hypertables and optimize TimescaleDB.
AuthorMicrock
Version1.0.0
Installs0
System Documentation
What problem does it solve?
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.
Core Features & Use Cases
- Hypertable design guidance: How to partition, segment, and order data for optimal compression and query performance.
- Indexing and compression setup: Recommendations and examples to balance write throughput with read efficiency.
- Maintenance patterns: Retention policies and continuous aggregates to support long-term analytics.
Quick Start
Choose partition and segment_by columns for a time-series table, then configure chunk intervals and compression settings to optimize recent-query performance.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: setup-timescaledb-hypertables Download link: https://github.com/Microck/ordinary-claude-skills/archive/main.zip#setup-timescaledb-hypertables Please download this .zip file, extract it, and install it in the .claude/skills/ directory.