pg-aiguide Skills
Security scan passedPostgres best practices for your agent: table design, indexes, pgvector and hybrid search, PostGIS and TimescaleDB hypertables.
Loading listing…
find-hypertable-candidates
Security scan passedUse this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/Ti…
Part of pg-aiguide SkillsPack · 9 skills
by timescale· DatabasesUnclaimed · Yours? Claim it
What find-hypertable-candidates does
About
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.
Install find-hypertable-candidates
More from Databases
Skills people install alongside find-hypertable-candidates.
