Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    database test designer

    1

    Design systematic database tests for migrations, constraints, concurrency, and data integrity.

    $6

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    database test designer

    database test designer

    Example session with this skill installed

    Design a test suite for an e-commerce order schema including unique external_id constraints, cascading user deletes, and concurrent inventory updates.

    • Read your context and instructions
    • Compiled the database test designer

    I have analyzed the order schema requirements. Based on the DDL constraints and transactional needs, I have designed a test matrix covering integrity, concurrency, and cleanup.

    Database Test Design: Order Management

    IDRequirement/ObjectSetup/StateOperationExpected DB/App ResultEvidence/AssertionCleanup
    DB-01order.external_id UNIQUEExisting order with ext_123Insert new order with ext_123UniqueViolation error from DBCatch SqlException; check count=1None required
    DB-02user_id FK CascadeUser with 5 active ordersDELETE FROM users WHERE id = XOrders deleted automaticallySELECT COUNT(*) FROM orders WHERE user_id = X is 0Rollback transaction
    DB-03Inventory ConcurrencyItem stock = 1; 2 sessionsSimultaneous UPDATE stock = stock - 1Exactly one commit; one serialization errorInventory >= 0; one 409 conflictReset stock to 1
    DB-04total_amount RangeStandard order sessionInsert total_amount = -1.00CheckConstraint violationDB rejects row; app logs errorNone required

    Integrity Check Scripts

    -- Frequency: Post-Migration / Daily
    -- Check: Orphaned Orders
    SELECT count(*) 
    FROM orders o 
    LEFT JOIN users u ON o.user_id = u.id 
    WHERE u.id IS NULL;
    -- Expected: 0
    -- On-Fail: Alert engineering; investigate FK constraint status.
    

    Seed Data (Disposable Environment)

    BEGIN;
    INSERT INTO users (id, name) VALUES (999, 'Test User');
    INSERT INTO inventory (sku, stock) VALUES ('SKU-01', 1);
    INSERT INTO orders (id, external_id, user_id, total_amount) VALUES (1, 'ext_123', 999, 50.00);
    COMMIT;
    

    Next steps

    1. Confirm the specific isolation level (e.g., Read Committed vs Serializable) configured in your DB engine.
    2. Execute the seed script in a staging/disposable container to verify constraint names.
    3. Integrate the concurrency schedule into your integration test suite using separate DB connections.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Writing database tests often results in superficial checks that miss critical race conditions or migration failures. This skill enforces a systematic approach to verifying data integrity, constraints, and concurrent transactions.

    What it does

    • Schema & Migration Validation Designs scenarios for schema changes, verifying upgrade paths from prior states and assessing rollback loss risks.
    • Constraint Testing Maps null, type, range, unique, and foreign key violations based on DDL definitions.
    • Concurrency Analysis Defines execution schedules to test atomicity and isolation levels under conflicting write conditions.
    • Data Integrity Audits Identifies risks for orphaned records, cascading delete behaviors, and boundary value overflows.
    • Test Artifact Generation Produces structured test matrices and SQL seed scripts for deterministic environment setup and cleanup.

    How it works

    1. Map schema architecture Analyze DDL and application code to identify tables, relationships, and read/write paths.
    2. Derive test cases Generate a matrix of valid CRUD operations and intentional constraint violations.
    3. Verify state transitions Model migrations from specific prior versions using representative data.
    4. Define concurrency invariants Consult engine-specific documentation to predict and test isolation behavior rather than guessing.

    Frameworks & tools

    Works with any relational or NoSQL database engine including PostgreSQL, MySQL, and MongoDB. Supports testing at both the ORM persistence layer and direct SQL/DDL enforcement layer.

    Why this beats prompting it yourself

    Generic prompts fail to distinguish between application-level validation and database-level enforcement. This skill explicitly maps DDL type boundaries, such as integer overflows and timestamp ranges, while enforcing isolation between fixtures and cleanup.

    Use cases

    • Migration safety checks Verifying a complex schema change doesn't corrupt existing production data.
    • Transaction integrity Ensuring inventory counts remain accurate during high-concurrency order spikes.
    • Boundary analysis Testing application behavior when varchar limits or numeric precision constraints are hit.
    • Cleanup validation Confirming cascading deletes remove all associated records without leaving orphans.

    Known limitations

    Does not perform actual destructive checks on production environments. It requires specific engine and version details to avoid incorrect assumptions about cross-engine semantics.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    Requires engine version and DDL context. Cannot perform destructive checks on production. Does not assume down-migrations are lossless.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    Permissions

    Write Files
    Listed2 days ago

    What's inside

    Frequently Asked Questions

    This skill goes beyond basic CRUD checks to identify complex risks like race conditions, migration rollback failures, and specific database engine boundary limits that standard prompts often overlook.

    It supports all major relational databases (PostgreSQL, MySQL, SQL Server) and NoSQL systems like MongoDB, adapting its logic based on the specific engine's isolation levels and constraint behaviors.

    You will receive the specialized agent skill configuration, structured test matrices, and SQL seed script templates designed for deterministic environment setup.

    Yes, the skill is designed to analyze your DDL and application code to identify potential orphans or cascading delete issues before you ever run a migration.

    The skill requires your database engine type and version number to ensure the generated tests account for specific dialect behaviors and transaction isolation semantics.

    New in Data & Databases