migration-patterns

Embed RLS policies directly within migration scripts alongside schema changes. This Skill guides you through creating migrations with Prisma that include policy definitions, ensuring security policies and schema updates deploy together in a single transaction.

Database migrations carry compliance and security risks. This Skill enforces ARCHitect approval workflow before migration execution, catching non-compliant changes and ensuring governance requirements are met before deployment.

Yes. This Skill shows how to generate Prisma migrations and embed RLS policy statements, GRANT commands, and security indexes within the same migration file so policies activate when schema changes apply.

You need Prisma configured for your database, understanding of RLS concepts, and access to ARCHitect approval systems. This Skill provides a migration checklist covering environment setup, schema prerequisites, and role/policy planning.

This Skill includes migration checklists and schema impact analysis steps that document RLS policies, privilege grants, and security controls applied during migration, creating an audit trail for compliance teams.