skills.rest
amo-tech-ai
amo-tech-aiCOMMUNITY
Explore all skills by this author โ†’
GitHub

database-migration

Create and modify database schemas with enforced RLS policies.

Updated Jan 15, 2026
Search Tags:#SQL#database#schema#migration#supabase#RLS
One-click install
npx skills add https://github.com/amo-tech-ai/rocket-path-ai --skill database-migration-amo-tech-ai
Or copy as Structured Prompt for Agentโ–ผ
Please help me install this Agent Skill.
Skill: database-migration
Source: https://github.com/amo-tech-ai/rocket-path-ai/tree/main/.claude/database-migration
Command: npx skills add https://github.com/amo-tech-ai/rocket-path-ai --skill database-migration-amo-tech-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

๐Ÿ’ก This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a structured and safe workflow for managing database schema changes, ensuring data integrity and security through mandatory Row Level Security (RLS) policies.

Core Features & Use Cases

  • Schema Creation: Define and create new database tables.
  • Schema Modification: Add or alter columns in existing tables.
  • RLS Policy Enforcement: Write and apply Row Level Security policies to control data access.
  • Function Creation: Develop database functions and triggers.
  • Data Seeding: Populate tables with initial or reference data.
  • Use Case: When adding a new products table, this Skill guides you through defining columns, setting up RLS policies for user access, and creating necessary indexes, all while adhering to SQL style best practices.

Quick Start

Use the database-migration skill to create a new table named 'users' with columns for id, email, and created_at.

Frequently Asked Questions about database-migration

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

FAQPage Schema
How do I safely manage database schema changes and add RLS policies in Supabase?โ–ผ

To manage database schema changes safely, you need a structured workflow that enforces strict SQL style guidelines and mandates Row Level Security (RLS) policies for all user-facing tables to ensure data integrity and access control.

What is the best way to create a new SQL table and apply Row Level Security policies?โ–ผ

The best way to create a new SQL table with Row Level Security is to follow a guided process that defines columns, creates necessary indexes, and applies RLS policies to control user data access while adhering to SQL style best practices.

Can I use this workflow to alter existing database columns and create functions?โ–ผ

Yes, you can modify existing schemas by adding or altering columns, developing database functions and triggers, and populating tables with reference data through structured seeding operations.

When do I need to apply RLS policies to my database tables?โ–ผ

You need to apply RLS policies to your database tables whenever they are user-facing, as strict Row Level Security enforcement is mandatory to control data access and maintain security across your database schema.

Does this database migration approach support data seeding for initial table records?โ–ผ

Yes, this database migration approach supports data seeding operations, allowing you to populate database tables with initial or reference data during the schema creation and modification process.

Related Skills

Explore More Software Engineering Skillsโ†’
jtucker9jtucker9

memstack-development-database-architect

Design PostgreSQL/Supabase schemas with RLS policies and migration SQL.

Community
Advanced
titabashtitabash

supabase-migration

Manage Supabase PostgreSQL schema migrations with Drizzle ORM and TypeScript.

Community
Advanced
SomtechSolutionMAximeSomtechSolutionMAxime

audit-rls

Audit PostgreSQL tables for missing or misconfigured Row-Level Security policies.

Community
Advanced
semicolon-devteamsemicolon-devteam

supabase

Create and validate Supabase database schemas, RLS policies, and migrations.

Official
Advanced