supabase-best-practices
Installation
Summary
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
SKILL.md
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