Cursor + Supabase

npx supabase init

npm install @supabase/supabase-js

NEXT_PUBLIC_SUPABASE_URL=your-project-url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key

// lib/supabase.ts
import { createClient } from '@supabase/supabase-js'

export const supabase = createClient(
  process.env.NEXT_PUBLIC_SUPABASE_URL!,
  process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!
)

-- In Supabase SQL editor
ALTER TABLE your_table ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Users can only see their own data"
ON your_table FOR ALL
USING (auth.uid() = user_id);

// Cursor prompt:
// "Create a custom hook that fetches all posts for the current user,
// handles loading and error states, and refreshes when a new post is created"

export function usePosts() {
  const [posts, setPosts] = useState([])
  const [loading, setLoading] = useState(true)

  useEffect(() => {
    supabase
      .from('posts')
      .select('*')
      .order('created_at', { ascending: false })
      .then(({ data }) => {
        setPosts(data || [])
        setLoading(false)
      })
  }, [])

  return { posts, loading }
}