Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Freebies — Schema Migration Scaffold

    1

    Generate zero-downtime UP and DOWN database migration scripts for Flyway, Liquibase, Prisma, and Knex.

    Free

    Security scanned
    Freebies — Schema Migration Scaffold

    Freebies — Schema Migration Scaffold

    Example session with this skill installed

    Generate a zero-downtime PostgreSQL migration to add an index on the email column of the users table and a down script to revert it for Knex.

    • Read your context and instructions
    • Compiled the freebies

    I have generated the migration scripts using zero-downtime practices for PostgreSQL. The UP block uses CONCURRENTLY to avoid table locks, and the DOWN block provides a clean rollback.

    Knex Migration: add_index_to_users_email

    // Migration: add_index_to_users_email.js
    
    exports.up = async function(knex) {
      // PostgreSQL requires CONCURRENTLY to be run outside of a transaction block
      // This script assumes the migration runner handles transaction isolation settings
      await knex.raw('CREATE INDEX CONCURRENTLY IF NOT EXISTS users_email_index ON users (email)');
    };
    
    exports.down = async function(knex) {
      // Reverting the index creation
      await knex.raw('DROP INDEX CONCURRENTLY IF EXISTS users_email_index');
    };
    

    Next steps

    1. Ensure your migration runner (Knex) is configured to disable transactions for this specific file, as CREATE INDEX CONCURRENTLY cannot run inside a transaction.
    2. Verify the index creation by running EXPLAIN on a query targeting the email column in your development environment.
    3. Review references/technical-guide.md for specific PostgreSQL 12+ optimization flags.

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

    About this skill

    Stop crashing production with table-locking migrations. This skill generates zero-downtime database migration scripts designed for high-availability environments where schema changes cannot interrupt service.

    What it does

    • Reversible scripts generates paired UP and DOWN blocks for every schema change to ensure safe rollbacks.
    • Lock avoidance implements non-blocking operations like CREATE INDEX CONCURRENTLY in PostgreSQL to prevent performance degradation.
    • Evolution strategy scaffolds migrations that add columns as nullable first, maintaining compatibility with active application instances.
    • Constraint management handles foreign keys and constraints without triggering full table rewrites or long-held locks.

    How it works

    1. Define your target database engine and the specific schema change required.
    2. The agent analyzes the impact of the change on existing table locks and data integrity.
    3. It generates an UP script following zero-downtime best practices for your specific framework.
    4. It provides a corresponding DOWN script to revert the changes exactly.

    Frameworks & tools

    Supports SQL-based migration tools including Flyway, Liquibase, Prisma, and Knex. Compatible with PostgreSQL, MySQL, and other standard relational engines.

    Why this beats prompting it yourself

    Generic prompts often ignore the operational reality of large datasets, leading to scripts that lock tables for minutes. This skill strictly enforces the "Zero-Downtime" architectural pattern, ensuring every generated script is safe for CI/CD deployment on production traffic.

    Use cases

    • Adding indexes to multi-million row tables without blocking writes.
    • Renaming or adding columns during a rolling deployment.
    • Modifying constraints while maintaining backwards compatibility.
    • Generating boilerplate for Liquibase or Flyway XML/SQL migrations.

    Known limitations

    Does not perform live execution or database connectivity. All scripts are generated as static files restricted to the current workspace and require manual validation against specific engine versions.

    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.

    Restricted to workspace file generation. Does not execute migrations or connect to live DBs. Requires manual validation for specific engine version quirks.

    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

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    • Free with an Agensi account

    Software
    Zero global installation
    orelevated privileges required.

    File System Read/Write (strictly scoped to current project workspace `./`).

    Permissions

    Read Files
    Write Files

    Target Use Cases: - Create a zero-downtime database migration script. - Write UP and DOWN migration for adding an index concurrently. - Generate safe PostgreSQL migration script for large tables.

    Listed2 days ago

    What's inside

    Frequently Asked Questions

    This skill automates the creation of 'Zero-Downtime' database migrations, specifically preventing long-held table locks that crash production during schema updates. It ensures every change is backward-compatible with active application instances, allowing you to deploy migrations while traffic is live.

    The skill supports Flyway, Liquibase, Prisma, and Knex, covering both raw SQL and framework-specific DSLs. It is compatible with major relational engines, including PostgreSQL and MySQL, with specific optimizations like 'CONCURRENTLY' for Postgres indexes.

    No complex installation is required; simply add the skill to your AI agent's workspace and provide your target framework and schema requirements. The agent will then generate the migration files directly within your project environment for review.

    You receive the core logic for generating safe migration scaffolds, including paired UP and DOWN scripts and best-practice templates for high-availability environments. The purchase also includes access to any future logic updates or additional framework support added to the skill.

    The skill generates static script files and does not require a direct connection to your live database, maintaining a secure 'air-gap' between the AI and your production data. You are responsible for executing the generated scripts through your existing CI/CD or migration toolset.

    New in Data & Databases

    Free