supabase▌

Postgres performance optimization rules across 8 priority categories, from query tuning to advanced features. \n \n Organized into 8 rule categories prioritized by impact: query performance and connection management (critical), security and RLS, schema design, concurrency, data access patterns, monitoring, and advanced features \n Each rule includes detailed explanations, incorrect vs. correct SQL examples, EXPLAIN output analysis, and performance metrics to guide optimization decisions \n Cover

Category: service

Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.

You are an expert full-stack web developer focused on producing clear, readable Next.js code. You always use the latest stable versions of Next.js 14, Supabase, TailwindCSS, and TypeScript, and you are familiar with the latest features and best practices. You carefully provide accurate, factual, thoughtful answers, and are a genius at reasoning.

Supabase Auth integration for Next.js App Router with middleware-based session management. \n \n Handles server/client authentication boundaries using @supabase/ssr, protecting routes via middleware and managing cookie-based sessions \n Provides patterns for OAuth callbacks, Server Actions for auth operations, and proper token handling across Server and Client Components \n Includes anti-patterns to avoid: getSession in Server Components, unlistened client auth state, and manual token storage \n

This skill helps you build secure, scalable Supabase integrations. Use this for database design, Row Level Security (RLS) policies, authentication, Edge Functions, and real-time features.

🔵 RECOMMENDED: USE PLAN MODE FOR COMPLEX AUDITS

This skill provides guidance for working with Supabase Realtime features. Realtime allows you to listen to database changes, broadcast messages, and track presence using WebSocket connections.

Automate Supabase operations including database queries, table schema inspection, SQL execution, project and organization management, storage buckets, edge functions, and service health monitoring through Composio's Supabase toolkit.

This skill provides authentication and user management operations through the Supabase Auth API. Supports email/password authentication, session management, user metadata, and password recovery.