comparing-database-schemas

Process use when you need to work with schema comparison. This skill provides database schema diff and sync with comprehensive guidance and automation. Trigger with phrases like "compare schemas", "diff databases", or "sync database schemas".

Quality

—

Does it follow best practices?

Impact

—

No eval scenarios have been run

Securityby

Passed

No known issues

Quality

Content

92%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The content is highly actionable and concise with a well-sequenced workflow that includes an explicit validation loop. Its main weakness is progressive disclosure: a usable bundled generator script exists but is never surfaced from SKILL.md.

Suggestions

Reference the bundled generator from the relevant step, e.g. "Run `python scripts/generate_migration_script.py` to emit the migration SQL from the diff report".

Consider moving the Error Handling table and/or Examples into references/ files linked from the body to keep SKILL.md a true overview.

Fix the truncated Overview sentence ("staging vs.") so the section reads as a complete thought.

Dimension	Reasoning	Score
Conciseness	The body is lean and assumes Claude's competence, leading with concrete SQL queries and CLI commands rather than explaining what databases or schemas are; nearly every line is actionable rather than padded.	3 / 3
Actionability	It provides copy-paste-ready executable commands (pg_dump, mysqldump) and specific information_schema / pg_catalog queries for each comparison category, leaving little abstract about how to perform the work.	3 / 3
Workflow Clarity	A clear 10-step numbered sequence culminates in an explicit validation feedback loop (step 10: apply the migration to a copy and re-run the diff expecting zero differences), satisfying the validation checkpoint requirement for destructive database operations.	3 / 3
Progressive Disclosure	Sections are well-organized, but the body is essentially monolithic: the bundled scripts/generate_migration_script.py and the references/assets directories are never referenced or linked from the body, and inline content (error handling, examples) that could live in separate files is not split out.	2 / 3
	Total	11 / 12 Passed

Description

75%

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 covers a well-scoped niche with explicit what-and-when triggers and distinct, natural phrasing. It is held back by a garbled opening clause, some buzzword padding, and limited trigger-term variation.

Suggestions

Fix the malformed opening: lead with a clean third-person capability statement such as "Compares and synchronizes database schemas between two environments."

Drop the fluff phrase "with comprehensive guidance and automation" in favor of listing concrete capabilities (diff report, migration SQL generation, rollback script).

Broaden trigger terms to include natural variations like "schema drift", "compare databases", and "migrate schema".

Dimension	Reasoning	Score
Specificity	The phrase "database schema diff and sync" names the domain and two concrete actions, but the capability statement is padded with fluff ("comprehensive guidance and automation") and the opening "Process use when you need to work with schema comparison" is grammatically garbled, weakening the action list.	2 / 3
Completeness	It explicitly answers both what ("database schema diff and sync") and when ("use when you need to work with schema comparison" plus explicit trigger phrases), satisfying the what-and-when requirement with an explicit Use-when clause.	3 / 3
Trigger Term Quality	It supplies three natural trigger phrases ("compare schemas", "diff databases", "sync database schemas"), but coverage is thin and misses common variations a user might say such as "schema drift", "compare databases", or "migrate schema".	2 / 3
Distinctiveness Conflict Risk	The narrow niche of database schema comparison with distinct triggers ("compare schemas", "diff databases", "sync database schemas") makes it clearly distinguishable and unlikely to fire for unrelated skills.	3 / 3
	Total	10 / 12 Passed

Validation

87%

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 — 14 / 16 Passed

Validation for skill structure

Criteria	Description	Result
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: jeremylongshore/claude-code-plugins-plus-skills
Commit: 2cafb23

Reviewed: 2 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.