umac-ai-ecs-migration

What problem does it solve?

This Skill solves the issue of being unable to run Prisma migrations against a production RDS instance directly from local development machines due to security group or VPC restrictions, which blocks standard local migration workflows.

Core Features & Use Cases

• ECS Fargate One-off Task Execution: Uses the existing UMAC AI backend task definition to run a temporary Fargate container for migration, eliminating the need to set up new infrastructure.
• Secure Credential Management: Retrieves database connection strings from AWS Secrets Manager, avoiding hardcoded credentials or exposing the production database to external access.
• Pre-defined Production Configuration: Includes exact, pre-validated parameters for the UMAC AI production stack (cluster, subnets, security groups, region) to eliminate configuration errors.
• Use Case: When deploying a new version of the UMAC AI backend that requires a database schema update, use this Skill to run the required Prisma migration directly against the production RDS without compromising network security.

Quick Start

Use this skill to execute the required Prisma migration against the UMAC AI production RDS via an ECS Fargate task when local database access is unavailable.