I have a medium size through hole PCB for prototyping. I remember a project in school that gave us a female to male connector that allowed us plug in a microcontroller (atmega328p, but could be any length of ucontroller) by hand without soldering or directly wire-wrapping the atmega's pins.
It provides black spacing above the PCB for the microcontroller's pins, but we solder the bottom through hole side (I believe the through hole was the standard 2.54 mm round opening). And the above female accepted the standard 2.54 mm as well.
Not sure of the length of the metal. I just remember the black portion was that standard plastic material that would melt when applying too much time soldering the metal.
I think its through hole DIP socket header but when I google that I can't find it exactly.