supabase-migration

Guide Supabase migration workflows with supabase migration new and CI/CD deployment.

45|3|Updated Jan 20, 2026

Search Tags:#security #database #migration #supabase #ci-cd #ddl

Ready to run

npx skills add https://github.com/YuDefine/nuxt-supabase-starter --skill supabase-migration-yudefine

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: supabase-migration
Source: https://github.com/YuDefine/nuxt-supabase-starter/tree/main/.claude/skills/supabase-migration
Command: npx skills add https://github.com/YuDefine/nuxt-supabase-starter --skill supabase-migration-yudefine

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Supabase Migration 規範。Use when running supabase migration new, editing migration SQL files, creating database functions, or modifying database schema. Always use this skill when you see CREATE FUNCTION, ALTER TABLE, CREATE INDEX, or migration-related work.

Core Features & Use Cases

Establishes MCP safety rules to prevent direct DDL execution via migration tooling.
Guides development workflows: create migrations with supabase migration new, apply via CI/CD, and lint migrations before deployment.
Provides schema and ownership guidelines, view security settings, and sequence synchronization to ensure predictable deployments.

Quick Start

Create a migration using supabase migration new, then deploy through your CI/CD pipeline to apply the changes in a controlled environment.

Frequently Asked Questions about supabase-migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I prevent unsafe direct DDL execution when modifying a Supabase database schema?▼

To prevent unsafe direct DDL execution, create migrations using the supabase migration new command and apply schema changes through a CI/CD pipeline for controlled deployments. This enforces safe, compliant Supabase migrations by standardizing procedures.

What is the best way to secure database functions during a Supabase migration?▼

The best way to secure database functions during a Supabase migration is to enforce search_path discipline and ensure views are securely defined. Proper object ownership must also be guarded to maintain predictable deployments and schema safety.

When do I need to use supabase migration new for database changes?▼

You need to use supabase migration new whenever you are creating database functions, modifying database schema, or performing operations like CREATE FUNCTION, ALTER TABLE, and CREATE INDEX to ensure changes are tracked and safely deployed.

Does Supabase migration tooling support linting database schema changes before CI/CD deployment?▼

Yes, Supabase migration tooling supports linting migrations before deployment. Linting checks schema and ownership guidelines, view security settings, and sequence synchronization to ensure predictable and safe CI/CD deployments.

Why should I enforce search_path discipline in Supabase database functions?▼

You should enforce search_path discipline in Supabase database functions to prevent security vulnerabilities and ensure predictable execution. This discipline is a core rule for maintaining secure, compliant migrations during local development and CI/CD deployments.