Can it detect performance issues?

Yes, it includes tools for timing queries and using EXPLAIN plans to identify sequential scans and missing indexes.

Does it support transaction testing?

Absolutely. It offers specific implementation patterns for testing ACID properties and concurrent transaction isolation.

How does this skill help with database migrations?

It provides patterns to test that migrations apply correctly, roll back cleanly, and preserve existing data during schema changes.

Is it compatible with different database types?

While the examples focus on SQL/PostgreSQL, the core principles of schema validation and integrity testing apply to most relational database systems.

Database Testing

Name: Database Testing
Author: Activer007

byActiver007

Database Management

Validates database schemas, ensures data integrity, and verifies migration safety to prevent data loss or corruption.

About

The Database Testing skill provides a comprehensive framework for ensuring the reliability and performance of your data persistence layer. It enables Claude to perform rigorous schema validation, test complex data integrity constraints, and verify that database migrations are both successful and reversible. By focusing on transaction isolation and query performance through tools like EXPLAIN, this skill helps developers catch catastrophic bugs, prevent silent data corruption, and optimize slow-running queries before they reach production environments.

Key Features

Data integrity and foreign key constraint checks
Query performance analysis using EXPLAIN plans
0 GitHub stars
Transaction isolation and ACID property testing
Automated schema and constraint validation
Migration testing with rollback verification

Use Cases

Ensuring concurrent transactions correctly handle updates without race conditions
Verifying that a new database migration doesn't delete existing data
Optimizing slow-running SQL queries by checking for missing indexes

About

Key Features

Data integrity and foreign key constraint checks
Query performance analysis using EXPLAIN plans
0 GitHub stars
Transaction isolation and ACID property testing
Automated schema and constraint validation
Migration testing with rollback verification

Use Cases

Ensuring concurrent transactions correctly handle updates without race conditions
Verifying that a new database migration doesn't delete existing data
Optimizing slow-running SQL queries by checking for missing indexes