Summary
This analyzes your existing PostgreSQL database to figure out which tables would actually benefit from converting to TimescaleDB hypertables. It provides SQL queries to inspect table statistics, index patterns, and query behavior, then scores each table on an 8-point scale based on characteristics like insert volume, time-based queries, and row count. The skill includes pattern recognition for common use cases like IoT sensors, event logs, and transaction records, plus compatibility checks for constraints that might complicate migration. It's genuinely useful if you're considering TimescaleDB but aren't sure where to start, since it helps you avoid migrating tables that won't see performance gains. Works best with PostgreSQL 15+ and pairs with a companion migration skill for the actual conversion work.
Install to Claude Code
npx -y skills add timescale/pg-aiguide --skill find-hypertable-candidates --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →First SeenJun 3, 2026
