supabase-migrations

Automate Supabase migration creation, application, and versioning with MCP tools.

Updated Nov 21, 2025
One-click install
npx skills add https://github.com/ColdstartLabs-ca/myimageupscaler.com --skill supabase-migrations
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: supabase-migrations
Source: https://github.com/ColdstartLabs-ca/myimageupscaler.com/tree/main/.claude/skills/supabase-migrations
Command: npx skills add https://github.com/ColdstartLabs-ca/myimageupscaler.com --skill supabase-migrations

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Supabase migrations can be error-prone without a standardized workflow. This Skill provides a repeatable path to create, apply, and audit DDL changes and RLS updates using MCP tools, ensuring consistent schema evolution across environments.

Core Features & Use Cases

  • Apply DDL changes using mcp__supabase__apply_migration
  • Execute non-DDL SQL with mcp__supabase__execute_sql
  • List tables and migrations with mcp__supabase__list_tables and mcp__supabase__list_migrations
  • Validate security and performance with mcp__supabase__get_advisors
  • Enforce migration naming, post-migration checks, and TypeScript type generation

Quick Start

Create and apply a new migration named create_users_table to set up the users schema using MCP tools.

Frequently Asked Questions about supabase-migrations

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

FAQPage Schema
How do I automate Supabase migrations using MCP?

Supabase migrations apply DDL changes and RLS updates through MCP tooling. This workflow uses commands like apply_migration and execute_sql to manage schema changes, ensuring reproducible deployments and auditable histories across multiple environments.

What is the best way to manage RLS updates across multiple Supabase environments?

Managing RLS updates across environments requires a standardized migration workflow. Applying versioned migrations through MCP tools ensures consistent schema evolution and generates an auditable history for every security policy change.

Can I validate Postgres schema changes before applying them in Supabase?

You can validate schema changes by running the get_advisors MCP command after applying migrations. This performs post-migration security and performance checks on your Postgres database to catch potential issues early.

How do I list existing tables and migrations in a Supabase database?

You can list tables and migrations using the list_tables and list_migrations MCP commands. These tools query your Postgres schema to return existing database structures and track which migrations have already been applied.

Does this migration workflow enforce naming conventions and TypeScript type generation?

The workflow enforces migration naming conventions and includes TypeScript type generation. This ensures DDL changes remain structured and auditable while maintaining type safety across your multi-environment projects.