It is narrated from Sayyiduna Talq bin Ali (may Allah be pleased with him): "I was kneading clay in Madinah when a scorpion stung me. So the Prophet (peace and blessings be upon him) came to me and he (peace and blessings be upon him) performed ruqyah over me, and I recovered."
In another route it is narrated: "Sayyiduna Talq bin Ali (may Allah be pleased with him) was stung by a scorpion in the presence of the Prophet (peace and blessings be upon him), so the Prophet (peace and blessings be upon him) performed ruqyah over him and passed his blessed hand (over the affected place)."
Imam Abdullah bin Ahmad bin Hanbal also recorded this narration. Abdullah bin Ahmad also said that he found written in the book of his father (Imam Ahmad bin Hanbal), in his own handwriting, that Sayyiduna Talq bin Ali (may Allah be pleased with him) said: "A scorpion stung me in the presence of the Prophet (peace and blessings be upon him), so he (peace and blessings be upon him) performed ruqyah over me and wiped over the place."
Imam Ibn Hibban also recorded it in his Sahih.
It is narrated from Sayyiduna Abdullah bin Mas'ud (may Allah be pleased with him): "The Messenger of Allah (peace and blessings be upon him) was praying when, during prostration, a scorpion stung him (peace and blessings be upon him) on his blessed finger. After finishing the prayer the Messenger of Allah (peace and blessings be upon him) said: 'May Allah Almighty curse the scorpion; it spares neither a prophet nor anyone else.' Then the Messenger of Allah (peace and blessings be upon him) called for a vessel containing water and salt, and he (peace and blessings be upon him) kept placing the place of the sting in that water and salt, reciting 'Say: He is Allah, the One' and the two Mu'awwidhat, until the pain subsided."
Allamah Ibn Qayyim al-Jawziyyah attributed this narration to the Musnad of Abu Bakr bin Abi Shaybah, but I did not find it there.
Hadith Gradingمحدثین:سكت عنه البوصيري، لم يُسق إسناده في هذا الموضع
Hadith Takhrij«نص البوصيري أن ابن القيم عزاه لمسند ابن أبي شيبة ولم يره فيه، ولم أقف عليه من حديث ابن مسعود في الكتب المنزلة؛ والمعروف من حديث علي (شعب الإيمان 2341 ومحققه قال: إسناده لا بأس به)»