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

0•

数据库管理

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.

主要功能

01Strict naming conventions for tables, views, indexes, and constraints

02Validation scripts to lint SQL migrations against project rules

03Automated migration file generation with standardized timestamping

04Security-first templates for RLS policies and security_invoker views

05Version control support for database functions and schema extensions

060 GitHub stars

使用场景

01Maintaining schema consistency in multi-tenant SaaS environments

02Establishing a professional database architecture for new Supabase projects

03Automating the creation of secure, RLS-enabled database tables and views

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ninyawee/armed-claude supabase-migration

For use in Claude.ai and ChatGPT

Download Skill