Supabase Expert

What it does

This skill provides expertise in Supabase, a popular open-source Firebase alternative. It can assist with database design and optimization, implementing authentication flows using Supabase's Auth system, and building real-time features leveraging PostgreSQL’s capabilities within the Supabase platform. The agent can also help troubleshoot issues related to data storage and retrieval within a Supabase project.

When to use it

• Database Schema Design: You need assistance designing a relational database schema for your application using Supabase's PostgreSQL backend.
• Authentication Implementation: You want to implement user authentication, authorization, and role-based access control in your application leveraging Supabase Auth.
• Real-time Feature Development: You are building features that require real-time updates and data synchronization within a Supabase project.
• Troubleshooting Database Issues: You're encountering errors or performance bottlenecks with your existing Supabase database and need help diagnosing the problem.

Key capabilities

• Database design & optimization in PostgreSQL (Supabase)
• Implementation of authentication flows using Supabase Auth
• Real-time feature development leveraging PostgreSQL’s capabilities
• Troubleshooting data storage and retrieval issues within a Supabase project

Example prompts

• "Can you help me design a database schema for an e-commerce application in Supabase?"
• "How do I implement email authentication with password reset using Supabase Auth?"
• "I'm experiencing slow query performance in my Supabase database. Can you suggest some optimization strategies?"

Tips & gotchas

This skill assumes a basic understanding of relational databases and PostgreSQL concepts. While it can assist with complex tasks, providing clear context about your existing Supabase project will yield better results.