jikime-platform-supabaselisted

# Supabase Platform Guide Comprehensive guide for Supabase + Next.js full-stack development and Postgres performance optimization. ## When to Apply Reference this skill when: - Building full-stack apps with Supabase backend - Writing SQL queries or designing schemas - Implementing indexes or query optimization - Setting up real-time features or pgvector for AI embeddings - Configuring authentication, storage, or Edge Functions - Reviewing database performance issues - Configuring connection pooling or scaling - Working with Row-Level Security (RLS) ## Quick Reference | Feature | Description | |---------|-------------| | **PostgreSQL 16** | Full SQL, JSONB | | **pgvector** | AI embeddings, vector search | | **RLS** | Row Level Security | | **Realtime** | Real-time subscriptions | | **Auth** | Authentication, JWT | | **Storage** | File storage | ## Setup ### Next.js Client ```bash npm install @supabase/supabase-js @supabase/ssr ``` ```typescript // lib/supabase/client.ts import { createBrowserClient } from '@supabase/ssr'; export function createClient() { return createBrowserClient( process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY! ); } // lib/supabase/server.ts import { createServerClient } from '@supabase/ssr'; import { cookies } from 'next/headers'; export function createClient() { const cookieStore = cookies(); return createServerClient( process.env.NEXT_PUBLIC_SUPABASE_URL!, process.env.NEXT_PUBLIC_SUPABA