Is this compatible with the standard Supabase CLI?

Yes, it is designed to work alongside 'supabase db reset' and 'supabase db push' workflows.

Does it handle Supabase security best practices?

Yes, it automatically includes RLS (Row Level Security) templates and ensures views use security_invoker and functions set an explicit search_path.

How do I create a new migration using this toolkit?

You can use the built-in helper scripts via 'uv run scripts/new_migration.py' followed by your migration description and type.

Can I validate my SQL migrations before deployment?

The skill includes a linting script (lint_migration.py) that checks your SQL files against the required naming and security conventions.

What naming conventions does this skill enforce?

The skill enforces specific prefixes like 'tb_' for tables and 'fn_' for functions, alongside type-specific suffixes like '_ts' for timestamps and '_uid' for UUIDs to ensure schema clarity.

Supabase Migration Toolkit

Name: Supabase Migration Toolkit
Author: ninyawee

byninyawee

Database Management

Manages Supabase database migrations using standardized naming conventions, automated linting, and security-first SQL templates.

About

The Supabase Migration Toolkit is a specialized capability for Claude Code designed to streamline the database lifecycle on the Supabase platform. It provides a robust framework for creating, validating, and managing PostgreSQL migrations through automated helper scripts and a strict set of naming conventions for tables, views, and functions. By enforcing object prefixes like 'tb_' and field suffixes like '_ts', the skill ensures long-term schema maintainability while baking in critical security patterns such as Row Level Security (RLS), security invokers for views, and versioned functions with explicit search paths.

Key Features

Automated migration file generation with timestamp-based naming
Decision tree guidance for table alterations, functions, and triggers
Version control for database functions to prevent breaking changes
SQL linting to enforce object prefix and field suffix conventions
0 GitHub stars
Security-first templates for RLS policies and security invoker views

Use Cases

Automating the creation of secure, production-ready migration scripts
Auditing database schemas for security vulnerabilities and convention compliance
Scaling Supabase projects with consistent database naming standards

About

Key Features

Automated migration file generation with timestamp-based naming
Decision tree guidance for table alterations, functions, and triggers
Version control for database functions to prevent breaking changes
SQL linting to enforce object prefix and field suffix conventions
0 GitHub stars
Security-first templates for RLS policies and security invoker views

Use Cases

Automating the creation of secure, production-ready migration scripts
Auditing database schemas for security vulnerabilities and convention compliance
Scaling Supabase projects with consistent database naming standards