database-migrator

Use this skill when the user wants to run database migrations, manage schema changes, use alembic, upgrade or downgrade a database schema, or track schema versions.

Quality

88%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Passed

No findings from the security scan

Quality

Content

83%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 highly actionable, concise reference with strong executable examples across Alembic, raw-SQL, PostgreSQL, and backup flows. The main weakness is workflow clarity: destructive migration operations lack an explicit validation/verification checkpoint and recovery feedback loop.

Suggestions

Add an explicit sequenced migration workflow with a validation checkpoint, e.g. backup → apply → verify current revision / test schema → rollback-on-failure, to lift workflow_clarity above the destructive-ops cap of 3.

Include a validate→fix→retry feedback loop for migration failures (detect failed revision, restore from backup, re-attempt) rather than relying on implicit transaction rollback alone.

Consider moving the longer worked examples (raw SQL MIGRATIONS block, PostgreSQL/backup functions) into reference files to improve progressive_disclosure toward 5.

Dimension	Reasoning	Score
Conciseness	Lean and code-driven with a one-line overview and no padding explaining what databases or Alembic are; every section earns its place.	5 / 5
Actionability	Fully executable bash commands and Python functions throughout — setup, generate, apply, rollback, programmatic migration, status check, version tracking, transactional PostgreSQL, and backups — copy-paste ready for common cases.	5 / 5
Workflow Clarity	Sections are organized and backup/transactional rollback safety is present, but destructive database migrations lack an explicit post-migration validation checkpoint and validate→fix→retry feedback loop, capping the score per the rubric's destructive-ops rule.	3 / 5
Progressive Disclosure	Well-organized with clear section headers and a Quick Reference table, and inline code is appropriate for a reference skill; minor gaps since no bundle files exist and some lengthy blocks (raw SQL MIGRATIONS, PostgreSQL, backups) could be externalized.	4 / 5
	Total	17 / 20 Passed

Description

92%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, third-person description that clearly states capabilities and an explicit trigger clause with concrete natural-language terms. The only gap is a few missing synonyms/extensions in the trigger terms.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions — "run database migrations, manage schema changes, use alembic, upgrade or downgrade a database schema, track schema versions" — with comprehensive coverage matching the 5-anchor.	5 / 5
Completeness	Explicitly answers both: the "what" via concrete migration actions and the "when" via the "Use this skill when the user wants to…" trigger clause.	5 / 5
Trigger Term Quality	Good natural-term coverage ("database migrations", "alembic", "upgrade/downgrade a database schema") users would actually say, but lacks synonyms and file-extension variants that would push it to 5.	4 / 5
Distinctiveness Conflict Risk	A clear niche (database schema migration) with distinct triggers (alembic, schema versions) and minimal overlap risk with unrelated skills.	5 / 5
	Total	19 / 20 Passed

Validation

100%

Warnings & errors only

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: ProwlrBot/prowlr-marketplace
Path: skills/database-migrator/SKILL.md
Commit: 32f0050

Reviewed: 3 days ago

Table of Contents

Discovery Implementation Validation

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.