How does this skill handle existing database structures?

It generates idempotent SQL commands, such as 'IF NOT EXISTS' for columns and 'DROP POLICY IF EXISTS' for security rules, ensuring migrations can be re-run safely without errors.

Does it support Supabase Storage management?

Yes, it includes specialized templates for creating storage buckets and defining path-based access policies for users and admins.

Where are the migrations stored by default?

Migrations are automatically directed to the 'apps/web/supabase/migrations/' directory, following the standard project structure for Ballee-based applications.

What is the mandatory naming convention?

The skill enforces a YYYYMMDDHHMMSS_descriptive_name.sql format and strictly forbids version suffixes like '_v2' or '_new' to ensure a clean, chronological history.

Does it help with database security best practices?

Absolutely. It defaults to revoking public permissions, enabling RLS on all new tables, and provides secure patterns for Security Definer functions that prevent SQL injection.

Database Migration Manager

Name: Database Migration Manager
Author: antoineschaller

byantoineschaller

•

Gestión de Bases de Datos

Generates production-ready Supabase migrations with idempotent SQL, strict naming conventions, and advanced RLS security patterns.

The Database Migration Manager skill automates the creation of professional-grade Supabase migrations, ensuring every schema change follows industry best practices for reliability and security. It enforces a strict timestamp-based naming convention, prohibits fragile version suffixes, and generates idempotent SQL to ensure migrations can be safely re-run across different environments. With specialized support for Row Level Security (RLS), storage bucket policies, and 'super admin' bypass patterns, it enables developers to build robust, multi-tenant database architectures while maintaining consistent auditability and type safety.

Características Principales

01Strict YYYYMMDDHHMMSS timestamp-based migration naming enforcement

021 GitHub stars

03Comprehensive RLS policy templates featuring Super Admin bypass logic

04Production-ready storage bucket provisioning and policy management

05Automated idempotent SQL patterns for tables, columns, indexes, and constraints

06Secure boilerplate for Postgres Security Definer functions with access controls

Casos de Uso

01Adding new columns or tables to production Supabase environments without downtime

02Implementing complex Row Level Security for multi-tenant applications

03Provisioning and securing storage buckets for user-generated content and documents

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add antoineschaller/cortex-skills database-migration-manager

For use in Claude.ai and ChatGPT

Download Skill