As I discuss in this question, by far the most popular school of Hindu philosophy is the Vedanta school. But there are five other Astika or orthodox schools of Hindu philosophy: Purva Mimamsa, Samkhya, Yoga, Vaisheshika, and Nyaya. My question is about the Yoga school, which had a similar worldview to the Samkhya school except it embraced the existence of a supreme being. The defining text of the Yoga school is Patanjali's Yoga Sutras.
Now one of the tenets of the Yoga school is that you can obtain Siddhis or magical powers through meditation. But that's not the only way to obtain Siddhis, as Patanjali describes in Adhyaya 4 Sutra 1 of the Yoga Sutras:
janma-oṣadhi-mantra-tapas-samādhi-jāḥ siddhayaḥ
Supernatural powers (siddhis) arise from birth, drugs, mantras, austerity, or yoga (samadhi)
As you can see, one of the methods of obtaining Siddhis is through the use of drugs or herbs. Here is what the Advaita philosopher Vachaspati Mishra says in this excerpt from his commentary on the Yoga Sutra:
He describes the attainments [Siddhis] due to drugs: - "In the houses of the Asuras." Man passes to the places of the Asuras for some reason. He is met there by lovely Asura damsels, and is given an offering of elixer. Using that he comes to possess the attainments of freedom from decay and death, and other attainments. Or, the same may take place even here by the use of elixir, as in the case of the thinker Mandavya, who resided in the Vindhya mountains and who used the elixir.
Now it would obviously be impractical to go to Patalaloka and obtain herbs from Asura damsels. But I'm interested in the part in bold, where Vachaspati Mishra claims that you can obtain Siddhis using herbs right here on Earth. So my question is, what herbs available on Earth grant Siddhis?
Do any scriptures shed light on this? What was the elixir used by sage Mandavya, for instance?