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.

Install with Tessl CLI

npx tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill managing-database-testing

What are skills?

1.05x

Review — 60%

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

Evaluation — 90%

↑ 1.05x

Agent success when using this skill

Validation — 11 / 11 Passed

Validation for skill structure

SKILL.md

Review

Evals

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%

Without context: $0.2993 · 3m 30s · 20 turns · 21 in / 4,597 out tokens

With context: $0.5792 · 4m 4s · 33 turns · 31 in / 7,178 out tokens

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%

Without context: $0.3627 · 3m 20s · 24 turns · 25 in / 4,340 out tokens

With context: $0.5159 · 3m 52s · 27 turns · 173 in / 6,243 out tokens

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%

Without context: $0.2567 · 2m 49s · 13 turns · 14 in / 5,001 out tokens

With context: $0.5353 · 4m 6s · 30 turns · 29 in / 7,648 out tokens

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%

Without context: $0.5302 · 4m 5s · 29 turns · 29 in / 8,051 out tokens

With context: $0.6014 · 4m 4s · 31 turns · 63 in / 8,213 out tokens

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%

Without context: $0.3739 · 3m 14s · 18 turns · 19 in / 6,186 out tokens

With context: $0.8944 · 4m 54s · 43 turns · 445 in / 11,457 out tokens

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%

Without context: $0.9766 · 7m 29s · 37 turns · 38 in / 15,048 out tokens

With context: $0.8830 · 4m 59s · 40 turns · 121 in / 12,676 out tokens

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%

Without context: $0.4372 · 4m 5s · 26 turns · 26 in / 6,305 out tokens

With context: $0.5129 · 3m 58s · 28 turns · 314 in / 6,885 out tokens

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%

Without context: $0.3892 · 4m 5s · 25 turns · 25 in / 4,955 out tokens

With context: $0.5240 · 4m 17s · 32 turns · 64 in / 6,156 out tokens

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%

Without context: $0.6621 · 4m 9s · 29 turns · 30 in / 10,102 out tokens

With context: $0.8139 · 4m 37s · 35 turns · 322 in / 12,879 out tokens

Evaluated: 4 days ago
Agent: Claude Code
Model: Unknown

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.