Function getMCPs

apps/cursor/src/data/queries.ts:265–296

({
  page = 1,
  limit = 36,
  fetchAll = false,
}: {
  page?: number;
  limit?: number;
  fetchAll?: boolean;
} = {})

}

export async function getMCPs({
  page = 1,
  limit = 36,
  fetchAll = false,
}: {
  page?: number;
  limit?: number;
  fetchAll?: boolean;
} = {}) {
  "use cache";
  cacheLife("hours");
  cacheTag("mcps");

  const supabase = await createClient();

  const baseQuery = () =>
    supabase
      .from("mcps")
      .select("*")
      .eq("active", true)
      .order("company_id", { ascending: true, nullsFirst: false });

  if (fetchAll) {
    return fetchAllPages((from, to) => baseQuery().range(from, to), 100);
  }

  const { data, error } = await baseQuery()
    .limit(limit)
    .range((page - 1) * limit, page * limit - 1);

  return { data, error };
}

export async function getRecentMCPs({ limit = 8 }: { limit?: number } = {}) {
  "use cache";