skills.rest
aquariuscook
aquariuscookCOMMUNITY
Explore all skills by this author →
GitHub

database-testing

Test database schemas, data integrity, migrations, transactions, and query performance.

1|Updated Dec 29, 2025
Search Tags:#testing#performance#database#schema#migration#sql#integrity
One-click install
npx skills add https://github.com/aquariuscook/Agent_Modus_Map --skill database-testing-aquariuscook
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-testing
Source: https://github.com/aquariuscook/Agent_Modus_Map/tree/main/.claude/skills/database-testing
Command: npx skills add https://github.com/aquariuscook/Agent_Modus_Map --skill database-testing-aquariuscook

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses critical issues in database management by ensuring data integrity, validating schema changes, testing migration reliability, and optimizing query performance.

Core Features & Use Cases

  • Schema Validation: Verifies that database schemas (tables, columns, constraints) meet expected standards.
  • Data Integrity Testing: Ensures data adheres to defined constraints (unique, foreign key, check).
  • Migration Testing: Validates that database schema migrations can be applied forward and rolled back safely, preserving data.
  • Transaction Testing: Confirms ACID properties and isolation levels for concurrent operations.
  • Query Performance Analysis: Identifies slow queries and missing indexes.
  • Use Case: Before deploying a new version of your application, use this Skill to automatically test all database migrations, ensuring they won't cause data loss or performance degradation in production.

Quick Start

Run comprehensive database tests against your PostgreSQL instance.

Frequently Asked Questions about database-testing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I test database schema migrations before deploying to production?▼

Database migration testing validates that schema migrations apply forward and roll back safely while preserving data. This process automatically detects migration failures, data loss, and schema constraint violations before production deployment.

What is database data integrity testing and how does it detect orphaned records?▼

Data integrity testing verifies that records adhere to defined database constraints like unique, foreign key, and check rules. It automatically detects orphaned records and missing constraints to ensure relational consistency across tables.

How can I analyze SQL query performance and identify missing indexes?▼

SQL query performance analysis identifies slow queries and missing indexes within the database. By examining execution paths and bottlenecks, it highlights performance degradation issues to optimize transaction throughput.

How do I verify ACID compliance and transaction isolation levels for concurrent database operations?▼

Transaction testing confirms ACID properties and validates isolation levels for concurrent database operations. It detects transaction anomalies to ensure data consistency during parallel processing and complex multi-step workflows.

Can I validate database schema standards across multiple database types?▼

Schema validation verifies database schemas, including tables, columns, and constraints, against expected standards across multiple database types. This ensures structural consistency and compliance before application deployment.

What is the best way to automate database testing for schema changes and performance bottlenecks?▼

Automated database testing runs comprehensive checks for schema validation, data integrity, and query performance to detect critical issues. This approach identifies missing constraints, orphaned records, and performance bottlenecks without manual intervention.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
cc01cccc01cc
4

multi-package-coverage-audit

Consolidate test coverage gaps across multi-package monorepos into prioritized test plans.

Community
Intermediate
highflame-aihighflame-ai
4

ship

Orchestrate parallel subagent analysis for pre-merge code review and post-deployment verification.

Official
Advanced
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate