Public Sharing

import { togglePromptPublic } from '@/features/prompts/actions/manage-prompt';

// Make public
await togglePromptPublic(promptId, true);

// Make private
await togglePromptPublic(promptId, false);

export async function togglePromptPublic(
  promptId: string,
  isPublic: boolean,
): Promise<PromptActionResult> {
  const { supabase, user } = await requireUser();
  if (!user) return { success: false, error: 'Unauthorized' };

  const { error } = await supabase
    .from('prompts')
    .update({ is_public: isPublic })
    .eq('id', promptId);

  if (error) {
    return { success: false, error: `Failed to update sharing: ${error.message}` };
  }

  revalidatePath('/');
  return { success: true };
}

https://your-app.com/p/[promptId]

https://promptrepo.com/p/550e8400-e29b-41d4-a716-446655440000

export default async function PublicPromptPage({ params }: PublicPromptPageProps) {
  const { promptId } = await params;
  const prompt = await getPublicPrompt(promptId);

  if (!prompt) {
    notFound();
  }

  return (
    <div className="min-h-screen bg-background">
      <div className="container max-w-2xl px-4 py-10">
        <div className="mb-6 space-y-1">
          <h1 className="text-2xl font-bold tracking-tight text-foreground">
            {prompt.title}
          </h1>
          {prompt.description && (
            <p className="text-sm text-muted-foreground">
              {prompt.description}
            </p>
          )}
        </div>
        <div className="rounded-md border border-border bg-card p-4 font-mono text-sm leading-relaxed text-foreground whitespace-pre-wrap shadow-sm">
          {prompt.latest_content}
        </div>
      </div>
    </div>
  );
}

import { getPublicPrompt } from '@/features/prompts/queries/get-public-prompt';

const prompt = await getPublicPrompt(promptId);

export async function getPublicPrompt(promptId: string): Promise<PublicPrompt | null> {
  const supabase = createPublicClient();

  const { data, error } = await supabase
    .from('prompts')
    .select(`
      id,
      title,
      description,
      prompt_versions (
        content,
        version_number
      )
    `)
    .eq('id', promptId)
    .eq('is_public', true)  // Only return if public
    .maybeSingle();

  if (error || !data) {
    return null;
  }

  const response = data as unknown as DbPublicPromptResponse;
  const versions = response.prompt_versions || [];
  const latestVersion = versions.sort((a, b) => 
    b.version_number - a.version_number
  )[0];

  return {
    id: response.id,
    title: response.title,
    description: response.description,
    latest_content: latestVersion?.content || '',
  };
}

interface PublicPrompt {
  id: string;
  title: string;
  description: string | null;
  latest_content: string;  // Only the latest version
}

ALTER TABLE prompts 
  ADD COLUMN is_public BOOLEAN DEFAULT false NOT NULL;

CREATE INDEX idx_prompts_is_public ON prompts(is_public);

CREATE POLICY "Anyone can view public prompts" 
  ON prompts FOR SELECT 
  USING (is_public = true);

// From src/middleware.ts
export const config = {
  matcher: [
    '/((?!_next/static|_next/image|favicon.ico|.*\\.(?:svg|png|jpg|jpeg|gif|webp)$|p/).*)',
  ],
};

Title: "Advanced Code Review Prompt"
Public URL: /p/abc123
Use: Include in your portfolio or resume

## Example Prompt

See our [customer support template](/p/def456) for reference.

Hey team, check out this prompt: https://promptrepo.com/p/ghi789
Feel free to copy and adapt it for your needs.

Lesson 5: See the [example prompt](/p/jkl012) demonstrating 
variable usage.

await togglePromptPublic(promptId, false);

curl -X POST https://your-app/api/mcp \
  -H "Content-Type: application/json" \
  -d '{
    "jsonrpc": "2.0",
    "method": "tools/call",
    "params": {
      "name": "get_prompt",
      "arguments": { "id": "prompt-uuid" }
    }
  }'

const { data } = await supabase
  .from('prompts')
  .select('id, title, description')
  .eq('is_public', true);