# ALWAYS Bun, NEVER npm/npx
bun install
bun run dev
bun run build
bunx supabase db push

// ALWAYS timestamp, NEVER UUID
const id = Date.now().toString()

// Server Component
import { createClient } from '@/lib/supabase/server'

export default async function Page() {
  const supabase = await createClient()
  const { data, error } = await supabase
    .from('work_items')
    .select('*')
    .eq('team_id', teamId)  // REQUIRED
}

// Client Component
import { createClient } from '@/lib/supabase/client'

const supabase = createClient()
const { data } = await supabase
  .from('work_items')
  .select('*')
  .eq('team_id', teamId)  // REQUIRED

// next-app/src/app/actions/[feature].ts
'use server'

import { createClient } from '@/lib/supabase/server'
import { revalidatePath } from 'next/cache'

export async function createWorkItem(formData: FormData) {
  const supabase = await createClient()
  
  const { data, error } = await supabase
    .from('work_items')
    .insert({
      id: Date.now().toString(),
      team_id: formData.get('teamId'),
      // ... other fields
    })
    .select()
    .single()
    
  if (error) throw error
  
  revalidatePath('/dashboard/work-items')
  return data
}

// next-app/src/app/api/[resource]/route.ts
import { createClient } from '@/lib/supabase/server'
import { NextResponse } from 'next/server'

export async function GET(request: Request) {
  const supabase = await createClient()
  const { searchParams } = new URL(request.url)
  const teamId = searchParams.get('teamId')
  
  if (!teamId) {
    return NextResponse.json({ error: 'team_id required' }, { status: 400 })
  }
  
  const { data, error } = await supabase
    .from('table')
    .select('*')
    .eq('team_id', teamId)
    
  if (error) {
    return NextResponse.json({ error: error.message }, { status: 500 })
  }
  
  return NextResponse.json(data)
}

-- supabase/migrations/YYYYMMDDHHMMSS_create_table.sql
CREATE TABLE table_name (
  id TEXT PRIMARY KEY,
  team_id TEXT NOT NULL,  -- NULL breaks RLS silently!
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

-- Index for performance
CREATE INDEX idx_table_team ON table_name(team_id);

-- Enable RLS
ALTER TABLE table_name ENABLE ROW LEVEL SECURITY;

-- Policies (all 4 required)
CREATE POLICY "Users can view own team data"
  ON table_name FOR SELECT
  USING (team_id IN (
    SELECT team_id FROM team_members 
    WHERE user_id = auth.uid()
  ));

CREATE POLICY "Users can insert own team data"
  ON table_name FOR INSERT
  WITH CHECK (team_id IN (
    SELECT team_id FROM team_members 
    WHERE user_id = auth.uid()
  ));

CREATE POLICY "Users can update own team data"
  ON table_name FOR UPDATE
  USING (team_id IN (
    SELECT team_id FROM team_members 
    WHERE user_id = auth.uid()
  ));

CREATE POLICY "Users can delete own team data"
  ON table_name FOR DELETE
  USING (team_id IN (
    SELECT team_id FROM team_members 
    WHERE user_id = auth.uid()
  ));

// shadcn/ui imports
import { Button } from '@/components/ui/button'
import { Card, CardContent, CardHeader, CardTitle } from '@/components/ui/card'
import { Input } from '@/components/ui/input'

// Mobile-first, responsive
<div className="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-4">
  <Card className="p-4">
    <CardHeader>
      <CardTitle>Title</CardTitle>
    </CardHeader>
    <CardContent>
      Content
    </CardContent>
  </Card>
</div>

// Extend existing types, don't create new files
// next-app/src/lib/types/work-item-types.ts

export interface WorkItem {
  id: string
  team_id: string
  title: string
  phase: 'research' | 'planning' | 'execution' | 'review' | 'complete'
  created_at: string
  updated_at: string
}

// Use generated Supabase types
import { Database } from '@/lib/supabase/types'
type WorkItemRow = Database['public']['Tables']['work_items']['Row']