validating-database-integrity
tessl install github:jeremylongshore/claude-code-plugins-plus-skills --skill validating-database-integrityProcess use when you need to ensure database integrity through comprehensive data validation. This skill validates data types, ranges, formats, referential integrity, and business rules. Trigger with phrases like "validate database data", "implement data validation rules", "enforce data integrity constraints", or "validate data formats".
Review Score
71%
Validation Score
13/16
Implementation Score
42%
Activation Score
100%
Generated
Validation
Total
13/16Score
Passed| Criteria | Score |
|---|---|
allowed_tools_field | 'allowed-tools' contains unusual tool name(s) |
metadata_version | 'metadata' field is not a dictionary |
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata |
Implementation
Suggestions 4
Score
42%Overall Assessment
This skill has good organizational structure and progressive disclosure but critically lacks actionability - there are no executable SQL examples, constraint syntax, or concrete validation queries despite being a database validation skill. The content describes what to do at a high level but doesn't show how to do it, making it more of a process checklist than a practical skill guide.
Suggestions
- Add concrete SQL examples for each constraint type (CHECK, FOREIGN KEY, NOT NULL) with copy-paste ready syntax
- Include example validation queries to identify constraint violations (e.g., SELECT statements that find invalid data)
- Provide a specific data cleanup script example showing UPDATE/DELETE patterns for common violation fixes
- Remove the empty Overview and Examples sections at the end, or populate them with actual executable examples
| Dimension | Score | Reasoning |
|---|---|---|
Conciseness | 2/3 | The content is reasonably organized but includes unnecessary padding like 'This skill provides automated assistance for data validation engine tasks' and generic sections. The step-by-step instructions could be more concise, and the Overview/Examples sections at the end add no value. |
Actionability | 1/3 | Despite detailed steps, there is no executable code - no SQL examples, no actual constraint syntax, no concrete validation queries. Instructions like 'Generate SQL constraints' and 'Create validation rule definitions' describe rather than demonstrate. |
Workflow Clarity | 2/3 | Steps are clearly sequenced with a logical progression (analyze → define → implement → validate → apply), and there's mention of staging-first deployment. However, validation checkpoints are implicit rather than explicit, and there's no clear feedback loop for the constraint application process itself. |
Progressive Disclosure | 3/3 | Good structure with clear sections and well-organized references to external resources (database-specific docs, templates, testing guidelines). References are one level deep and clearly signaled with file paths. |
Activation
Score
100%Overall Assessment
This is a well-crafted skill description that clearly articulates specific validation capabilities and provides explicit trigger phrases. It uses proper third-person voice and covers the database integrity domain comprehensively. The only minor issue is the awkward 'Process use when' opening phrase which appears to be a typo or grammatical error.
| Dimension | Score | Reasoning |
|---|---|---|
Specificity | 3/3 | Lists multiple specific concrete actions: 'validates data types, ranges, formats, referential integrity, and business rules' - these are distinct, actionable capabilities. |
Completeness | 3/3 | Clearly answers both what ('validates data types, ranges, formats, referential integrity, and business rules') and when ('Trigger with phrases like...' provides explicit trigger guidance). |
Trigger Term Quality | 3/3 | Includes natural trigger phrases users would say: 'validate database data', 'implement data validation rules', 'enforce data integrity constraints', 'validate data formats' - good coverage of variations. |
Distinctiveness Conflict Risk | 3/3 | Clear niche focused on database data validation with specific triggers around 'database', 'integrity constraints', and 'data validation rules' - unlikely to conflict with general document or code skills. |