A couple of German libraries, assisted by the German Research Council, have scanned all 63,000 pages (g) of 'Johann Heinrich Zedler's Great Complete Universal Encyclopedia of All the Sciences and Arts', published in 1732. It's even searchable. And it's fantastic.
I searched for melancolia in various spellings and came across this recipe for 'Spiced Beer Against Melancholey'. The antiquated spelling and Fraktur script make it a bit hard to read, but the recipe seems to have at least 15 or so ingredients, including young beer, 'hermo-dates(?)', carrot seeds, radishes, white wine, coriander seeds, juniper berries, St. John's Wort tips, and much more:
There's got to be some philologist out there who can interpret the weights, measures, and cooking instructions. We can only hope all the spices are still available.
Let's all get together and whip up a giant cauldron of this stuff and get rid of our Melancholey once and for all! Who's with me?