Supabase Reference Architecture

What it does

This skill provides a reference architecture for building applications with Supabase, an open-source Firebase alternative. It offers guidance on structuring your project, setting up database tables and relationships, and implementing authentication flows. The architecture promotes best practices for scalability, security, and maintainability when using Supabase.

When to use it

• You're starting a new project that requires a backend database and user authentication.
• You want to refactor an existing application to leverage the features of Supabase.
• You need help designing your Supabase database schema for optimal performance.
• You are looking for guidance on implementing row-level security in your Supabase tables.

Key capabilities

• Database schema design recommendations
• Authentication flow implementation guidance
• Row-Level Security (RLS) configuration examples
• Project structure suggestions
• Scalability and performance considerations

Example prompts

• "Generate a Supabase database schema for an e-commerce application with products, users, and orders."
• "Show me how to implement passwordless authentication in my Supabase project."
• "What are the best practices for securing my Supabase data using Row Level Security?"

Tips & gotchas

This skill assumes you have a basic understanding of relational databases and SQL. While it provides guidance, familiarity with Supabase's documentation is recommended to fully utilize its capabilities.