skills.rest
freedomw1987
freedomw1987COMMUNITY
Explore all skills by this author →
𝕏@davidaasmGitHub

prisma-migrate-private-rds

Runs pending Prisma migrations on private RDS via one-off ECS tasks.

2|Updated May 10, 2026
Search Tags:#devops#aws#ecs#prisma#rds#database-migration#schema-drift
One-click install
npx skills add https://github.com/freedomw1987/tree_monstor --skill prisma-migrate-private-rds
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-migrate-private-rds
Source: https://github.com/freedomw1987/tree_monstor/tree/main/skills/prisma-migrate-private-rds
Command: npx skills add https://github.com/freedomw1987/tree_monstor --skill prisma-migrate-private-rds

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

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.

Frequently Asked Questions about prisma-migrate-private-rds

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
Why does Prisma migrate deploy fail in CodeBuild for a private RDS instance?▼

Prisma migrate deploy fails in CodeBuild because CodeBuild lacks VPC access and cannot reach private RDS instances. Running the migration via a one-off ECS task within the backend service's VPC bypasses this network restriction.

How do I run Prisma migrations on a private RDS instance using ECS?▼

To run Prisma migrations on a private RDS instance, launch a one-off ECS task in the same VPC as your backend service. This task executes the migration scripts, ensuring network connectivity to the database.

How do I fix Prisma schema drift for enum and TEXT-to-enum column changes in PostgreSQL?▼

Fix Prisma schema drift for enum-to-table migrations and TEXT-to-enum changes using manual migration recipes. These recipes handle structural schema changes that standard Prisma migration workflows often fail to process correctly.

How can I prevent PascalCase identifier drift in Prisma PostgreSQL migration files?▼

Prevent PascalCase identifier drift in PostgreSQL migration SQL by running a pre-commit lint script. This script catches case-sensitive identifier errors before deployment, avoiding silent production database drift.

Can I use this ECS run-task migration workflow with a Node.js or Bun backend?▼

Yes, this ECS run-task migration workflow applies to AWS ECS deployments using Prisma ORM with either Node.js or Bun backends, ensuring reliable database schema updates within private subnets.

Related Skills

Explore More Software Engineering Skills→
Awannaphasch2016Awannaphasch2016

infrastructure-verification

Validate AWS VPC endpoints, NAT gateways, security groups, and network paths before deployment.

Community
Advanced
bobmatnycbobmatnyc
68

drizzle-migrations

Create and test SQL migrations for Drizzle ORM projects.

Community
Advanced
imkdwimkdw
1

Backend Migrations

Automate Prisma migrations for PostgreSQL schema changes.

Community
Intermediate
agents-infrastructureagents-infrastructure
7

alicloud-vpc

Manage Alibaba Cloud VPCs, VSwitches, route tables, and NAT gateways.

Official
Advanced