Find Hypertable Candidates
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.
- skills.sh installs
- 408
- GitHub stars
- 1.9K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add timescale/pg-aiguide --skill find-hypertable-candidates --agent claude-codeInstalls into .claude/skills of the current project.
Files
PostgreSQL Hypertable Candidate Analysis
Identify tables that would benefit from TimescaleDB hypertable conversion. After identification, use the companion "migrate-postgres-tables-to-hypertables" skill for configuration and migration.
TimescaleDB Benefits
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).
Best for insert-heavy patterns:
- Time-series data (sensors, metrics, monitoring)
- Event logs (user events, audit trails, application logs)
- Transaction records (orders, payments, financial)
- Sequential data (auto-incrementing IDs with timestamps)
- Append-only datasets (immutable records, historical)
Requirements: Large volumes (1M+ rows), time-based queries, infrequent updates
Step 1: Database Schema Analysis
Option A: From Database Connection
Table statistics and size
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/timescale/pg-aiguide
- Categories
- Backend & APIs, Data Science & ML, Marketing & SEO, Databases
- License
- Apache-2.0
- First seen
- Jun 3, 2026
More from timescale/pg-aiguide
All 8Recommended
More Backend & APIs
cloudflare-managersecondsky/claude-skillsComprehensive Cloudflare account management for deploying Workers, KV Storage, R2, Pages, DNS, and Routes. Use when deploying cloudflare services, managing work407skills.sh installs
fastmcpjezweb/claude-skillsBuild MCP servers in Python with FastMCP to expose tools, resources, and prompts to LLMs. Supports storage backends, middleware, OAuth Proxy, OpenAPI integratio406skills.sh installs
digitalocean-managed-databasesbobmatnyc/claude-mpm-skillsDigitalOcean Managed Databases for PostgreSQL, MySQL, Redis, MongoDB, Kafka, OpenSearch, and Valkey. Use when provisioning, scaling, or operating managed databa404skills.sh installs
stream-cligetstream/agent-skillsQuery Stream data and run CLI operations against Chat, Video, Feeds, and Moderation: list channels, list calls, show flagged messages, find users, query any Str403skills.sh installs
tooluniverse-sdkmims-harvard/tooluniverseBuild AI scientist systems with the ToolUniverse Python SDK for scientific research. Covers the 3 calling patterns (`tu.run` portable dict API, `tu.tools.X` fun399skills.sh installs
alibabacloud-das-agentaliyun/alibabacloud-aiops-skillsDiagnose and manage Alibaba Cloud databases through natural language. Use when users need to troubleshoot database performance issues (high CPU, slow queries, a395skills.sh installs