Loyal Spark Loyalty Protocol

Instructions

Implementation Reference

• supabase/functions/loyalty-mcp/index.ts:38-50 (handler)

  The implementation of the `list_loyalty_programs` tool, which queries the `loyalty_programs` table in the database for programs owned by the merchant, optionally filtering out expired programs.

  mcpServer.tool("list_loyalty_programs", {
    description: "List loyalty programs owned by the agent's merchant",
    inputSchema: { type: "object" as const, properties: { include_expired: { type: "boolean", description: "Include expired programs" } } },
    handler: async ({ include_expired }: any) => {
      const err = authGuard(["read"]);
      if (err) return T(err);
      let q = db().from("loyalty_programs").select("id,name,symbol,token_address,status,expiration_date,created_at").eq("merchant_address", agent.ownerAddress).order("created_at", { ascending: false });
      if (!include_expired) q = q.neq("status", "expired");
      const { data, error } = await q;
      if (error) return T(JSON.stringify({ error: error.message }));
      return T(JSON.stringify({ programs: data || [] }));
    },
  });