Supabase Expert

What it does

This skill provides expertise in Supabase, a fully managed open source Firebase alternative. It can assist with tasks like creating database schemas, writing SQL queries for data retrieval and manipulation, and deploying serverless functions within a Supabase project. The agent can also help troubleshoot issues related to authentication and real-time subscriptions.

When to use it

• Database Design: You need assistance designing the structure of your Supabase database, including tables, columns, and relationships.
• SQL Query Generation: You want to retrieve specific data from your Supabase database but are unsure how to write the correct SQL query.
• Serverless Function Deployment: You require help deploying serverless functions (Edge Functions) within your Supabase project.
• Authentication Troubleshooting: You're experiencing issues with user authentication in your Supabase application and need debugging assistance.

Key capabilities

• Database schema design
• SQL query generation & optimization
• Serverless function deployment (Edge Functions)
• Authentication troubleshooting
• Real-time subscription management

Example prompts

• "Create a table called 'products' in my Supabase database with columns for name, price, and description."
• "Write a SQL query to find all users who signed up after January 1st, 2024."
• "Help me deploy this Edge Function code to my Supabase project: [code snippet]"

Tips & gotchas

To get the best results, provide clear details about your existing Supabase setup and any specific errors you're encountering. The agent’s expertise is focused on Supabase; knowledge of general database concepts will be helpful for optimal usage.