skills.rest
petrkindlmann
petrkindlmannCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-testing

Automate database migration, integrity, and performance testing across PostgreSQL, MySQL, and MongoDB.

64|12|Updated Mar 23, 2026
Search Tags:#testing#performance#database#migrations#constraints#data-integrity#seed-data
One-click install
npx skills add https://github.com/petrkindlmann/qa-skills --skill database-testing-petrkindlmann
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-testing
Source: https://github.com/petrkindlmann/qa-skills/tree/main/skills/database-testing
Command: npx skills add https://github.com/petrkindlmann/qa-skills --skill database-testing-petrkindlmann

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, and identify query performance issues. Covers PostgreSQL, MySQL, MongoDB with ORMs like Prisma, TypeORM, and SQLAlchemy.

Core Features & Use Cases

  • Migration testing: validate forward and rollback of migrations to ensure safe deployments across environments.
  • Data integrity and constraints: test NOT NULL, UNIQUE, FOREIGN KEY, and CHECK constraints and ensure referential integrity.
  • Seed data strategies: deterministic seeds and upserts to keep tests idempotent across runs.
  • Performance & schema checks: basic performance baselines, index verification, and schema drift detection across databases.

Quick Start

Run migration and seed validation checks against your project's test database to confirm that migrations apply correctly and seed data remains consistent.

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 migrations forward and backward?▼

Test database migrations by validating forward and rollback paths to ensure safe deployments across environments, confirming schema changes apply correctly and reversibly without data loss.

What is the best way to verify database constraints and referential integrity?▼

Verify database constraints by testing NOT NULL, UNIQUE, FOREIGN KEY, and CHECK constraints to ensure referential integrity is maintained across PostgreSQL, MySQL, and MongoDB schemas.

How do I keep seed data deterministic and idempotent across test runs?▼

Keep seed data deterministic by applying upsert strategies and reproducible seeds so database tests remain idempotent and isolated across consecutive runs.

Does database testing work with Prisma, TypeORM, and SQLAlchemy ORMs?▼

Database testing works with Prisma, TypeORM, and SQLAlchemy ORMs, supporting CI-friendly validation patterns, per-test isolation, and reproducible results across PostgreSQL, MySQL, and MongoDB.

How do I detect schema drift and query performance issues across databases?▼

Detect schema drift and performance issues by running index verification, performance baselines, and drift checks across major databases to identify structural deviations and slow queries.

Related Skills

Explore More Software Engineering Skills→
jeremylongshorejeremylongshore
2.6k

optimizing-database-connection-pooling

Generate and configure database connection pool settings across languages.

Community
Intermediate
tabgabtabgab

opp-repl-feature-and-release-tests

Orchestrate opp_repl test suites and aggregate per-suite results for CI release gating.

Community
Advanced
jonnabiojonnabio
6

database-operations

Automate database migrations, schema changes, and query optimization.

Community
Advanced
paleoterrapaleoterra
2

sqlite-test-validator

Validate SQLite migrations and schemas with sqlite_validator.py CLI commands.

Community
Intermediate