Supabase Postgres Best Practices

What it does

This skill provides guidance and best practices for working with Supabase, a platform built on PostgreSQL. It helps users optimize database performance, security, and overall application architecture when utilizing Supabase's features. The skill focuses on ensuring efficient data management and leveraging PostgreSQL’s capabilities within the Supabase environment.

When to use it

• You're designing a new application using Supabase and want to follow recommended practices from the start.
• Your existing Supabase database is experiencing performance issues or security vulnerabilities.
• You need help understanding how to best utilize specific Supabase features like Row Level Security (RLS) or Postgres functions.
• You are troubleshooting errors related to data migrations or schema design within your Supabase project.

Key capabilities

• PostgreSQL Best Practices
• Supabase Specific Optimization
• Row Level Security (RLS) Guidance
• Database Schema Design Recommendations

Example prompts

• "What's the best way to handle database migrations in my Supabase project?"
• "How can I implement Row Level Security for a specific table in my Supabase database?"
• "Suggest ways to optimize query performance on this slow-running SQL query within my Supabase application."

Tips & gotchas

This skill assumes a basic understanding of PostgreSQL and the Supabase platform. While it provides best practice recommendations, adapting them to your specific use case may require additional research and testing.