What is the recommended primary key strategy?

The skill enforces using UUIDs as primary keys with the built-in gen_random_uuid() function, avoiding older extensions or non-deterministic ID generation.

Does it support spatial data?

Yes, it includes specific patterns for PostGIS integration, including point columns, spatial indexing (GiST), and radius-based queries for location-aware applications.

How does this skill help with Supabase security?

It enforces mandatory Row Level Security (RLS) on all tables and prevents the dangerous exposure of service role keys in client-side code by providing clear safe-use patterns.

How are migrations organized within this skill?

Migrations are structured into specific sub-folders (tables, views, functions, triggers, policies, and indexes) using a timestamped naming convention to ensure predictable dependency ordering.

Can it help with TypeScript type safety?

Yes, the skill provides workflows for regenerating database types using MCP tools or CLI commands to ensure your frontend and backend stay in sync with schema changes.

Supabase Database Migrations

Name: Supabase Database Migrations
Author: nizarghribi

bynizarghribi

Gestión de Bases de Datos

Manages Supabase schema migrations, RLS policies, and PostGIS integration with security-first patterns.

Acerca de

This skill streamlines Supabase database management by enforcing rigorous standards for schema migrations, Row Level Security (RLS), and PostGIS features. It provides structured workflows for organizing migration files into logical directories, implementing secure access patterns, and maintaining audit trails with standardized UUIDs and timestamps. By integrating with MCP Supabase tools, it helps developers build scalable, production-ready backends while preventing common pitfalls like exposing service role keys or leaving tables unprotected by RLS.

Características Principales

Security-first RLS policy implementation and enforcement
PostGIS integration for location-based data and spatial queries
Standardized table structures with UUIDs and audit timestamps
Automated schema migration organization and naming conventions
Integrated security advisors and migration checklists
0 GitHub stars

Casos de Uso

Implementing complex multi-tenant RLS policies for data isolation
Scaling a Supabase backend with organized, timestamped migration files
Adding geospatial features using PostGIS and spatial indexing

Acerca de

Características Principales

Security-first RLS policy implementation and enforcement
PostGIS integration for location-based data and spatial queries
Standardized table structures with UUIDs and audit timestamps
Automated schema migration organization and naming conventions
Integrated security advisors and migration checklists
0 GitHub stars

Casos de Uso

Implementing complex multi-tenant RLS policies for data isolation
Scaling a Supabase backend with organized, timestamped migration files
Adding geospatial features using PostGIS and spatial indexing