Function searchCompanies

apps/cursor/src/data/client-queries.ts:32–60

(
  term: string,
  limit?: number,
)

// Searches the entire companies table by name (case-insensitive), rather than
// filtering an already-loaded page of results.
export async function searchCompanies(
  term: string,
  limit?: number,
): Promise<CompanySearchResult[]> {
  const trimmed = term.trim();

  if (!trimmed) {
    return [];
  }

  const supabase = createClient();
  const baseQuery = () =>
    supabase
      .from("companies")
      .select("id, name, slug, image, location")
      .ilike("name", `%${trimmed}%`)
      .order("name", { ascending: true });

  if (limit !== undefined) {
    const { data } = await baseQuery().limit(limit);
    return ((data ?? []) as CompanyRow[]).map(toSearchResult);
  }

  const { data } = await fetchAllPages<CompanyRow>((from, to) =>
    baseQuery().range(from, to),
  );

  return (data ?? []).map(toSearchResult);
}

export async function getMCPsClient({
  page = 1,