Verified:GitHub

test-infrastructure

Set up isolated PostgreSQL testing environments with Testcontainers and per-worker schema isolation.

14|3|Updated Feb 22, 2026

Search Tags:#vitest #testing #database #integration tests #testcontainers #ci

One-click install

npx skills add https://github.com/rnavarych/alpha-engineer --skill test-infrastructure-rnavarych

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: test-infrastructure
Source: https://github.com/rnavarych/alpha-engineer/tree/main/plugins/billy-milligan/skills/quality/test-infrastructure
Command: npx skills add https://github.com/rnavarych/alpha-engineer --skill test-infrastructure-rnavarych

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the setup and management of reliable database testing environments, ensuring tests are isolated, deterministic, and fast, especially in CI.

Core Features & Use Cases

Real Database Testing: Uses Testcontainers for actual PostgreSQL instances, avoiding mock inaccuracies.
Parallel Test Isolation: Implements per-worker schema isolation to prevent test interference.
Test Data Management: Supports deterministic data seeding and ephemeral databases.
Flaky Test Handling: Provides strategies for quarantining and managing intermittent test failures.
Use Case: When integrating a new feature that heavily relies on database interactions, use this Skill to set up a robust, isolated PostgreSQL testing environment that runs quickly and reliably in your CI pipeline.

Quick Start

Set up a real PostgreSQL database for your tests using Testcontainers with a 60-second timeout.

Frequently Asked Questions about test-infrastructure

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

FAQPage Schema

How do I set up isolated PostgreSQL integration tests in Vitest?▼

Testcontainers provides real PostgreSQL instances for integration tests, avoiding mock inaccuracies by spinning up ephemeral databases that mirror production behavior for reliable validation.

How do I prevent flaky database tests during parallel execution in CI?▼

Deterministic test data seeding is configured by defining explicit data sets managed within ephemeral databases, ensuring tests run reliably and predictably across CI pipelines.

Do I need Docker to use Testcontainers for Vitest database testing?▼

Per-worker schema isolation assigns a distinct database schema to each parallel test worker, ensuring tests run simultaneously without interfering with each other's data or execution state.

What are the limitations of using Testcontainers for CI database testing?▼

Testcontainers requires Docker and carries a startup overhead, necessitating a 60-second timeout configuration and strategies for quarantining flaky tests to maintain reliable CI execution.