skills.rest
BaraArdiwinata
BaraArdiwinataCOMMUNITY
Explore all skills by this author →
GitHub

create-migration

Automates PostgreSQL migration scripts for Supabase with audit columns and RLS.

1|Updated May 26, 2026
Search Tags:#database migration#database management#PostgreSQL#Supabase#RLS
One-click install
npx skills add https://github.com/BaraArdiwinata/hackathon-sima-arome --skill create-migration-baraardiwinata
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: create-migration
Source: https://github.com/BaraArdiwinata/hackathon-sima-arome/tree/main/.agents/skills/create-migration
Command: npx skills add https://github.com/BaraArdiwinata/hackathon-sima-arome --skill create-migration-baraardiwinata

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the generation of Supabase PostgreSQL database migrations, ensuring proper schema, RLS policies, indexes, triggers, and grants, thus saving time and reducing errors in database management.

Core Features & Use Cases

  • Migration Generation: Automatically creates migrations for table creation, schema changes, and column additions.
  • Schema Management: Ensures standard naming conventions and inclusion of audit columns.
  • Security and Compliance: Implements Row Level Security policies and grants appropriate permissions.
  • Use Case: When needing to add a new table with RLS policies and indexes to your Supabase database, this Skill can generate the necessary migration file.

Quick Start

Use the create-migration skill to generate a migration for adding a new user profile table with RLS and indexes.

Frequently Asked Questions about create-migration

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

FAQPage Schema
How do I automate Supabase PostgreSQL database migration generation?▼

Automating Supabase PostgreSQL database migration generation involves creating scripts for schema changes, RLS policies, indexes, triggers, and grants using standard naming conventions to reduce manual errors.

How do I add Row Level Security policies to a new Supabase table?▼

Adding Row Level Security policies to a new Supabase table requires generating a database migration script that defines the schema and includes the necessary RLS policy grants for security compliance.

Does Supabase database migration support standard audit columns and naming conventions?▼

Supabase database migration can enforce standard naming conventions and include standard audit columns automatically, ensuring consistent schema management across table creation and column additions.

What is the best way to manage PostgreSQL schema changes in Supabase?▼

Managing PostgreSQL schema changes in Supabase is best handled by generating automated migration scripts that bundle table modifications, triggers, and indexes together to maintain database integrity.

Can I generate database triggers and indexes together when creating a Supabase table?▼

Generating database triggers and indexes together when creating a Supabase table is possible through a comprehensive migration script that applies DaaS conventions alongside schema and permission grants.

What are the limitations of manual PostgreSQL database migration for Supabase?▼

Manual PostgreSQL database migration for Supabase often leads to naming convention inconsistencies and missing RLS policies, making automated script generation necessary for reliable database management.

Related Skills

Explore More Software Engineering Skills→
wangzitian0wangzitian0

schema

Define PostgreSQL database schemas with table structures, relationships, and migration rules.

Community
Intermediate
titabashtitabash

supabase-migration

Manage Supabase PostgreSQL schema migrations with Drizzle ORM and TypeScript.

Community
Advanced
ionmidoriionmidori

type-safe-backend-patterns

Implement type-safe backend architectures with Supabase and Drizzle ORM.

Community
Intermediate
jtucker9jtucker9

memstack-development-database-architect

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

Community
Advanced