Supabase Postgres Best Practices

What it does

This skill provides guidance and best practices for working with Supabase, a platform that offers a PostgreSQL database alongside authentication and real-time features. It helps users optimize their Supabase deployments by suggesting efficient schema designs, secure access controls, and performant query strategies. The skill aims to improve the reliability, security, and performance of applications built on Supabase.

When to use it

• Designing a new database: Get recommendations for optimal table structures and data types within your Supabase project.
• Troubleshooting slow queries: Identify bottlenecks in existing SQL queries and receive suggestions for optimization.
• Implementing row-level security (RLS): Receive guidance on setting up granular access controls to protect sensitive data.
• Improving database performance: Learn strategies for indexing, caching, and other techniques to enhance overall database speed.

Key capabilities

• Schema design recommendations
• SQL query optimization suggestions
• Row-Level Security (RLS) implementation guidance
• Database performance tuning advice

Example prompts

• "Suggest a schema for storing user data in my Supabase project."
• "How can I optimize this SQL query: SELECT * FROM orders WHERE customer_id = $1?"
• "What's the best way to implement Row-Level Security on my 'products' table?"

Tips & gotchas

The skill assumes a basic understanding of PostgreSQL and Supabase concepts. To get the most accurate recommendations, provide detailed information about your existing database schema or query requirements.