Supabase Postgres Best Practices

What it does

This skill provides best practices for working with Supabase and PostgreSQL databases. It helps ensure data integrity, optimizes performance, and improves security when building applications using these technologies. The skill focuses on establishing reliable database workflows and adhering to industry standards.

When to use it

• Database Design: When designing a new application's schema in Supabase or PostgreSQL.
• Performance Tuning: When experiencing slow query times or overall database performance issues.
• Security Audits: During security reviews of existing applications utilizing Supabase and PostgreSQL.
• Migration Planning: When planning migrations between different versions of PostgreSQL within a Supabase environment.

Key capabilities

• Database schema design best practices
• Query optimization techniques
• PostgreSQL version compatibility guidance
• Supabase-specific security recommendations
• Data integrity enforcement strategies

Example prompts

• "What are the best practices for indexing tables in my Supabase database?"
• "How can I optimize this PostgreSQL query: [query text]?"
• "Suggest ways to improve the security of user authentication within my Supabase application."

Tips & gotchas

The skill assumes a basic understanding of SQL and relational databases. While it covers Supabase-specific recommendations, familiarity with PostgreSQL concepts is beneficial for optimal results.