migration-patterns

Enforce Row Level Security policies and architectural approval for database schema migrations.

Updated Jul 31, 2026
One-click install
npx skills add https://github.com/vikas-gits-good/Test-SAW-Repo --skill migration-patterns-vikas-gits-good
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: migration-patterns
Source: https://github.com/vikas-gits-good/Test-SAW-Repo/tree/main/.gemini/skills/migration-patterns
Command: npx skills add https://github.com/vikas-gits-good/Test-SAW-Repo --skill migration-patterns-vikas-gits-good

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill prevents security vulnerabilities and schema inconsistencies by enforcing mandatory Row Level Security (RLS) and a structured architectural approval workflow for all database changes.

Core Features & Use Cases

  • Security Enforcement: Automatically mandates RLS policies for every new table creation.
  • Approval Workflow: Integrates an ARCHitect approval gate to ensure schema changes are vetted before implementation.
  • Use Case: When adding a new user-facing feature that requires a database table, this skill guides you through creating the table, applying the necessary RLS policies, and documenting the change in the data dictionary.

Quick Start

Use the migration-patterns skill to generate a new database migration that includes mandatory RLS policies and the required user index.

Frequently Asked Questions about migration-patterns

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

FAQPage Schema
How do I enforce Row Level Security when creating new database tables?

To enforce Row Level Security (RLS) during database migrations, you need a workflow that mandates RLS policy implementation for all schema modifications. This skill enforces strict RLS policies and architectural approval for table creation and permission management.

What is the best way to secure Prisma schema updates in production?

The best way to secure Prisma schema updates is to enforce a structured architectural approval workflow and mandate Row Level Security. This skill integrates an architect approval gate to ensure all schema changes are vetted before implementation in production environments.

How do I add an architectural approval gate to database migrations?

To add an architectural approval gate to database migrations, integrate a vetting step before schema implementation. This skill enforces a structured approval workflow requiring architect sign-off for all schema modifications, including Prisma updates and permission management.

Does Prisma support automatic Row Level Security policy generation?

Prisma schema updates can be secured with automatic Row Level Security policy generation. This skill mandates RLS policies for every new table creation, applying security-first architecture to generate necessary user indexes and RLS policies during the migration process.

Why do I need architect approval for schema modifications?

Architect approval for schema modifications is needed to prevent security vulnerabilities and schema inconsistencies. This skill integrates an approval gate to ensure all database changes, including table creation and permission management, are vetted before implementation.

What is included in a security-first database migration workflow?

A security-first database migration workflow includes mandatory Row Level Security policies, an architectural approval gate, and data dictionary updates. This skill guides you through creating tables, applying RLS policies, and documenting changes for production environments.