validating-database-integrity

Process 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".

Install with Tessl CLI

npx tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill validating-database-integrity

What are skills?

Review — 71%

Does it follow best practices?

If you maintain this skill, you can automatically optimize it using the tessl CLI to improve its score:

npx tessl skill review --optimize ./path/to/skill

Learn more

Validation — 9 / 11 Passed

Validation for skill structure

SKILL.md

Review

Evals

Evaluation results

82%

10%

User Registration Data Quality

Plugin usage & validation workflow

Criteria

Without context

With context

Uses plugin package

75%

Rule definition phase

87%

100%

Plugin API for applying rules

83%

Verification step present

62%

87%

Descriptive error messages

100%

50%

Corrective guidance in errors

100%

25%

Valid record test

100%

Invalid record tests

100%

Comprehensive field coverage

100%

Range validation present

100%

Without context: $0.4850 · 1m 56s · 25 turns · 25 in / 7,627 out tokens

With context: $1.0188 · 3m 8s · 29 turns · 10,924 in / 12,240 out tokens

96%

16%

E-Commerce Platform Integrity Overhaul

Multi-layer & comprehensive coverage

Criteria

Without context

With context

Uses plugin package

80%

Type validation present

100%

Range/bound validation present

100%

Format validation present

100%

Referential integrity validated

100%

DB-level rules present

100%

App-level rules present

100%

All three tables addressed

100%

Comprehensive field coverage

100%

Descriptive error messages

100%

80%

Without context: $0.5123 · 2m 31s · 22 turns · 22 in / 8,902 out tokens

With context: $0.9232 · 3m 7s · 29 turns · 1,622 in / 11,340 out tokens

97%

Fintech Transaction Compliance Engine

Business rules & maintainability

Criteria

Without context

With context

Uses plugin package

75%

Business rule: amount range

100%

Business rule: daily limit

100%

Business rule: frozen account

100%

Business rule: high-value pending

100%

Descriptive error messages

100%

Corrective guidance in errors

100%

Externalised rule config

100%

Update mechanism documented

100%

Test coverage per rule

100%

Without context: $0.6937 · 2m 57s · 26 turns · 27 in / 12,464 out tokens

With context: $1.4137 · 4m 36s · 35 turns · 5,514 in / 19,239 out tokens

94%

17%

Clinic Appointment Import Validator

Format & bulk import validation

Criteria

Without context

With context

Uses plugin package

70%

Rule definition phase

37%

100%

Plugin API for rule application

62%

Email format rule

100%

Date format rule

100%

Clinic code format rule

100%

Fee range rule

100%

Comprehensive field coverage

100%

Descriptive field errors

100%

Rule violated in error message

100%

Valid records pass

100%

Without context: $0.3724 · 1m 30s · 19 turns · 19 in / 5,859 out tokens

With context: $1.7583 · 6m 12s · 36 turns · 11,047 in / 25,832 out tokens

96%

14%

Employee Database Validation Retrofit

Verification & conflict reporting

Criteria

Without context

With context

Uses plugin package

80%

Rule definition phase present

100%

Plugin API used for applying rules

75%

Verification step present

100%

Conflict records identified

100%

Conflict rule named

100%

Descriptive error messages

100%

Conflict report file

100%

Comprehensive rule coverage

100%

Clean records not flagged

100%

Without context: $0.3003 · 1m 13s · 14 turns · 13 in / 5,363 out tokens

With context: $1.5740 · 4m 26s · 42 turns · 11,376 in / 17,275 out tokens

89%

Product Catalog Validation Update

Validation rule review & update

Criteria

Without context

With context

Uses plugin package

Gap analysis documented

100%

New field: weight rule

100%

New field: dimensions rule

100%

New field: hazmat_flag rule

100%

Updated price rule

100%

New field: discounted_price rule

100%

Verification step

62%

87%

Descriptive error messages

100%

Updated config/rule file

100%

Review summary produced

100%

Without context: $0.4816 · 2m 15s · 25 turns · 24 in / 7,805 out tokens

With context: $0.6201 · 2m 36s · 28 turns · 28 in / 9,572 out tokens

90%

Legacy Patient Records Cleanup

Data cleanup scripts & re-validation

Criteria

Without context

With context

Violation report produced

100%

Violation counts included

100%

Example values in report

100%

Cleanup uses UPDATE statements

100%

Cleanup uses DELETE statements

100%

All violation categories addressed

100%

Staging-first execution noted

100%

Post-cleanup re-validation performed

100%

Re-validation shows resolved violations

100%

Exceptions documented

100%

Workflow steps present

100%

Without context: $0.6129 · 3m 6s · 24 turns · 24 in / 11,542 out tokens

With context: $1.4138 · 5m 23s · 37 turns · 11,046 in / 17,717 out tokens

96%

Inventory Database Constraint Rollout

Implementation log & staged deployment

Criteria

Without context

With context

Implementation log produced

100%

Timestamps in log

100%

Success/failure per entry

80%

100%

Constraint name in log

100%

Database target in log

100%

Staging applied first

100%

Staging verification step

100%

Production applied after staging

100%

All 5 constraints logged

100%

Maintenance window referenced

50%

Application errors check

100%

Without context: $0.7148 · 2m 52s · 29 turns · 28 in / 12,439 out tokens

With context: $1.2218 · 3m 54s · 34 turns · 5,572 in / 14,580 out tokens

100%

Supply Chain Database Referential Integrity

Foreign key ordering & circular dependency

Criteria

Without context

With context

FK map produced

100%

Circular dependency identified

100%

Referenced-first ordering

100%

Ordering rationale present

100%

ALTER TABLE ADD CONSTRAINT used

100%

SQL in correct dependency order

100%

All 8 FK constraints in SQL

100%

Circular dependency plan addresses deferral

100%

Bulk operation guidance

100%

Ordering comments in SQL

100%

Without context: $0.3301 · 2m 4s · 12 turns · 13 in / 7,482 out tokens

With context: $0.5466 · 2m 27s · 24 turns · 314 in / 8,993 out tokens

Evaluated: about 11 hours ago
Agent: Claude Code

Table of Contents

User Registration Data Quality E-Commerce Platform Integrity Overhaul Fintech Transaction Compliance Engine Clinic Appointment Import Validator Employee Database Validation Retrofit Product Catalog Validation Update Legacy Patient Records Cleanup Inventory Database Constraint Rollout Supply Chain Database Referential Integrity

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.