CtrlK
BlogDocsLog inGet started
Tessl Logo
PluginPublic

ai-unified-process/aiup-flyway

AI Unified Process migration layer - Flyway schema migrations from the entity model

1.06x
Quality

95%

Does it follow best practices?

Impact

100%

1.06x

2 of 3 eval scenarios. Add 1 more for a full score.

SecuritybySnyk

Passed

No findings from the security scan

Overview
Quality
Evals
Security
Files

Quality

Content

88%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 strong, highly actionable skill body: concrete conventions, an executable example, a complete handover template, and a workflow with real validation and a fix-and-retry loop. Its weaknesses are minor — some duplicated rationale between Instructions, Schema Conventions, and DO NOT, and stable lookup material (version-specific dependencies) inlined rather than split into a reference file.

Suggestions

State the Flyway checksum rationale once (it currently appears in both Instructions and DO NOT) and cross-reference it from the other section.

Move the Spring Boot 3/4 and Flyway 10 database-module dependency lookup to a reference file (e.g. references/dependencies.md), keeping a one-line pointer in 'Flyway on the Classpath'.

Trim DO NOT items that restate Schema Conventions (auto-increment, camelCase, test data) down to the prohibitions not already stated elsewhere.

DimensionReasoningScore

Conciseness

Nearly every section carries project-specific rules Claude could not infer (migration location precedence, Spring Boot 4 vs 3 starters, naming conventions), with no explanation of basic concepts. It stops short of level 5 because of redundancy: the checksum rationale ("Flyway checksums applied scripts") appears in both Instructions and DO NOT, and DO NOT restates Schema Conventions items ("Use auto-increment or identity columns", "camelCase", "Write test data").

4 / 5

Actionability

Fully executable throughout: a complete example migration (CREATE SEQUENCE room_type_seq..., named constraints room_type_name_uk, room_type_capacity_ck), exact dependency coordinates ("spring-boot-starter-flyway", "org.flywaydb:flyway-database-postgresql"), concrete naming patterns ("V001__create_room_type_table.sql", "CONSTRAINT {table}_{column}_{uk|ck|fk}"), and a copy-paste Handover template covering the common cases including 'Build: missing' and 'Nothing to do'.

5 / 5

Workflow Clarity

The 9-step Workflow is clearly sequenced with an explicit validation checkpoint (step 7's checklist) and a feedback loop: "When a check or the build fails, fix the new migration — it has not run anywhere yet — and repeat this step until both pass." Destructive operations are guarded ("Create a migration that drops a table or a column without explicit confirmation from the user"), meeting the level-5 anchor with validation, error recovery, and a checklist.

5 / 5

Progressive Disclosure

Both bundle files exist and are well-signaled one level deep: references/markers.md ("[references/markers.md](references/markers.md)") and references/layer.md (described in Resources as "this skill's row of the layer catalog"); neither points further into the bundle. It sits at level 4 rather than 5 because the ~240-line body inlines reference-shaped material — notably the Spring Boot 3/4 and Flyway 10 dependency lookup table in 'Flyway on the Classpath' — that could live in a reference file with a pointer.

4 / 5

Total

18

/

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 exemplary: it states concrete capabilities (versioned V*.sql scripts with sequences, constraints, business-rule markers, complete-table vs ALTER TABLE policy), gives explicit 'Use when' triggers with natural phrasings and synonyms, and draws clear boundaries against the test skills and other layers. Its only cost is density — it packs a lot into one paragraph — but every clause is informative rather than padded.

DimensionReasoningScore

Specificity

Lists multiple concrete, comprehensive actions: "versioned V*.sql scripts with sequences, tables, snake_case columns, CHECK and UNIQUE constraints, and foreign keys from the entity model", "ALTER TABLE only where an existing table lags behind the entity model", and the concrete marker syntax "-- UC-XXX BR-YYY". Nothing is generic; it matches the 'multiple specific concrete actions; comprehensive coverage' anchor, not the level-4 anchor with 'minor gaps in coverage'.

5 / 5

Completeness

Explicitly answers both questions: what ("Builds the migration layer of a use case (UC-XXX) with Flyway: versioned V*.sql scripts...") and when ("Use when the user asks to 'create a migration'..."). This is the level-5 pattern of a clear 'what' plus a concrete 'Use when' clause with trigger phrases; the level-4 anchor's 'when could be more explicit' does not apply.

5 / 5

Trigger Term Quality

Quotes natural user phrasings directly — "create a migration", "write a Flyway migration", "add a column", "create the tables for UC-001", "set up the database schema" — and adds the synonyms "schema migration, DB migration, database versioning, or SQL migration files". Coverage including variations matches the level-5 anchor rather than the level-4 anchor that misses a few natural terms.

5 / 5

Distinctiveness Conflict Risk

A clear niche (Flyway schema migrations for use cases) with distinct, technology-specific triggers, plus explicit boundaries: "Test data migrations belong to the test skills" and "in a project that combines layer plugins". Minimal conflict risk, matching the level-5 'clear niche with distinct triggers' anchor rather than level 4's 'minor overlap risk'.

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.

Reviewed

On this page