Oh, I mean like with the vacuum command. As the databases get larger it can become unwieldy.

I just tried it, it only recovered a few MB

Aha, so not much need. I've always avoided SQLite for larger databases due to the extra space needed to allow compaction, maybe not a real problem in most applications though.