Function getFeaturedMCPs

apps/cursor/src/data/queries.ts:208–232

({
  onlyPremium,
}: {
  onlyPremium?: boolean;
} = {})

}

export async function getFeaturedMCPs({
  onlyPremium,
}: {
  onlyPremium?: boolean;
} = {}) {
  "use cache";
  cacheLife("hours");
  cacheTag("mcps");

  const supabase = await createClient();
  const { data, error } = await supabase
    .from("mcps")
    .select("*")
    .limit(100)
    .order("created_at", { ascending: false })
    .order("order", { ascending: false })
    .eq("active", true)
    .or(onlyPremium ? "plan.eq.premium" : "plan.eq.featured,plan.eq.premium");

  return {
    // Shuffle so featured placement rotates between cache revalidations.
    data: data?.sort(() => Math.random() - 0.5),
    error,
  };
}

export async function getTotalUsers() {
  "use cache";