A dosage of Psilocybin which will cause a mild trip will supposedly last for up to a few months.
Microdosing, which is I think every couple/few days, is in dosages that you don't feel or very minimally feel and that's another approach.
My daughter has migraines, and is helped by Triptans but...