BUNDLE Security scanned2 skills

    Database Engineering Suite

    The two reviews that stop database mistakes before they get expensive in production. One plans and executes safe migrations — with rollback plans, backfill strategies, and zero-downtime sequencing — so a schema change never takes prod down. The other reviews your schema, queries, and migrations for the engine-specific mistakes that get slow or dangerous at scale: bad table design, missing indexes, N+1 and slow queries, SQL injection, and locking migrations. Together they cover the full database change lifecycle, from design and query review to safe rollout. Built for backend engineers who own the data layer.

    168 views

    Works with every agent that reads SKILL.md — Claude Code, Cursor, Codex CLI, Gemini CLI, GitHub Copilot, Windsurf, OpenClaw, and more.

    PubsProToolkit
    Created by
    PubsProToolkit
    $38$51
    Save 25% · $13

    One payment, lifetime access. 2 skills unlock instantly in your library.

    30-day refund guarantee

    Instant unlock in your library

    Free updates from the creator

    What's included

    2 skills

    See it in action

    You say

    Add a status column to the orders table (default 'pending', not null) and an index on orders.created_at. We have ~80M rows and cannot take downtime.

    Your agent does

    This needs to be split into 3 deploys to stay online:

    Deploy 1 - add status as a nullable column (instant, no lock). Deploy 2 - backfill status='pending' in 10k-row batches with a resumable script (provided), then add the NOT NULL constraint using NOT VALID + VALIDATE CONSTRAINT to avoid a full-table lock. Deploy 3 - create the created_at index with CREATE INDEX CONCURRENTLY.

    I've generated all three migrations, the batched backfill script, and a matching rollback for each. Estimated index build time at 80M rows: ~6-9 min, no write lock.

    How to install

    Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.

    Reviews

    No reviews yet on the included skills. Be the first to try this bundle.

    Frequently asked questions

    More bundles from PubsProToolkit