How does it handle Supabase security best practices?

It automatically includes templates for Row Level Security (RLS) and ensures that views are created with 'security_invoker' and functions have a restricted 'search_path' for enhanced security.

What tools are needed to run the helper scripts?

The helper scripts for creating and linting migrations are designed to run with 'uv', requiring no manual installation of dependencies.

What naming conventions does this skill enforce?

The skill requires specific prefixes for all objects (e.g., 'tb_' for tables, 'fn_' for functions) and suffixes for data types (e.g., '_ts' for timestamps, '_bool' for booleans) to ensure a clean, searchable schema.

Can I use this for existing Supabase projects?

Yes, while best for new projects, you can use the linting and generation scripts to bring existing schemas into alignment with the toolkit's standardized naming patterns.

Supabase Migration Toolkit

Name: Supabase Migration Toolkit
Author: ninyawee

byninyawee

データベース管理

Streamlines and enforces strict naming conventions and security best practices for Supabase database migrations.

概要

The Supabase Migration Toolkit is a specialized Claude Code skill designed to automate the creation and management of PostgreSQL schemas within the Supabase ecosystem. It enforces a rigorous architectural standard using mandatory object prefixes and field suffixes, ensuring consistency across large-scale projects. The skill provides pre-configured templates for Row Level Security (RLS), versioned functions, and secure views, while utilizing helper scripts to lint and validate migration files against established conventions before deployment.

主な機能

Strict naming conventions for tables, views, indexes, and constraints
Validation scripts to lint SQL migrations against project rules
Automated migration file generation with standardized timestamping
Security-first templates for RLS policies and security_invoker views
Version control support for database functions and schema extensions
0 GitHub stars

ユースケース

Maintaining schema consistency in multi-tenant SaaS environments
Establishing a professional database architecture for new Supabase projects
Automating the creation of secure, RLS-enabled database tables and views

概要

主な機能

Strict naming conventions for tables, views, indexes, and constraints
Validation scripts to lint SQL migrations against project rules
Automated migration file generation with standardized timestamping
Security-first templates for RLS policies and security_invoker views
Version control support for database functions and schema extensions
0 GitHub stars

ユースケース

Maintaining schema consistency in multi-tenant SaaS environments
Establishing a professional database architecture for new Supabase projects
Automating the creation of secure, RLS-enabled database tables and views