create-migration

Generate Supabase PostgreSQL migration files with schema, RLS, indexes, triggers, and grants.

Updated Jun 12, 2026

Search Tags:#database migration #schema management #PostgreSQL #Supabase #RLS policies

Ready to run

npx skills add https://github.com/Alif-N/fe-sima-arome --skill create-migration-alif-n

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: create-migration
Source: https://github.com/Alif-N/fe-sima-arome/tree/main/.agents/skills/create-migration
Command: npx skills add https://github.com/Alif-N/fe-sima-arome --skill create-migration-alif-n

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires supabase-cli, and includes scripts (resource) components.

What problem does it solve?

This Skill automates the generation of database migrations for Supabase PostgreSQL, ensuring proper schema, RLS policies, indexes, triggers, and grants are included, while adhering to DaaS naming conventions and audit columns.

Core Features & Use Cases

Automated Migration Creation: Generates a migration file with schema, RLS policies, indexes, triggers, and grants.
Schema Conventions: Follows DaaS naming conventions for tables, columns, and keys.
Use Case: When a user needs to create a new table, modify an existing schema, or add columns to a collection, this Skill can be used to generate the necessary migration file.

Quick Start

Generate a new migration to add a 'users' table with 'email' and 'password' fields.

Frequently Asked Questions about create-migration

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

FAQPage Schema

How do I automate database migration creation for Supabase PostgreSQL?▼

You can automate database migration creation for Supabase PostgreSQL by generating a single migration file that includes schema definitions, row-level security policies, indexes, triggers, and grants. This ensures schema integrity and performance optimizations while adhering to DaaS naming conventions.

What is the best way to add row-level security policies to a new Supabase table?▼

The best way to add row-level security policies is by generating a comprehensive database migration file that automatically includes RLS policies alongside your table schema, indexes, and grants, ensuring secure data access from the start.

Do I need the Supabase CLI to create database migrations with automated schema conventions?▼

Yes, you need the Supabase CLI installed as a dependency to create database migrations. The CLI provides the necessary environment to generate migration files containing schema changes, RLS policies, and audit columns for your PostgreSQL database.

Can I modify an existing Supabase schema by adding columns to a collection automatically?▼

Yes, you can modify an existing Supabase schema by generating a migration file to add new columns or tables to a collection. This process ensures your schema changes include proper audit columns, triggers, and DaaS naming conventions.

Why should I include triggers and grants in my PostgreSQL database migration?▼

Including triggers and grants in your PostgreSQL database migration ensures that schema integrity, performance optimizations, and proper access controls are applied consistently. Automating these elements prevents manual errors and maintains DaaS naming conventions across your database.