// List tables
CallMcpTool("project-0-real-singles-supabase", "list_tables", { schemas: ["public"] })

// Check columns
CallMcpTool("project-0-real-singles-supabase", "execute_sql", {
  query: "SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'users'"
})

// Check RLS policies
CallMcpTool("project-0-real-singles-supabase", "execute_sql", {
  query: "SELECT policyname, cmd, qual FROM pg_policies WHERE tablename = 'users'"
})

CallMcpTool("project-0-real-singles-supabase", "apply_migration", {
  name: "add_field_to_users",
  query: `
    ALTER TABLE users ADD COLUMN IF NOT EXISTS new_field TEXT;
    CREATE INDEX IF NOT EXISTS idx_users_new_field ON users(new_field);
  `
})

cd web && pnpm db:types

cp web/src/types/database.types.ts mobile/types/database.types.ts

import { createApiClient } from "@/lib/supabase/server";
import { NextResponse } from "next/server";

export async function GET() {
  const supabase = await createApiClient();
  
  const { data: { user } } = await supabase.auth.getUser();
  if (!user) {
    return NextResponse.json({ error: "Unauthorized" }, { status: 401 });
  }
  
  // Query database...
}

import { 
  resolveStorageUrl,
  resolveGalleryUrls,
  resolveProfileImageUrls,
  resolveOptimizedImageUrl,
  IMAGE_SIZES 
} from "@/lib/supabase/url-utils";

// Single image
const url = await resolveStorageUrl(supabase, path);
const url = await resolveStorageUrl(supabase, path, { bucket: "events" });

// Optimized image
const url = await resolveOptimizedImageUrl(supabase, path, "thumbnail");

// Batch operations
const items = await resolveGalleryUrls(supabase, galleryData);
const users = await resolveProfileImageUrls(supabase, userData);

IMAGE_SIZES = {
  thumbnail: { width: 150, height: 150, quality: 70 },
  card: { width: 400, height: 400, quality: 75 },
  cardWide: { width: 600, height: 400, quality: 75 },
  medium: { width: 600, height: 600, quality: 80 },
  large: { width: 1200, height: 1200, quality: 85 },
  hero: { width: 800, height: 600, quality: 80 },
}

import { 
  getGalleryPath,
  getAvatarPath,
  getVoicePromptPath,
  getVideoIntroPath,
  validateFile,
  STORAGE_BUCKETS 
} from "@/lib/supabase/storage";

const path = getGalleryPath(userId, filename);
const { valid, error } = validateFile(file, STORAGE_BUCKETS.GALLERY);

// ✅ Correct
media_url: "user123/photo.jpg"

// ❌ Wrong
media_url: "https://xxx.supabase.co/storage/v1/object/gallery/..."

ALTER TABLE table_name ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Users can read own data" ON table_name
  FOR SELECT USING (auth.uid() = user_id);

CREATE POLICY "Users can insert own data" ON table_name
  FOR INSERT WITH CHECK (auth.uid() = user_id);

CREATE POLICY "Users can update own data" ON table_name
  FOR UPDATE USING (auth.uid() = user_id);

CREATE POLICY "Users can delete own data" ON table_name
  FOR DELETE USING (auth.uid() = user_id);

CREATE POLICY "Users can read profiles" ON profiles
  FOR SELECT USING (
    EXISTS (SELECT 1 FROM users WHERE users.id = profiles.user_id AND users.status = 'active')
    AND NOT EXISTS (
      SELECT 1 FROM blocks 
      WHERE (blocks.blocker_id = auth.uid() AND blocks.blocked_id = profiles.user_id)
      OR (blocks.blocker_id = profiles.user_id AND blocks.blocked_id = auth.uid())
    )
  );

CREATE TABLE IF NOT EXISTS new_table (...);
ALTER TABLE users ADD COLUMN IF NOT EXISTS new_field TEXT;
CREATE INDEX IF NOT EXISTS idx_name ON table(column);

-- Policies: drop first
DROP POLICY IF EXISTS "policy_name" ON table;
CREATE POLICY "policy_name" ON table ...;