Supabase Development

What it does

This skill enables an AI agent to assist with Supabase development, encompassing database design, authentication, real-time features, and Edge Functions. It guides the agent to adhere to best practices for building robust and secure applications using the Supabase platform. The skill emphasizes data protection through Row Level Security (RLS) and leverages Supabase Auth for user management.

When to use it

• Designing a new database schema within a Supabase project, including defining tables, relationships, and constraints.
• Implementing authentication flows with OAuth providers like Google or GitHub.
• Creating real-time updates using Supabase subscriptions for live data changes.
• Developing Edge Functions in TypeScript/Deno to handle specific application logic.
• Integrating Supabase functionality into Next.js or SvelteKit applications.

Key capabilities

• Database design with PostgreSQL types, constraints, foreign keys, indexes, and views.
• Implementation of Row Level Security (RLS) policies for data protection.
• User authentication using Supabase Auth and OAuth providers.
• Real-time subscriptions for live data updates and presence tracking.
• Development of Edge Functions in TypeScript/Deno with proper error handling and CORS configuration.
• Integration patterns for Next.js and SvelteKit frameworks.

Example prompts

• "Create a Supabase table called 'products' with columns for name, price, and description."
• "Implement Row Level Security on the 'users' table to ensure users can only view their own data."
• "Write an Edge Function that sends a welcome email after user signup."
• “How do I implement authentication in my Next.js application using Supabase?”

Tips & gotchas

• Always enable Row Level Security (RLS) on tables containing user data to protect sensitive information.
• Thoroughly test RLS policies before deploying them to production.
• Use environment variables for storing secrets within Edge Functions.