CtrlK
BlogDocsLog inGet started
Tessl Logo

postgres-migration

Safe EF Core Migrations workflow for FinanceHub PostgreSQL databases, covering migration creation, SQL script generation and validation, zero-downtime schema updates, lock timeout safety, and rollback procedures.

55

Quality

61%

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 ./.agents/skills/postgres-migration/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

48%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 body is a strong, executable migration runbook with a clearly sequenced multi-step workflow and explicit validation checkpoints. The chief gap is that everything lives in one ~150-line file with no reference split for deeper material.

Suggestions

Move the detailed zero-downtime patterns (Patterns A–C) and the Emergency Safety Checklist into a referenced reference file to improve progressive disclosure.

Trim framing prose such as 'non-negotiable' statements to tighten conciseness.

DimensionReasoningScore

Conciseness

The body is largely efficient — commands, code, and checklists carry the guidance — with only minor explanatory prose like 'non-negotiable' framing that could be trimmed, matching the efficient-but-slightly-padded score-4 anchor.

4 / 5

Actionability

It provides fully executable, copy-paste-ready commands (dotnet ef migrations add/script/bundle/database update) with real flags plus concrete EF builder code, SQL verification, and a pg_index diagnostic query covering the common cases.

5 / 5

Workflow Clarity

Steps 1–5 are clearly sequenced with explicit validation checkpoints (SQL Safety Inspection Checklist, Emergency Safety Checklist) and feedback loops ('If lock_timeout expires... do NOT force locks'), so the destructive-operation cap does not apply.

5 / 5

Progressive Disclosure

The single file is well-organized with clearly numbered section headers, but at ~150 lines with all content inline and no separate reference files, it has minor organization gaps versus the one-level-deep-reference ideal.

4 / 5

Total

18

/

20

Passed

Description

75%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 specific and distinct, enumerating concrete migration workflow actions for a clearly bounded niche. Its main weakness is the absence of an explicit 'Use when...' trigger clause, which caps completeness.

Suggestions

Add an explicit 'Use when...' clause naming natural trigger phrases (e.g., 'Use when modifying FinanceHub PostgreSQL schemas, running EF Core migrations, or planning zero-downtime database changes').

Include common phrasings/synonyms users might say, such as 'schema change' or 'migration script', to broaden trigger-term coverage.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions — 'migration creation, SQL script generation and validation, zero-downtime schema updates, lock timeout safety, and rollback procedures' — giving comprehensive coverage of the workflow, matching the score-5 anchor.

5 / 5

Completeness

There is a clear 'what' but no 'Use when...' clause or equivalent explicit trigger guidance, so per the judging guidelines completeness is capped at 3.

3 / 5

Trigger Term Quality

Natural technical terms a developer would say are present ('EF Core Migrations', 'PostgreSQL', 'rollback', 'zero-downtime'), but it misses some common variations and phrasings like 'schema change' or 'migration script', sitting above the midpoint rather than fully comprehensive.

4 / 5

Distinctiveness Conflict Risk

The combination of 'FinanceHub PostgreSQL databases' with 'EF Core Migrations' carves a clear niche with distinct triggers and minimal conflict risk against other skills.

5 / 5

Total

17

/

20

Passed

Validation

100%

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

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
JoseMD12/finance-hub
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.