CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

flyway-schema

Builds the migration layer of a use case (UC-XXX) with Flyway: versioned V*.sql scripts with sequences, tables, snake_case columns, CHECK and UNIQUE constraints, and foreign keys from the entity model, placed in the migration location docs/architecture/stack.md records, and only the tables, columns, and constraints the use case needs that the schema does not have yet. Marks a constraint that enforces a business rule with -- UC-XXX BR-YYY. Normally run by /use-case-implement as the first layer; can be run directly, with a use case or for the whole entity model. Use when the user asks to "create a migration", "write a Flyway migration", "add a column", "create the tables for UC-001", "set up the database schema", or mentions Flyway, schema migration, DB migration, database versioning, or SQL migration files in a project that combines layer plugins. Test data migrations belong to the test skills.

Quality

92%

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

80%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, well-structured body with exemplary token efficiency and clean one-level reference splitting. Its weakness is the absence of any validation/verification step in a database-operation workflow, which the rubric caps at 3, and the lack of an example migration file that would make the guidance fully copy-paste ready.

Suggestions

Add a verification step to the workflow, e.g. 'Confirm the chosen V<n> version number does not collide with existing migrations in src/main/resources/db/migration/ and every CHECK/UNIQUE constraint traces to an entity or business rule in docs/entity_model.md'.

Include a short example V-file snippet (one table with a business-rule CHECK and its '-- UC-XXX BR-YYY:' marker) so the naming and marker conventions are copy-paste ready.

State in the workflow what to do if a constraint cannot be expressed (e.g., a rule the entity model implies but SQL cannot enforce), giving the author an explicit fallback instead of an implicit judgment call.

DimensionReasoningScore

Conciseness

The ~45-line body is lean and assumes Claude's competence: it never explains what Flyway or a migration is, and every sentence is imperative project-specific direction ('Write only the tables, columns, and constraints the use case needs', 'Never touches an applied migration'). Nothing can be trimmed without losing information, matching the 5 rather than the 4 anchor.

5 / 5

Actionability

Concrete, executable guidance is present — the naming convention 'V<n>__<description>.sql', exact marker syntax '-- UC-XXX BR-YYY: <rule> on the line above it', and a copy-paste Handover template — but no example SQL of a migration showing the naming and marker conventions in situ. For an instruction-only skill this is the 'concrete guidance with minor gaps' of the 4 anchor; it falls short of 5 because the core artifact (a V-file) is never exemplified.

4 / 5

Workflow Clarity

The four steps are clearly sequenced with a conditional branch ('When the schema already has everything, write nothing and say so in the Handover'), but there is no validation or verification step — nothing confirms the chosen version number is free after writing, that each constraint traces to the entity model, or that the SQL is sound. Per the rubric's scoring notes, database operations without a validate-feedback loop cap workflow_clarity at 3, which matches the 'steps listed but validation gaps' anchor.

3 / 5

Progressive Disclosure

The under-50-line body is cleanly sectioned, and the verbatim Markers rows are appropriately split into a real, clearly signaled one-level-deep reference ([references/markers.md](references/markers.md)) rather than inlined. The unreferenced references/layer.md is self-documented infrastructure for /stack's glob discovery, not skill content, so it does not constitute a navigation gap — the content matches the 5 anchor.

5 / 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.

An exemplary description: concrete third-person capability list, explicit 'Use when' clause with quoted user utterances and synonyms, clear boundary exclusions, and near-zero conflict risk. Every dimension sits squarely on its 5 anchor.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions — 'versioned V*.sql scripts with sequences, tables, snake_case columns, CHECK and UNIQUE constraints, and foreign keys from the entity model' and 'Marks a constraint that enforces a business rule with -- UC-XXX BR-YYY' — with comprehensive, non-abstract coverage in third person. It is not the 4 anchor because there are no minor coverage gaps; every clause names a concrete capability.

5 / 5

Completeness

It explicitly answers both 'what' ('Builds the migration layer of a use case (UC-XXX) with Flyway: ...') and 'when' ('Use when the user asks to ... or mentions Flyway, schema migration, ...') with concrete trigger phrases, and adds boundary guidance ('Test data migrations belong to the test skills'). This is the 5 anchor verbatim in structure; the 4 anchor's 'when could be more explicit' does not apply since the when-clause enumerates exact utterances.

5 / 5

Trigger Term Quality

It covers natural user phrasings ('create a migration', 'write a Flyway migration', 'add a column', 'create the tables for UC-001', 'set up the database schema') plus synonyms ('schema migration, DB migration, database versioning, or SQL migration files') and the file-extension form ('V*.sql'). This matches the 5 anchor's comprehensive synonym/extension coverage; the 4 anchor would require missing natural terms, and none are missing.

5 / 5

Distinctiveness Conflict Risk

The skill occupies a clear niche — Flyway schema migrations driven by a use case entity model — with distinct triggers (Flyway, V*.sql, SQL migration files) and explicit de-scoping of test data. The 4 anchor's 'minor overlap risk with closely related skills' is not present: the trigger set is scoped to 'a project that combines layer plugins' and test-migration territory is explicitly excluded.

5 / 5

Total

20

/

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-core/evals/stack-angular-jpa-api-integration/layer-skills/flyway-schema/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.