prisma-migrate-private-rds

Community

Run private RDS Prisma migrations via ECS one-off tasks

Authorfreedomw1987
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill fixes Prisma migration failures that occur when CodeBuild (which has no VPC access) cannot reach a private RDS instance, causing prisma migrate deploy to fail during CI/CD pipelines.

Core Features & Use Cases

  • ECS-based Migration Execution: Runs Prisma migrations via one-off ECS tasks in the same VPC as your backend service, bypassing CodeBuild's network restrictions.
  • Schema Drift Recovery: Includes proven recipes for handling edge cases like enum-to-table migrations, TEXT-to-enum column changes, and stale migration files that cause silent production failures.
  • Prevention Guardrails: Provides a pre-commit lint script to catch PascalCase identifier drift in migration SQL, avoiding common PostgreSQL case-sensitive deployment errors. Use cases include AWS ECS deployments with private RDS, teams using Prisma ORM with Bun/Node.js backends, and CI/CD pipelines that need reliable, repeatable database migration steps.

Quick Start

Use this skill to run all pending Prisma migrations on your private RDS instance by launching a one-off ECS task in your backend service's VPC.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: prisma-migrate-private-rds
Download link: https://github.com/freedomw1987/tree_monstor/archive/main.zip#prisma-migrate-private-rds

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 537,000+ vetted skills library on demand.