What are you trying to do with your circuit? Connecting a transistor directly across a voltage source and turning it on is just going to cause it to dissipate all the power as heat.
How can I repeat my experiment without the transistor overheating? Do I add some LEDs bot create a voltage drop?
Your value of Ib is too high,& is turning the transistor on too hard.
If you increase the value of the resistor between the +ve supply & the base,your current will fall to a useable level.
Others have pointed out that this kind of circuit is not used in any practical circuit.
A load resistor is normally used in either the collector circuit or the emitter circuit in practice.
The kind of circuit you have
can be used to test for transistor operation ,with the leads from a DMM in the diode test position substituting for the 3 volt supply,as the DMM normally can only supply a limited amount of current ,so the test is safe for the transistor.
Your external source,on the other hand, CAN supply enough current through a transistor turned "hard on" to cook it ,as per previous comments.