Agent skill · software engineering · erichowens
supabase-admin
Supabase administration, RLS policies, migrations, and schema design. Use for database architecture, Row Level Security, performance tuning, auth integration. Activate on "Supabase", "RLS",
Why this skill is useful
Adds specific Row Level Security patterns and migration best practices for Supabase that the AI wouldn't reliably generate on its own.
What it needs
Requires supabase account access. About 4k tokens when loaded. Last updated 2026-07-14. 180 stars on the source repository.
What this skill does
Supabase Administration Expert Master Supabase schema design, Row Level Security policies, migrations, and performance optimization for production applications. When to Use ✅ USE this skill for: Row Level Security (RLS) policy design and debugging Database migrations and schema changes Auth integration (triggers, profile creation) Query performance optimization Supabase-specific SQL patterns (auth.uid(), auth.jwt()) ❌ DO NOT use for: Supabase Auth UI configuration → use Supabase dashboard docs Edge Functions → use cloudflare-worker-dev skill General PostgreSQL without Supabase context → use standard SQL resources Client-side Supabase SDK usage → use Supabase JS docs Core Competencies 1. Row Level Security (RLS) Always Enable RLS on User Tables: Policy Patterns: Performance-Critical: Index auth.uid() Columns: Subquery Optimization for JWT Functions: 2. Migration Best Practices File Naming Convention: Migration Template: Safe Migration Patterns: 3. Auth Integration Auto-create Profile on Signup: Check Auth Status in Policies: 4. Common Schema Patterns Timestamps with Defaults: Soft Delete Pattern: Full-Text Search: 5. Debugging RLS Issues Common Problem: Empty Results, No Error Diagnostic Query: Quick Reference Task Command ------ --------- Enable RLS ALTER TABLE t ENABLE ROW LEVEL SECURITY; Create policy CREATE POLICY "name" ON t FOR action USING (condition); Drop policy DROP POLICY "name" ON t; Check policies SELECT FROM pgpolicies WHERE tablename = 't'; Current user SELECT auth.uid(); Force RLS for owner ALTER TABLE t FORCE ROW LEVEL SECURITY; References See /references/ for detailed guides: rls-patterns.md - Advanced RLS policy patterns migration-checklist.md - Pre-deployment checklist performance-tuning.md - Query and index optimization social-schema.md - Schema patterns for social features
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills erichowens/supabase-admin