What database patterns are included?

It provides patterns for multi-tenant table design, automatic updated_at triggers, and relational profiles linked directly to auth.users.

Can I use this for local development?

Absolutely, the skill includes guidance for using the Supabase CLI, including local setup, database resets, and migration management.

How are Edge Functions structured?

It generates standard TypeScript/Deno structures including CORS headers, authentication verification, and examples for calling external APIs like Google Gemini.

Does this skill handle Row Level Security?

Yes, it provides detailed templates for enabling RLS and creating specific policies for select, insert, update, and delete operations based on user authentication.

Does it support Apple Sign-In?

Yes, it provides specific configuration steps for both the Supabase dashboard and local config files to enable Apple authentication for mobile and web apps.

Supabase Setup & Management

Name: Supabase Setup & Management
Author: bgrober

bybgrober

•

Database Management

Configures and secures Supabase backends including database schemas, RLS policies, authentication providers, and Edge Functions.

About

This skill provides a comprehensive framework for building and maintaining Supabase applications with a focus on security and best practices. It streamlines the creation of database tables, implementation of Row Level Security (RLS), and configuration of authentication providers like Apple Sign-In. Additionally, it guides developers through writing TypeScript Edge Functions, managing storage buckets, and establishing robust migration workflows to ensure smooth transitions between local development and production environments.

Key Features

Standardized database schema patterns with automatic timestamp triggers
Production-ready TypeScript Edge Function templates with CORS and auth
Comprehensive migration workflow management for local and remote environments
1 GitHub stars
Granular Row Level Security (RLS) policy generation for data privacy
Automated profile creation triggers for user authentication flows

Use Cases

Bootstrapping a new project with a secure, multi-tenant Supabase backend
Configuring Apple Sign-In and session handling for iOS applications
Developing AI-powered Edge Functions using Gemini or other external APIs

About

Key Features

Standardized database schema patterns with automatic timestamp triggers
Production-ready TypeScript Edge Function templates with CORS and auth
Comprehensive migration workflow management for local and remote environments
1 GitHub stars
Granular Row Level Security (RLS) policy generation for data privacy
Automated profile creation triggers for user authentication flows

Use Cases

Bootstrapping a new project with a secure, multi-tenant Supabase backend
Configuring Apple Sign-In and session handling for iOS applications
Developing AI-powered Edge Functions using Gemini or other external APIs