CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

db-migrations

Create, review, test, rebase, and rollback Alembic database migrations for OPRE OPS. Use this skill whenever the user mentions database migrations, alembic, schema changes, adding/modifying columns or tables, model changes that need migration, "migrate the database", or a migration chain conflict / divergent heads after main has moved forward. Also use when a model change has been made and the user needs to generate the corresponding migration.

Quality

94%

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

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 operational skill body: executable commands for all eight subcommands, clearly sequenced workflows with genuine validation checkpoints (round-trip upgrade/downgrade tests, alembic heads confirmation), and rare project-specific gotchas that Claude could not infer. The main lever is structural — the long rebase procedure and pitfall detail could move to reference files to trim the main body.

Suggestions

Move the detailed ~60-line rebase procedure (Steps 1-5) into a references/rebase.md and keep a short summary in SKILL.md, so the main body stays a lean dispatch overview.

Condense the rebase Step 5 stale-Docker-image explanation into a compact 'Gotcha:' bullet (rebuild data-import before testing; alembic current only reads the version table) to cut ~80 words.

Move the sqlalchemy-continuum version-tables pitfall detail (create_type=False, which models need <table>_version) into a reference file or trim it to the two actionable rules.

DimensionReasoningScore

Conciseness

The body is dense with project-specific, non-obvious knowledge (divergent-head rebasing, the stale data-import Docker image, sqlalchemy-continuum version tables) and mostly skips concepts Claude already knows. It is not a 5 because several prose passages could be trimmed — e.g. "because that's where alembic.ini lives and where models is importable" and the ~120-word stale-image explanation in rebase Step 5 — but not a 3 because there is no real padding.

4 / 5

Actionability

Every subcommand ships copy-paste-ready bash: "alembic revision --autogenerate -m \"your migration message\"", "git show origin/main:backend/alembic/versions/<new-file>.py > ...", "docker compose --profile setup up db data-import --build -d", plus concrete autogenerate-review checklists. Placeholders like <new-file>.py are inherently variable filenames, not pseudocode, so the guidance is fully executable.

5 / 5

Workflow Clarity

Multi-step flows are numbered with explicit validation checkpoints and feedback loops: create's "Review the generated migration (critical!)" checklist and upgrade → verify → downgrade → re-apply round-trip, and rebase's "Confirm with alembic heads — it should report exactly one head" plus a real downgrade/upgrade round-trip with "\d <table>" schema checks. The destructive/batch database operations all carry verification, so the workflow-clarity cap at 3 does not apply.

5 / 5

Progressive Disclosure

As a single-file skill it is well structured — an argument-dispatch section per subcommand, a Key File Locations index, and a Common Pitfalls section make navigation easy. It is not a 5 because the ~60-line rebase procedure and the deep pitfall detail would sit more naturally in references/ files, and no bundle files exist to split the 240-line body.

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.

A model description: concrete action verbs in third person, an explicit 'Use this skill whenever...' trigger clause with natural keywords and synonyms, and a tightly-scoped niche (Alembic migrations for OPRE OPS). It covers what, when, and edge-case triggers without padding.

DimensionReasoningScore

Specificity

The description lists five concrete actions — "Create, review, test, rebase, and rollback Alembic database migrations for OPRE OPS" — comprehensively covering the skill's capability set, which mirrors the body's full command set. It is not a 4 because there are no coverage gaps: every verb corresponds to a real subcommand.

5 / 5

Completeness

It explicitly answers both "what" (sentence 1: create/review/test/rebase/rollback) and "when" ("Use this skill whenever the user mentions...") with concrete trigger phrases, and adds a second "when" clause ("Also use when a model change has been made..."). Matches the 5 anchor exactly.

5 / 5

Trigger Term Quality

Natural triggers include "database migrations, alembic, schema changes, adding/modifying columns or tables, model changes that need migration, 'migrate the database', or a migration chain conflict / divergent heads" — covering the tool name, plain-language phrasings a user would actually say, and workflow synonyms. Not a 4 because no common variation of the trigger vocabulary is missing for this domain.

5 / 5

Distinctiveness Conflict Risk

"Alembic database migrations for OPRE OPS" carves out a clear niche with distinct triggers like "migration chain conflict / divergent heads after main has moved forward"; minimal conflict risk with other skills. Not a 4 because the triggers are tied to a specific tool and project rather than a broad domain.

5 / 5

Total

20

/

20

Passed

Validation

87%

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

Validation — 14 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

allowed_tools_field

'allowed-tools' contains unusual tool name(s)

Warning

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

14

/

16

Passed

Repository

HHS/OPRE-OPS

Path

.claude/skills/db-migrations/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.