Migrate Postgres Tables To Hypertables

Takes a PostgreSQL table and converts it to a TimescaleDB hypertable with proper chunk intervals, compression settings, and primary key handling. The skill walks through partition column selection (usually a timestamp), calculates optimal chunk sizes based on your RAM and index sizes, and importantly asks permission before modifying any primary keys that don't include the partition column. For small tables it does in-place conversion, for larger ones it sets up blue-green migration. The compression configuration part is solid, helping you pick segment_by columns based on cardinality analysis. Use this after you've identified candidates, ideally with the companion find-hypertable-candidates skill first.

Install to Claude Code

npx -y skills add timescale/pg-aiguide --skill migrate-postgres-tables-to-hypertables --agent claude-code