find-hypertable-candidates

Identify tables with time-based, insert-heavy patterns for TimescaleDB hypertable conversion.

• Detect tables suitable for hypertable conversion
• Analyze schema, query, and update patterns
• Prioritize time-series and append-only data
• Assess compatibility with hypertable constraints

• 90%+ compression and fast time-based queries
• Improved insert and aggregation performance
• Automatic data retention and compression
• Best for insert-heavy, time-based data
• Supports continuous aggregates for analytics
• Requires large volumes (1M+ rows or 100MB+)
• Frequent time-based range queries
• Minimal updates or deletes

1. 1.Run schema analysis with table statistics and index patterns
2. 2.Check query patterns using pg_stat_statements (if available)
3. 3.Evaluate constraints and compatibility
4. 4.Assess code patterns for time-based operations
5. 5.Prioritize tables with timestamp columns and time-based indexes
6. 6.Use companion skill for migration after analysis