Works with the AI tools you already use

    CClaude CodeCCursorCCodex CLIGGitHub CopilotGGemini CLIVVS CodeWWindsurfMManus+14 more

    Database Schema & Query Review Gate

    by PubsProToolkit

    1

    A bad query is a slow afternoon; a wrong table design or a migration that locks prod can hold your data and your users hostage.

    Secure checkout via Stripe

    0 installsSecurity scanned

    See it in action

    You say

    "Review this migration and these queries before I ship — Postgres."

    Your agent does

    A BLOCK verdict: the migration adds a NOT NULL column to a 50M-row table (it'll rewrite/lock prod — add nullable, backfill in batches, then set NOT NULL); a query filtering WHERE lower(email) can't use a plain index (add an expression index); and the orders.user_id foreign key has no index. Each with the fix, prioritized, ending in "BLOCK until the migration is non-locking."

    What you get

    Review a schema or migration before shipping it to production.Diagnose and fix a slow query (missing index, N+1, full scan).Check a migration won't lock or break your prod database.Catch SQL injection in string-built queries.

    About this skill

    A bad query is a slow afternoon; a wrong table design or a migration that locks prod can hold your data and your users hostage. This gate reviews schema, queries, and migrations for what actually bites in production and returns a clear ship decision.

    It runs an engine-aware review (Postgres, MySQL, SQLite, SQL Server):

    • Schema design — right types, primary/foreign keys, constraints that enforce invariants, sensible normalization

    • Indexing — missing indexes on FKs and WHERE/JOIN/ORDER BY columns, composite order, over-indexing, engine-appropriate index types

    • Queries — N+1 patterns, SELECT *, full scans, functions on indexed columns, OFFSET pagination, and more

    • Security — SQL injection (string-built queries) and least privilege

    • Migration safety — destructive/irreversible ops, table-locking rewrites on big tables, backfill and rollback plans

    You get a PASS / REVIEW / BLOCK verdict with prioritized fixes, and it points you to EXPLAIN ANALYZE to confirm performance rather than guessing. It's a static review — it defers to your engine's docs and doesn't replace running it on real data.

    How to install

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

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    30-day refund

    Not a fit? Get your money back

    Trust & safety

    Security scanned

    Verified clean 1 month ago

    Listed1 month ago

    Creator

    PubsProToolkit builds rigor-first skills for AI agents — they write your docs and content properly, then adversarially review them to catch what's wrong before it ships. The result: cleaner output and a hard quality gate in one toolkit. Built by a CMPP-certified, PhD medical writer who brings regulated-industry standards to developer docs, content, compliance, and research integrity.

    Frequently Asked Questions

    Popular in Data Engineering