An mbtiles file is just an SQLite db which can store image or vector tiles which can be very useful.

It's great for exploring tiles but it essentially doesn't support range queries/requests, which pmtiles does.