CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

flyway-migration

Creates versioned Flyway database migration scripts (V*.sql) with sequences, tables, constraints, and foreign keys from the entity model. Use when the user asks to "create a migration", "generate SQL scripts", "set up database tables", "write a Flyway migration", or mentions schema migration, DB migration, database versioning, or SQL migration files.

1.11x
Quality

93%

Does it follow best practices?

Impact

96%

1.11x

Average score across 15 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

The canonical home for this skill is ai-unified-process/aiup-vaadin-jooq

SKILL.md
Quality
Evals
Security

Quality

Content

86%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.

A tight, actionable skill body with project-specific rules, a complete SQL example, and a validated workflow. The two gaps keeping it from the top tier are the missing foreign-key example in the sample migration and the absence of an error-recovery loop after the validation step.

Suggestions

Extend the example migration (or add a second, e.g. V003__create_reservation_table.sql) to show foreign key syntax, since FKs are a core deliverable the DO NOT section says must never be skipped.

Add a feedback loop after the validation step in the Workflow, e.g. 'If any check fails, fix the migration and re-validate before writing the file', to reach the rubric's error-recovery standard for database operations.

DimensionReasoningScore

Conciseness

The body is lean and entirely project-specific: the binary-column convention ('BYTEA on PostgreSQL, BLOB... elsewhere — never VARCHAR or Base64 text'), sequence-for-PK rule, and '{table_name}_seq' pattern are things Claude could not know, and no general SQL or Flyway concepts are explained. The prompt-injection guardrail is the only lengthy passage, but it earns its place since the workflow reads project files; it does not rise to the 'minor instances of over-explanation' of anchor 4.

5 / 5

Actionability

The example migration is complete, executable SQL and the naming convention gives concrete file names, but the example shows no foreign key — a core deliverable the skill explicitly forbids skipping ('Skip foreign key constraints defined in the entity model'). This is the 'minor gaps' of anchor 4 rather than the full common-case coverage of anchor 5.

4 / 5

Workflow Clarity

The six-step workflow is clearly sequenced with an explicit validation step listing four concrete checks (entity coverage, FK ordering, sequence naming, SQL validity), and the DO NOT section guards the destructive case (dropping tables). It falls short of anchor 5 because there is no error-recovery feedback loop (e.g., 'if a check fails, fix and re-validate'), which the rubric flags as important for database operations; validation is present, so anchor 3 does not fit.

4 / 5

Progressive Disclosure

This is a compact single-file skill with no bundle files; the body is organized into clear sections (Instructions, DO NOT, File Naming Convention, Example Migration, Workflow) and nothing is inlined that belongs in a separate reference file. Under the rubric's simple-skill guidance, well-organized sections with no need for external references score 5.

5 / 5

Total

18

/

20

Passed

Description

96%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.

A strong description that clearly and concretely states both what the skill produces and when to use it, with abundant natural trigger phrases in third person. The only weakness is a couple of generic trigger terms that could overlap with broader SQL-generation skills.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions — 'Creates versioned Flyway database migration scripts (V*.sql) with sequences, tables, constraints, and foreign keys from the entity model' — in third person, comprehensively covering the skill's deliverables. It exceeds anchor 4 because the action list covers the domain's components (sequences, tables, constraints, FKs) without gaps.

5 / 5

Completeness

It explicitly answers both questions: the first sentence states what the skill does, and 'Use when the user asks to... or mentions...' provides explicit when-guidance with concrete trigger phrases. This mirrors the anchor-5 example structure exactly; anchor 4 would require the when-clause to be less explicit.

5 / 5

Trigger Term Quality

It includes natural quoted phrases users would say ('create a migration', 'generate SQL scripts', 'write a Flyway migration') alongside synonyms and variations ('schema migration, DB migration, database versioning, or SQL migration files'). This matches the anchor-5 level of comprehensive natural-term coverage including synonyms.

5 / 5

Distinctiveness Conflict Risk

'Flyway', 'V*.sql', and migration versioning establish a clear niche, but generic trigger phrases like 'set up database tables' and 'generate SQL scripts' create minor overlap risk with general SQL/DDL-generation skills. Anchor 4 ('mostly distinct; minor overlap risk with closely related skills') fits better than 5, whose example triggers are all domain-unique.

4 / 5

Total

19

/

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.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

AI-Unified-Process/marketplace

Path

aiup-vaadin-jooq/skills/flyway-migration/SKILL.md

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.