supabase-development

mindrally

•

6155 months ago

Source Raw

Supabase development guidelines for database, authentication, real-time subscriptions, and Edge Functions.

Quick Install

npxskills add mindrally/skills--skill supabase-development

Instructions

Supabase Development

You are an expert in Supabase development including database design, authentication, real-time features, and Edge Functions.

Core Principles

Use Supabase client for all database interactions
Implement Row Level Security (RLS) policies for data protection
Leverage Supabase Auth for user management
Use real-time subscriptions for live updates

Database Design

Schema Best Practices

Use proper PostgreSQL types and constraints
Implement foreign key relationships
Create indexes for frequently queried columns
Use views for complex queries
Implement soft deletes where appropriate

Row Level Security

Always enable RLS on tables with user data
Write policies for SELECT, INSERT, UPDATE, DELETE
Test policies thoroughly before deployment
Use service role only for admin operations

Authentication

Implement OAuth providers (Google, GitHub, etc.)
Handle auth state changes reactively
Use auth helpers for framework integration
Implement proper session management
Handle password reset and email verification

Real-Time Features

Use subscriptions for live data updates
Implement presence for user online status
Handle connection state changes
Optimize subscription filters for performance

Edge Functions

Write functions in TypeScript/Deno
Handle CORS properly
Implement proper error responses
Use environment variables for secrets
Test locally before deployment

Storage

Organize files in buckets by purpose
Implement proper access policies
Use signed URLs for private files
Handle file uploads with proper validation

Integration Patterns

Next.js

Use @supabase/ssr for server-side auth
Implement middleware for protected routes
Handle auth in Server Components

SvelteKit

Use @supabase/auth-helpers-sveltekit
Implement hooks for auth handling
Use load functions for data fetching

Performance

Use connection pooling for high traffic
Implement caching strategies
Optimize queries with proper indexes
Use pagination for large datasets

Loading…

Related Skills

skill-creator

Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.

367,360

skill-creator

Create or update AgentSkills. Use when designing, structuring, or packaging skills with scripts, references, and assets.

367,309

1password

Set up and use 1Password CLI (op). Use when installing the CLI, enabling desktop app integration, signing in (single or multi-account), or reading/injecting/running secrets via op.

365,915

himalaya

CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).

365,885