database-testing

What problem does it solve?

Database bugs can lead to catastrophic data loss or corruption, yet comprehensive database testing is often overlooked or complex to implement. This Skill provides essential patterns for validating schema, data integrity, migrations, and transaction isolation.

Core Features & Use Cases

• Schema Validation: Automatically verify table structures, column types, and constraints to ensure database design correctness.
• Data Integrity Checks: Test unique constraints, foreign key relationships, and check constraints to prevent invalid data entries.
• Migration Testing: Validate forward and backward migrations, ensuring data preservation and reversibility for safe database evolution.
• Use Case: Before deploying a new feature that modifies your database schema, use this skill to automatically run migration tests, ensuring the new schema is correctly applied, existing data is preserved, and the migration can be safely rolled back if needed.

Quick Start

Write a test to verify that the 'users' table has a unique email constraint and that a foreign key prevents deleting a user with associated orders.