find-hypertable-candidates
✓Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables
Installation
SKILL.md
Identify tables that would benefit from TimescaleDB hypertable conversion. After identification, use the companion "migrate-postgres-tables-to-hypertables" skill for configuration and migration.
Performance gains: 90%+ compression, fast time-based queries, improved insert performance, efficient aggregations, continuous aggregates for materialization (dashboards, reports, analytics), automatic data management (retention, compression).
Requirements: Large volumes (1M+ rows), time-based queries, infrequent updates
Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables Source: timescale/pg-aiguide.
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/timescale/pg-aiguide --skill find-hypertable-candidates- Source
- timescale/pg-aiguide
- Category
- </>Dev Tools
- Verified
- ✓
- First Seen
- 2026-02-01
- Updated
- 2026-02-18
Quick answers
What is find-hypertable-candidates?
Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables Source: timescale/pg-aiguide.
How do I install find-hypertable-candidates?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/timescale/pg-aiguide --skill find-hypertable-candidates Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor
Where is the source repository?
https://github.com/timescale/pg-aiguide
Details
- Category
- </>Dev Tools
- Source
- skills.sh
- First Seen
- 2026-02-01