Validates database schemas, ensures data integrity, tests migrations, and optimizes query performance.
This skill provides comprehensive patterns for testing data persistence layers, focusing on preventing data loss and corruption. It enables Claude to perform automated schema validation, verify referential integrity through constraint testing, and ensure migrations are both successful and reversible. Additionally, it offers methodologies for testing transaction isolation levels (ACID properties) and analyzing query performance using execution plans to identify bottlenecks before they reach production. It is an essential toolkit for developers and QA engineers who need to maintain robust, performant, and reliable database systems.
主な機能
01Data integrity and foreign key relationship testing
02Automated schema and constraint validation
03Query performance analysis and index optimization
04ACID compliance and transaction isolation verification
05Comprehensive database migration and rollback testing
0681 GitHub stars
ユースケース
01Ensuring data consistency during high-concurrency transaction development
02Verifying complex database migrations in CI/CD pipelines
03Profiling and optimizing slow-running SQL queries using EXPLAIN plans
