supabase-best-practices

SKILL.md

40+ security and performance rules for Supabase projects with Clerk authentication integration.

Covers 10 rule categories prioritized by impact: Row Level Security and Clerk Integration (critical), Database Security and Authentication Patterns (high), plus Storage, Realtime, Edge Functions, and Testing

Each rule includes explanation, incorrect/correct code examples, exceptions, and official documentation links

Organized by use case: new project setup, RLS policy writing, schema design, real-time features, Storage bucket configuration, and code review

Emphasizes CRITICAL patterns like always enabling RLS, using Third-Party Auth integration over JWT templates, and validating JWT claims server-side

Supabase Best Practices

Comprehensive security and performance optimization guide for Supabase applications with Clerk authentication integration. Contains 40+ rules across 10 categories, prioritized by impact to guide secure development and code review.

When to Apply

Reference these guidelines when:

Setting up a new Supabase project

Integrating Clerk authentication with Supabase

Writing Row Level Security (RLS) policies

Designing database schemas

Implementing real-time features

Configuring Storage buckets

Writing Edge Functions

Reviewing code for security issues

Rule Categories by Priority