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

•

데이터베이스 관리

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.

주요 기능

Strict YYYYMMDDHHMMSS timestamp-based migration naming enforcement
1 GitHub stars
Comprehensive RLS policy templates featuring Super Admin bypass logic
Production-ready storage bucket provisioning and policy management
Automated idempotent SQL patterns for tables, columns, indexes, and constraints
Secure boilerplate for Postgres Security Definer functions with access controls

사용 사례

Adding new columns or tables to production Supabase environments without downtime
Implementing complex Row Level Security for multi-tenant applications
Provisioning and securing storage buckets for user-generated content and documents

소개

주요 기능

Strict YYYYMMDDHHMMSS timestamp-based migration naming enforcement
1 GitHub stars
Comprehensive RLS policy templates featuring Super Admin bypass logic
Production-ready storage bucket provisioning and policy management
Automated idempotent SQL patterns for tables, columns, indexes, and constraints
Secure boilerplate for Postgres Security Definer functions with access controls

사용 사례

Adding new columns or tables to production Supabase environments without downtime
Implementing complex Row Level Security for multi-tenant applications
Provisioning and securing storage buckets for user-generated content and documents