Shurahbil bin Simt reported,

Nafi said to Kaab, "Kaab bin Mura, narrate to us from the Messenger of Allah ﷺ and be careful in what you report."Kaab said, "A man came to the Prophet ﷺ and said, 'Messenger of Allah ﷺ, pray to Allah for rain.' So the Messenger of Allah ﷺ raised his hands and said, 'O Allah, give us rain that is wholesome, abundant, widespread, swift and not delayed, beneficial and not harmful.'"Kaab continued, "They had not even gathered themselves before the sky turned dark with clouds. Then they came to him complaining about the rain, saying, 'Messenger of Allah ﷺ, the houses have collapsed.' So he said, 'O Allah, around us and not upon us.' Then the clouds began to break apart to the right and to the left."

Azami 2954

Sahih

عن شرحبيل بن السمط

أنه قال لكعب: يا كعب بن مرة! حدثنا عن رسول الله ﷺ واحذر. قال: جاء رجل إلى النبي ﷺ فقال: يا رسول الله ﷺ! استسق الله فرفع رسول الله ﷺ يديه فقال: اللهم اسقنا غيثا مريئا مريعا طبقا عاجلا غير رائث، نافعا غير ضار قال: فما جمعوا حتى أخيوا، قال: فأتوه فشكوا إليه المطر، فقالوا: يا رسول الله ﷺ: تهدمت البيوت فقال: اللهم حوالينا ولا علينا قال: فجعل السحاب ينقطع يمينا وشمالا.

الأعظمي 2954صحيح
Contents
Reference
Commentary
Ayat
Collection
Jami al-Kamil
Book
Prayer
Chapter
Prayer for rain
Section
Supplications for rain
Numbering
Jami al-Kamil 2954 (2nd edition)
Azami 2954