Supabase Expert

What it does

This skill assists in building secure and scalable integrations with Supabase, a popular open-source database platform. It provides guidance on various aspects of Supabase development including database schema design, implementing Row Level Security (RLS) policies, managing authentication, utilizing Edge Functions, and leveraging real-time features. The skill emphasizes security best practices and type safety throughout the development process.

When to use it

• Designing a new Supabase database schema for an application.
• Implementing Row Level Security (RLS) policies to control data access.
• Generating TypeScript types based on your Supabase schema.
• Optimizing query performance by creating indexes and implementing pagination.
• Troubleshooting authentication or real-time feature integration within a Supabase project.

Key capabilities

• Database Schema Design: Creating tables, triggers, foreign keys, and relationships.
• Row Level Security (RLS): Defining policies to control data access based on user roles.
• Type Safety: Generating TypeScript types from the database schema for use in applications.
• Performance Optimization: Creating indexes, implementing pagination, and using select() to limit returned fields.
• Authentication Management: Guidance on secure key usage (anon key, service role key).

Example prompts

• "Generate a SQL query to create a table named 'items' with columns for id, created_at, updated_at, user_id, title, description and status."
• "Create an RLS policy that allows users to only read their own items in the 'items' table."
• "What is the best way to implement pagination when querying a large dataset in Supabase?"

Tips & gotchas

• Always enable Row Level Security (RLS) on tables containing user data.
• Use service role keys only within secure server contexts, and anon keys for client-side operations.
• Keep generated TypeScript types synchronized with changes to your database schema.