Thank you for your response. My research is primarily focused on the environmental aspect, and I believe that the HMDB database alone will not be sufficient in addressing that specific context.
in addition to the valuable answers from Colleagues, below are some other links, more for metabolomics etc but you may find something useful for your research: