find-hypertable-candidates
帮助定位时间序列表并衔接迁移流程，减少盲目改造成本
可能需要访问数据库元信息，注意权限与隐私
分析 Postgres 并识别适合转换为 TimescaleDB hypertable 的表
分析现有 Postgres 数据库，找出哪些表适合转换为 TimescaleDB 的 hypertable，按时间序列特征、写入密集度和查询模式打分排序。适合准备迁移到 Timescale/TimescaleDB 或优化事件日志、审计表时使用。输出包括可执行的 SQL 分析方法和候选优先级，便于后续迁移决策。
▸ 展开 SKILL.md 英文原文
Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - Evaluate if a table would benefit from Timescale/TimescaleDB - Audit PostgreSQL tables for migration to Timescale/TimescaleDB/TigerData - Score or rank tables for hypertable candidacy **Keywords:** hypertable candidate, table analysis, migration assessment, Timescale, TimescaleDB, time-series detection, insert-heavy tables, event logs, audit tables Provides SQL queries to analyze table statistics, index patterns, and query patterns. Includes scoring criteria (8+ points = good candidate) and pattern recognition for IoT, events, transactions, and sequential data.
帮我安装这个 skill：https://raw.githubusercontent.com/timescale/pg-aiguide/main/skills/find-hypertable-candidates/SKILL.mdcurl -fsSL "https://raw.githubusercontent.com/timescale/pg-aiguide/main/skills/find-hypertable-candidates/SKILL.md"# 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,