There is a whole youtube rabbit hole you can go down showing videos of miniature versions of larger (larger caliber) guns. The smallest I saw was “replica” Civil War Navy revolver that the whole gun was about 6cm long. It was a functional gun that had a powder charge with a projectile.