Firstly , Welcome ! :D
I have no direct experience of the pickup I am about to suggest ; but I am surmising that the 'Pig 90' is going to be recommended. A ceramic Warpig derivative, in a 'Mississipi Queen ' type casing and allen key polepieces (?) I have the Mississipi Queens, which can be assertive when required, but It would seem much more appropriate ( for your tonal needs - and a Mahogany body ) to look at the Pig 90. I see that Tom ( amongst others ) has a Pig 90 - and has put a demo up in the 'Player's' section.
I hope that gets the ball rolling . :)