Supabase Postgres Best Practices

What it does

This skill provides guidance and recommendations for implementing best practices when working with Supabase and PostgreSQL databases. It helps ensure database performance, security, and maintainability through optimized configurations and coding patterns. The skill focuses on practical advice applicable to various development stages, from initial setup to ongoing maintenance.

When to use it

• You're setting up a new Supabase project and want to establish a solid foundation for your database.
• Your existing PostgreSQL/Supabase database is experiencing performance issues or scalability concerns.
• You need assistance with securing your database against common vulnerabilities.
• You are refactoring existing SQL queries or database schemas to improve efficiency.

Key capabilities

• Database configuration optimization
• SQL query tuning and best practices
• Security hardening recommendations for Supabase/PostgreSQL
• Schema design guidance

Example prompts

• "What are the recommended indexing strategies for a table with frequent range queries?"
• "How can I secure my Supabase database against SQL injection attacks?"
• "Suggest ways to optimize this PostgreSQL query: [paste query here]"

Tips & gotchas

This skill assumes you have basic familiarity with PostgreSQL and Supabase concepts. While it offers general best practices, specific implementations may require adjustments based on your unique application requirements.