there used to be this nice "about:me" extension (https://wiki.mozilla.org/Firefox/Projects/about:me), but is defunct. It's source is released at https://github.com/leibovic/about-me and waiting to be turned into a webextension.

I often query the places.sqlite directly. Sqlite is missing some handy string functions though, but there's usually an extension available.