managing-database-testing

This skill manages database testing by generating test data, wrapping tests in transactions, and validating database schemas. It is used to create robust and reliable database interactions. Claude uses this skill when the user requests database testing utilities, including test data generation, transaction management, schema validation, or migration testing. Trigger this skill by mentioning "database testing," "test data factories," "transaction rollback," "schema validation," or using the `/db-test` or `/dbt` commands.

1.04x

Quality

53%

Does it follow best practices?

Impact

90%

1.04x

Average score across 9 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./backups/skills-migration-20251108-070147/plugins/testing/database-test-manager/skills/database-test-manager/SKILL.md

Evaluation results

100%

15%

Demo Environment Data Seeder

Test data generation with Faker and factories

Criteria

Without context

With context

Faker import

100%

Faker instance used

100%

Python implementation

100%

DB library used

100%

INSERT executed

100%

Factory function or class

100%

Realistic name values

100%

Realistic email values

100%

Multiple entities seeded

100%

Usage instructions

100%

90%

37%

Fixing Unreliable Database Integration Tests

Transaction wrapping with automatic rollback

Criteria

Without context

With context

Transaction wrapping

100%

Automatic rollback

100%

No DELETE/TRUNCATE cleanup

100%

Isolation level set

Context manager or fixture

100%

Python test framework

100%

Per-test transaction scope

50%

100%

Rollback on exception

60%

100%

DB library used

100%

Python implementation

100%

98%

-2%

Pre-deployment Schema Verification Tool

Database schema validation

Criteria

Without context

With context

Structured expected schema

100%

Actual schema queried

100%

Column comparison

100%

Data type comparison

100%

Table existence check

100%

Constraint validation

100%

Mismatch reporting

100%

Failure signaling

100%

Python implementation

100%

Migration issue framing

100%

60%

88%

Database Migration Safety Net

Database migration test execution and post-migration integrity verification

Criteria

Without context

With context

Migration script applied

100%

Initial schema setup

100%

New table existence check

100%

New column existence check

100%

Dropped column absence check

100%

Structured expected schema

Data type validation

100%

Failure signaling

100%

Migration framing

100%

Python implementation

100%

DB library used

100%

Execution instructions

100%

92%

-1%

Automated Test Data Seeder

Schema-driven test data generation with Faker

Criteria

Without context

With context

Schema file consumed

100%

Faker import

100%

Realistic name values

100%

Realistic email values

100%

Factory function or class

53%

46%

DB library for INSERT

100%

Python implementation

100%

Multiple tables seeded

100%

Configurable row count

100%

Execution instructions

100%

96%

-2%

Database Testing Foundation for a New Microservice

Integrated database test suite combining data generation, transactions, and schema validation

Criteria

Without context

With context

Transaction wrapping present

100%

Automatic rollback

100%

No DELETE/TRUNCATE cleanup

100%

Isolation level set

100%

50%

Faker import and usage

100%

Factory functions or classes

100%

Realistic name and email data

75%

100%

Schema validation present

100%

Schema validation failure signaling

100%

All three components integrated

100%

DB library used

100%

Python implementation

100%

Execution instructions

100%

Loan Portfolio Test Data Generator

Relational test data factories with FK dependencies

Criteria

Without context

With context

Faker imported

100%

Faker for names

100%

Faker for emails

100%

Factory per entity

100%

FK insertion order

100%

FK values passed explicitly

100%

Python + DB library

100%

Seed volume

100%

Realistic financial values

100%

Run instructions

100%

54%

Parallel Integration Test Infrastructure

Transaction isolation for parallel test execution

Criteria

Without context

With context

Transaction wrapping

Automatic rollback in teardown

No DELETE/TRUNCATE cleanup

100%

Isolation level referenced

Per-test scope

100%

Rollback on exception

25%

50%

Python test framework

100%

DB library used

100%

Isolation strategy documented

100%

Run instructions

100%

Post-Deployment Schema Integrity Checker

Schema constraint validation and data integrity checking

Criteria

Without context

With context

Structured baseline definition

100%

Actual schema queried

100%

Column type comparison

100%

NOT NULL constraint check

100%

UNIQUE constraint check

100%

Foreign key check

100%

Mismatch reporting

100%

Non-zero exit on failure

100%

Zero exit on clean

100%

Python implementation

100%

Run instructions

100%

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: c8a915c

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Demo Environment Data Seeder Fixing Unreliable Database Integration Tests Pre-deployment Schema Verification Tool Database Migration Safety Net Automated Test Data Seeder Database Testing Foundation for a New Microservice Loan Portfolio Test Data Generator Parallel Integration Test Infrastructure Post-Deployment Schema Integrity Checker

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.