supabase-migration

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

39|15|Updated Nov 16, 2024

Search Tags:#typescript #database #migrations #rls #schema #supabase #postgis

Ready to run

npx skills add https://github.com/Klimabevaegelsen/landbruget.dk --skill supabase-migration-klimabevaegelsen

💬 Prompt for ChatGPT / Claude Chat▼

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.