supabase-migration

Manage Supabase database migrations, RLS policies, and PostGIS geometry.

39|15|Updated Nov 16, 2024
One-click install
npx skills add https://github.com/Klimabevaegelsen/landbruget.dk --skill supabase-migration-klimabevaegelsen
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: supabase-migration
Source: https://github.com/Klimabevaegelsen/landbruget.dk/tree/main/.claude/skills/supabase-migration
Command: npx skills add https://github.com/Klimabevaegelsen/landbruget.dk --skill supabase-migration-klimabevaegelsen

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides guidance for database migrations and schema management in Landbruget.dk, helping teams implement changes safely and reproducibly.

Core Features & Use Cases

  • Creating and applying migrations with Supabase
  • Defining and enforcing RLS policies
  • Working with PostGIS geometry and spatial indexes
  • Managing materialized views and TypeScript type generation
  • Providing templates and best practices for migrations, rollback strategies, and environment setup

Quick Start

Run the migration workflow to apply the latest schema changes to your Supabase project.

Frequently Asked Questions about supabase-migration

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

FAQPage Schema
How do I apply database migrations to a Supabase project?

To apply database migrations to a Supabase project, you can run the migration workflow to implement the latest schema changes safely and reproducibly across environments.

What is the best way to configure RLS policies in Supabase?

The best way to configure RLS policies in Supabase is by using established migration templates that define and enforce row-level security patterns safely across your database environments.

Can I manage PostGIS geometry and spatial indexes with Supabase migrations?

Yes, you can manage PostGIS geometry and spatial indexes by including the specific schema adjustments and spatial indexing configurations directly within your Supabase migration files.

Does Supabase support TypeScript type generation for database schema changes?

Yes, Supabase supports TypeScript type generation for database schema changes, allowing you to manage materialized views and automatically generate corresponding types during the migration process.

What are the limitations of manual schema changes versus using Supabase migrations?

Manual schema changes lack reproducibility and rollback strategies, whereas using structured Supabase migrations provides safe templates, environment setup consistency, and reliable rollback procedures.