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.

66

Quality

80%

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

Fix and improve this skill with Tessl

tessl review fix ./skills/migrate-postgres-tables-to-hypertables/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

77%Weight 40%Scale 1-3

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

A highly actionable, well-sequenced migration playbook with strong validation checkpoints and explicit permission gates for destructive operations. Its weaknesses are moderate verbosity (re-explains known concepts and repeats SQL blocks) and a monolithic single-file structure with no progressive disclosure of the long compression/troubleshooting reference material.

Suggestions

Trim explanations of concepts Claude already knows (e.g., the data-type list under Partition Column Selection, generic notes like 'Unused indexes hurt insert performance') and de-duplicate the repeated compression ALTER block by referencing it once.

Move the long Troubleshooting and Ongoing Monitoring reference material into a separate references file and point to it from the main body, so the core migration workflow stays lean and discoverable.

Format the companion-skill pointers as explicit links or a named 'Related skills' section rather than inline prose so navigation is clearly signaled.

DimensionReasoningScore

Conciseness

The body is dense with executable SQL and actionable tables, but it also re-explains concepts Claude already knows (e.g., 'Time-based (TIMESTAMP/TIMESTAMPTZ/DATE) or sequential integer', generic commentary like 'Unused indexes hurt insert performance and should be dropped') and repeats the same compression ALTER block in three places, so it could be tightened despite being accurate.

2 / 3

Actionability

Nearly every section provides concrete, copy-paste-ready SQL (partition column discovery, chunk interval sizing, PK/constraint migration, blue-green swap, EXPLAIN validation, monitoring views) with specific targets and thresholds, leaving little abstract direction.

3 / 3

Workflow Clarity

The migration is sequenced into three explicit steps with a pre-migration checklist, two named options gated by table size, explicit 'ASK USER PERMISSION' / 'STOP MIGRATION' checkpoints for destructive PK and FK changes, and a post-migration validation phase with good/bad EXPLAIN signs and success criteria.

3 / 3

Progressive Disclosure

The body is well organized by sections but is essentially a monolithic single-file skill; the only external pointers are inline prose mentions of the 'find-hypertable-candidates' and 'setup-timescaledb-hypertables' companion skills (named as text, not linked bundle files), and no references/scripts/assets bundle exists to delegate detail into, so material that could be split out (e.g., the full compression and troubleshooting reference) stays inline.

2 / 3

Total

10

/

12

Passed

Description

82%Weight 40%Scale 1-3

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

A well-structured, complete description with strong natural trigger terms and a clear, distinctive niche. The main weakness is second-person voice ('Use this skill to', trigger phrasings) which violates the third-person guideline and lowers the specificity score.

Suggestions

Rewrite the description in third person ('Migrates identified PostgreSQL tables to TimescaleDB hypertables...') and rephrase the trigger block as impersonal guidance instead of 'Use this skill to' to comply with the third-person voice guideline.

Convert the trigger bullets into a concise 'Use when...' clause so the action list reads as what the skill does rather than prompts the user might type.

DimensionReasoningScore

Specificity

Names the domain (PostgreSQL/TimescaleDB hypertable migration) and several concrete actions ('configure compression after migration', 'validate hypertable migration success', 'plan blue-green migration'), but lists them as user-asked triggers rather than a tight enumeration of what the skill does, and the second-person phrasing ('Use this skill to migrate') reduces specificity by 1 per the guidelines.

2 / 3

Completeness

It clearly answers 'what' ('migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation') and 'when' via an explicit '**Trigger when user asks to:**' block plus a closing step-by-step summary, satisfying both halves with explicit triggers.

3 / 3

Trigger Term Quality

An explicit 'Keywords:' line gives strong natural phrasings a user would say ('migrate to hypertable', 'convert table', 'Timescale', 'blue-green migration', 'create_hypertable') plus a dedicated trigger block covering common request variations.

3 / 3

Distinctiveness Conflict Risk

The niche is narrow and clearly differentiated (TimescaleDB hypertable migration vs plain PostgreSQL or general table work), with Timescale-specific triggers like 'create_hypertable' making conflict with other skills unlikely.

3 / 3

Total

11

/

12

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.