database-testing

This skill provides a specialized framework for comprehensive database testing within your quality engineering workflow. It is designed for engineers, database administrators, and QA specialists who need to verify persistence layers, ensure data consistency across complex relational models, and validate the safety of database schema migrations. By leveraging a fleet of agents including the test-data-architect, test-executor, and performance-tester, this skill automates the validation of ACID properties, concurrent access, and query optimization, preventing catastrophic data loss or corruption in production environments.

• Automated schema validation against specifications (tables, columns, constraints).

• Data integrity verification for unique constraints, foreign keys, and referential integrity.

• Safe migration testing, including forward and rollback path verification and data preservation checks.

• Transaction isolation testing to identify concurrency bugs and deadlocks.

• Performance benchmarking for query execution and index usage analysis.

• Automated generation of realistic, integrity-aware test data for large-scale integration testing.

• Use this skill during CI/CD pipeline integration to ensure database changes do not break downstream logic or cause performance regressions.

• Always test migration scripts in staging environments to verify reversible state changes before production deployment.

• Inputs typically include target database schemas, SQL migration files, and performance benchmarks; outputs include validation reports, integrity snapshots, and performance optimization recommendations.

• Strictly prioritize transaction testing when implementing features involving high concurrent access or sensitive financial calculations.

• Integrates directly with existing testing frameworks and orchestrates specialized agents to handle complex stateful testing scenarios without manual intervention.