migrate-postgres-tables-to-hypertables - Migrate PostgreSQL Tables to Hypertables
Migrates identified PostgreSQL tables to TimescaleDB hypertables, configures compression, and validates the migration.
Tags
Updated: 2026-09-30Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Select partition columns
- Calculate chunk intervals
- Check key constraints
- Plan migration strategies
- Migrate tables to hypertables
- Configure compression policies
- Validate migration performance
Inputs
- PostgreSQL table schemas
- Table constraints
- Column statistics
- Query patterns
- Database RAM capacity
- Migration maintenance window
- Backup resources
- User constraint approval
Outputs
- Hypertable migrations
- Compression configurations
- Compression policies
- Migration plans
- Validation query results
- Migration status
Requirements
- PostgreSQL 15 or later
- TimescaleDB installed
- Required database permissions