A stinger was a sharp spine used as a defensive measure by some creatures. This was used to sting.
Bees and wasps left their stinger behind when they stung someone. In 2267, Doctor Leonard McCoy compared the tentacles still present in the bodies of the flying parasite victims on Deneva to a stinger. (TOS: "Operation -- Annihilate!")