More screenshots

    Works with the AI tools you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIGitHub CopilotGitHub CopilotGemini CLIGemini CLI+20 more

    Schema Guardrail & API Contract Enforcer

    1

    Prevents breaking database migrations, API contract drifts, and schema changes in AI-generated code.

    $19

    Secure checkout via Stripe

    30-day refund guarantee

    Converts to your local currency at checkout

    0 installsSecurity scanned
    Schema Guardrail & API Contract Enforcer

    Schema Guardrail & API Contract Enforcer

    Example session with this skill installed

    I am refactoring our user profile service. Please update the users database table to drop the legacy_phone column, change the user_role column from string to an enum type, and update our TypeScript interface to remove legacy_phone. Generate the migration file and commit the changes.

    • Read your context and instructions
    • Compiled the schema guardrail

    ⚠️ Schema Guardrail Analysis Triggered

    I evaluated your request against the active schema-guardrail-pro safety rules. direct execution was blocked because it contains

    2 breaking production changes.

    🔍 Risk Summary

    TargetChange TypeDetected RiskAction Required
    users.legacy_phoneDROP COLUMNInstant data loss & runtime errors on unupdated clientsDeprecation cycle required
    users.user_roleType MutationDB table lock & failure on existing string valuesMulti-step migration required

    🛡️ Executed Safe Alternative Strategy

    Instead of applying destructive in-place alterations, I generated a zero-downtime migration path:

    Deprecated legacy_phone in Types: Marked legacy_phone?: string as @deprecated in src/types/user.ts rather than deleting it outright.
    2. Created Safe Migration File (migrations/20260902_safe_user_refactor.sql):

    -- Step 1: Add new ENUM type without breaking existing column
CREATE TYPE user_role_enum AS ENUM ('admin', 'member', 'guest');
ALTER TABLE users ADD COLUMN user_role_v2 user_role_enum DEFAULT 'member';

-- Step 2: Backfill data (Non-blocking)
UPDATE users SET user_role_v2 = user_role::user_role_enum WHERE user_role IS NOT NULL;

-- Note: legacy_phone removal scheduled for Phase 2 after API client deprecation period.

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

    What you get

    Prevent table locks on large production databases during index creation.Enforce backward compatibility for REST and GraphQL API response types.Automate the two-step deprecation process for database column renames.Catch missing default values on new non-nullable schema fields.

    About this skill

    Stop coding agents (Claude Code, Cursor, Codex CLI) from silently pushing breaking schema changes, invalidating frontend API contracts, or dropping live database columns.

    schema-guardrail-pro acts as an automated safety layer for database schema evolutions, TypeScript/Pydantic interface changes, and REST/GraphQL endpoint definitions. When an agent creates migrations or modifies model interfaces, this skill automatically enforces non-breaking rules, requires two-step deprecation workflows, and validates backward compatibility.

    Key Capabilities

    • Database Migration Protection: Catches in-place DROP COLUMN, DROP TABLE, or column-type narrowing actions before they run on live environments.
    • API Contract Verification: Ensures response and request fields maintain backward compatibility, enforcing @deprecated markers and fallback logic on interface changes.
    • Automated Validation Script: Runs a fast AST/regex check across changed SQL, Prisma, Alembic, or Drizzle files before finalizing pull requests.
    • Safe Alternative Recommendations: If a breaking change is detected, the skill automatically rewrites the execution path into a zero-downtime, multi-step migration strategy.

    Ideal For

    Backend engineers, full-stack developers, and LLM Ops teams building with automated coding agents who need guaranteed production uptime and backward compatibility.

    How to install

    Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.

    ~30 seconds
    1. 1

      Download the ZIP

      Free skills download straight away. Paid skills unlock right after purchase.

    2. 2

      Unzip into your skills folder

      Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.

    3. 3

      Ask your agent to use it

      Restart the agent if it was already running. It picks the skill up automatically - no config needed.

    Skills folder by agent

    Click the path to copy it. Create the folder if it does not exist yet.

    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 18 days ago

    • Passed all security checks, Safe to install

    Listed18 days ago

    What's inside

    Frequently Asked Questions