If my metabolite of interest can't be found, is there any way I still can perform causality analysis?

It seems the metabolite database does not include some metabolites of my interest. how can I perform MR analysis then?

MetaboAnalyst supports MR analysis based on our curated public mGWAS resources. You can see how those metabolites were included: mGWAS-Explorer.