Supabase Postgres Best Practices

What it does

This skill provides guidance and best practices for working with Supabase and PostgreSQL databases. It helps users optimize database performance, security, and overall architecture within the Supabase environment. The skill can generate SQL queries, suggest schema improvements, and provide recommendations for efficient data management.

When to use it

• You're designing a new application using Supabase and want to ensure optimal database design from the start.
• Your existing Supabase/PostgreSQL database is experiencing performance issues (slow query times, high resource usage).
• You need help writing complex SQL queries or optimizing existing ones for better efficiency.
• You're unsure about security best practices when dealing with sensitive data in your Supabase environment.

Key capabilities

• SQL Query Generation and Optimization
• Schema Design Recommendations
• Performance Tuning Suggestions
• Security Best Practices Guidance
• PostgreSQL Architecture Advice

Example prompts

• "Suggest a database schema for an e-commerce application using Supabase."
• "Optimize this SQL query: SELECT * FROM orders WHERE customer_id = 123;"
• "What are the best practices for securing user data in a Supabase project?"

Tips & gotchas

This skill assumes some familiarity with PostgreSQL and database concepts. Providing context about your specific Supabase setup (e.g., table names, existing schema) will yield more accurate and relevant recommendations.