What database systems are supported by this skill?

This skill is specifically designed for Postgres using Testcontainers. Other dependencies like Redis, MQ, or HTTP have their own specialized generators.

Does it handle schema migrations automatically?

Yes, it configures Flyway within the test lifecycle to ensure your integration tests always run against the latest schema version.

Can I use this for MyBatis-Plus projects?

Absolutely. It is optimized for @MybatisPlusTest and includes specific handling for UUID type handlers and Spring Boot test slices.

How does it ensure test isolation?

The generated tests include @BeforeEach cleanup logic to truncate touched tables and use unique identifiers per test case to prevent state leakage.

Postgres DB Integration Test Generator

Name: Postgres DB Integration Test Generator
Author: ryan-alexander-zhang

byryan-alexander-zhang

0•

Gestión de Bases de Datos

Generates automated Postgres integration tests for Java infrastructure layers using Testcontainers and Flyway migrations.

This skill streamlines the development of robust integration tests for Java-based infrastructure components like MyBatis-Plus mappers, stores, and repositories. It automates the setup of Postgres-backed test environments using Testcontainers and ensures schema consistency via Flyway migrations. By generating comprehensive test suites that cover complex behavior matrices—including status transitions, Compare-And-Swap (CAS) logic, and idempotency—it helps developers catch persistence bugs early and verify infrastructure semantics without manual boilerplate.

Características Principales

01Automated generation of Postgres-backed *IT.java test suites

02Seamless integration with Testcontainers and Flyway schema migrations

03Pre-configured @MybatisPlusTest slices for repository testing

04Built-in support for testing CAS, idempotency, and state transitions

050 GitHub stars

06Standardized isolation patterns including automatic table cleanup

Casos de Uso

01Testing complex database persistence and repository implementation behavior

02Verifying Flyway migration integrity against real Postgres instances

03Validating infrastructure-level idempotency and concurrency guards

Características Principales

01Automated generation of Postgres-backed *IT.java test suites

02Seamless integration with Testcontainers and Flyway schema migrations

03Pre-configured @MybatisPlusTest slices for repository testing

04Built-in support for testing CAS, idempotency, and state transitions

050 GitHub stars

06Standardized isolation patterns including automatic table cleanup

Casos de Uso

01Testing complex database persistence and repository implementation behavior

02Verifying Flyway migration integrity against real Postgres instances

03Validating infrastructure-level idempotency and concurrency guards