His libretto for Gabriella di Vergy, originally set by Michele Carafa in 1816, was reworked by Donizetti in the 1820s and 1830s. He wrote six other librettos for Donizetti, including those for La zingara (1822), Alfredo il grande (1823), Il castello di Kenilworth (1829) and Imelda de' Lambertazzi (1830).
For Vincenzo Bellini he wrote Adelson e Salvini (1825). Other composers who set Tottola's librettos to music included Giovanni Pacini (Alessandro nelle Indie (1824) and others), Saverio Mercadante, Johann Simon Mayr, Nicola Vaccai, Errico Petrella, Ferdinando Paer and Manuel Garcia.
Tottola died in Naples.