CtrlK
BlogDocsLog inGet started
Tessl Logo

migrate-postgres-tables-to-hypertables

Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migration for large tables - Validate hypertable migration success - Configure compression after migration **Prerequisites:** Tables already identified as candidates (use find-hypertable-candidates first if needed) **Keywords:** migrate to hypertable, convert table, Timescale, TimescaleDB, blue-green migration, in-place conversion, create_hypertable, migration validation, compression setup Step-by-step migration planning including: partition column selection, chunk interval calculation, PK/constraint handling, migration execution (in-place vs blue-green), and performance validation queries.

72

Quality

90%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

81%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The content is a thorough, mostly executable migration guide with strong workflow sequencing and explicit validation gates appropriate for a destructive database operation. Its main weaknesses are a minor SQL syntax error in one example and a monolithic structure that could offload reference material to bundle files.

Suggestions

Fix the missing comma before timescaledb.sparse_index in the compression ALTER TABLE example so the block is copy-paste valid, and renumber the blue-green steps so the duplicated '4.' is corrected.

Move the troubleshooting recipes and the ongoing-monitoring view SQL into a references/ file (e.g. TROUBLESHOOTING.md) and link to it from SKILL.md to reduce the monolithic footprint.

Trim the closing 'Focus on high-volume, insert-heavy workloads ...' ROI sentence and other non-actionable asides to tighten token efficiency.

DimensionReasoningScore

Conciseness

The body is dense and mostly SQL with targeted Timescale-specific rationale (e.g. 'updated_at - AVOID ... breaks chunk distribution') that Claude may not already know, with only minor padding such as the closing ROI sentence; it is efficient with a few instances that could be trimmed.

4 / 5

Actionability

Provides copy-paste-ready executable SQL across in-place and blue-green paths, compression, validation, and monitoring, but contains a minor gap: the compression ALTER TABLE block is missing a comma before timescaledb.sparse_index and the blue-green section reuses the '4.' step number.

4 / 5

Workflow Clarity

Clear three-step sequence with a pre-migration checklist, explicit validation gates ('ASK USER PERMISSION', 'STOP MIGRATION', 'DO NOT modify ... without permission'), success criteria, and troubleshooting feedback loops; the destructive/batch cap does not apply because validation is present and explicit.

5 / 5

Progressive Disclosure

Well-organized with clear Step 1-3 headers and signaled references to companion skills, but as a ~440-line monolith with no bundle files it inlines separable reference material (troubleshooting recipes, monitoring view SQL) rather than splitting it into reference files.

4 / 5

Total

17

/

20

Passed

Description

100%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

The description is strong: it clearly states the skill's purpose, provides explicit trigger guidance with concrete bullets, and supplies a rich keyword list with synonyms. It is highly specific to TimescaleDB hypertable migration with low conflict risk.

DimensionReasoningScore

Specificity

Lists multiple concrete actions comprehensively: 'partition column selection, chunk interval calculation, PK/constraint handling, migration execution (in-place vs blue-green), and performance validation queries', matching the comprehensive-coverage anchor.

5 / 5

Completeness

Explicitly states what ('migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation') and when ('Trigger when user asks to:' with five concrete bullet triggers), matching the anchor that requires both with concrete trigger phrases.

5 / 5

Trigger Term Quality

The Keywords list ('migrate to hypertable, convert table, Timescale, TimescaleDB, blue-green migration, in-place conversion, create_hypertable, migration validation, compression setup') covers natural user phrasings plus synonyms; file extensions are N/A for a database skill so comprehensiveness is not reduced.

5 / 5

Distinctiveness Conflict Risk

Occupies a clear niche (TimescaleDB hypertable migration) with distinct triggers and minimal overlap risk; it even distinguishes itself from companion 'find-hypertable-candidates' and 'setup-timescaledb-hypertables' skills via the prerequisites clause.

5 / 5

Total

20

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

metadata_version

'metadata.version' is missing

Warning

Total

15

/

16

Passed

Repository
timescale/pg-aiguide
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.