Supabase Developer

Build full-stack applications with Supabase authentication, PostgreSQL schemas, RLS, and real-time features.

34|7|Updated Oct 22, 2025
One-click install
npx skills add https://github.com/daffy0208/ai-dev-standards --skill supabase-developer
Or copy as Structured Prompt for Agentβ–Ό
Please help me install this Agent Skill.
Skill: Supabase Developer
Source: https://github.com/daffy0208/ai-dev-standards/tree/main/SKILLS/supabase-developer
Command: npx skills add https://github.com/daffy0208/ai-dev-standards --skill supabase-developer

SYSTEM DOCUMENTATION & REQUIREMENTS

πŸ’‘ This Skill requires @supabase/supabase-js.

What problem does it solve?

This Skill eliminates backend complexity by providing a complete, secure platform for building production-ready applications with built-in authentication, database, storage, and real-time features.

Core Features & Use Cases

  • PostgreSQL with RLS: Design secure database schemas with Row Level Security as the primary protection layer.
  • Authentication & Storage: Implement multiple auth strategies and manage file uploads with access control.
  • Use Case: Imagine building a collaborative document editor. Use this Skill to handle user authentication, store documents securely, and implement real-time collaboration features.

Quick Start

Use the Supabase Developer skill to create a new user authentication system with email/password and Google OAuth.

Frequently Asked Questions about Supabase Developer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a full-stack app with PostgreSQL and real-time features?β–Ό

Build full-stack applications using Supabase's PostgreSQL database with built-in real-time subscriptions, authentication, and storage. Design secure schemas with Row Level Security, implement auth strategies, and subscribe to data changes across your app.

How do I set up Row Level Security in PostgreSQL for user data isolation?β–Ό

Row Level Security (RLS) enforces database-level access control in PostgreSQL by restricting rows users can query based on policies. Supabase provides RLS as the primary protection layer, ensuring authenticated users access only their own data without application-level checks.

Can I implement OAuth and email authentication in the same app?β–Ό

Yes, Supabase supports multiple authentication strategies simultaneously, including email/password and OAuth providers like Google. Configure both methods in your auth settings and users can choose their preferred login approach.

What's the best way to manage file uploads with access control?β–Ό

Use Supabase Storage to manage file uploads with built-in access control tied to authentication. Combine storage with RLS policies to ensure users access only authorized files, eliminating separate permission logic.

Do I need to write migrations manually for production PostgreSQL schemas?β–Ό

Supabase supports migrations for production-ready deployments, enabling version-controlled schema changes. While migrations are optional for development, they're essential for tracking schema evolution, rollbacks, and team collaboration in production environments.

How do I add real-time collaboration to a document editor?β–Ό

Implement real-time collaboration by subscribing to PostgreSQL table changes via Supabase's real-time API. Users receive instant updates when documents are edited, combined with authentication to verify access and RLS to enforce row-level permissions.