managing-database-testing

## Overview This skill empowers Claude to create and manage comprehensive database testing workflows. It facilitates the generation of realistic test data, ensures transactional integrity with automatic rollbacks, and validates database schema integrity. ## How It Works 1. **Test Data Generation**: Generates realistic test data using factories and fixtures, populating the database with relevant information for testing. 2. **Transaction Wrapping**: Wraps database tests within transactions, ensuring that any changes made during the test are automatically rolled back, maintaining a clean testing environment. 3. **Schema Validation**: Validates the database schema against expected structures and constraints, identifying potential issues with migrations or data integrity. ## When to Use This Skill This skill activates when you need to: - Generate test data for database interactions. - Implement transaction management for database tests. - Validate database schema and migrations. ## Examples ### Example 1: Generating Test Data User request: "Generate test data factories for my PostgreSQL database using Faker to populate users and products tables." The skill will: 1. Create Python code utilizing Faker and a database library (e.g., SQLAlchemy) to generate realistic user and product data. 2. Provide instructions on how to execute the generated code to seed the database. ### Example 2: Implementing Transaction Rollback User request: "Wrap my database integration tests in tra...