Integration Test Builder

What it does

This skill enables AI agents to build comprehensive integration tests for APIs and database flows. It provides a test harness setup, including database migration management using Prisma, data clearing before each test, and seeding of initial test data. The skill facilitates the creation of API integration tests, allowing verification of API endpoints and interactions with databases.

When to use it

• When you need to automate testing of an API's functionality.
• To ensure database flows are working as expected after code changes.
• For creating repeatable test environments that clear data before each run.

Key capabilities

• Test Harness Setup: Provides a pre-configured environment for running integration tests, including Prisma client initialization and database management.
• Database Migration Management: Automatically runs Prisma migrations to deploy the latest schema changes.
• Data Clearing: Clears all data from the test database before each test run using TRUNCATE TABLE.
• Test Data Seeding: Allows for seeding of initial test data, such as creating a default user via Prisma.
• API Integration Testing: Supports building tests to verify API endpoints (e.g., POST /api/users).

Example prompts

• "Build an integration test for the /api/users endpoint."
• "Create a test harness setup with Prisma and seed a user fixture."
• "Generate a test case that verifies creating a new user via the API."

Tips & gotchas

• Requires a TEST_DATABASE_URL environment variable to be set.
• The skill uses Prisma for database interactions, so familiarity with Prisma is helpful.
• The provided code examples use TypeScript and Supertest; ensure your testing framework supports these technologies.