Database Schema Migration Skill

What problem does it solve?

Manually managing Prisma schema changes, database migrations, and Supabase RLS policies is complex and error-prone, especially in a multi-tenant application. This skill automates the detection and execution of necessary operations, ensuring database integrity and workspace isolation.

Core Features & Use Cases

• Automated Schema Management: Handles Prisma schema modifications, validation, and database pushes.
• RLS Policy Generation & Update: Automatically creates and applies Row Level Security policies for new and existing models, ensuring multi-tenant isolation.
• Integrity Verification: Includes steps for TypeScript compilation, RLS policy testing, and general schema validation.
• Use Case: When adding a new field to an existing model, this skill guides you through updating the schema, pushing changes, and verifying RLS policies without manual database commands.

Quick Start

Update the Challenge model in prisma/schema.prisma to add a new description field. Then, use this skill to apply the schema changes and verify RLS policies.