رَبِّ هَبْ لِي مِن لَّدُنكَ وَلِيًّا يَرِثُنِي وَيَرِثُ مِنْ آلِ يَعْقُوبَ وَاجْعَلْهُ رَبِّ رَضِيًّا
Rabbi hab li min ladunka waliyyan yarithuni wa yarithu min ali Ya'qub, waj'alhu Rabbi radiyya
My Lord, grant me from Yourself an heir who will inherit from me and from the family of Ya'qub. And make him, my Lord, pleasing to You.
Zakariyya's (AS) more detailed du'a for a son. He did not just want any child — he wanted one who would inherit the prophetic legacy of the family of Ya'qub (AS). And the final request: "make him pleasing to You" — not pleasing to me, not successful by worldly standards, but radiyya — someone Allah is pleased with. The highest aspiration a parent can have for their child.
Related Du'as
اللَّهُمَّ أَحْسِنْ عَاقِبَتَنَا فِي الْأُمُورِ كُلِّهَا وَأَجِرْنَا مِنْ خِزْيِ الدُّنْيَا وَعَذَابِ الْآخِرَةِ
O Allah, make good the outcome of all our affairs and protect us from the disgrace of this world and the punishment of the Hereafter.
Sahihرَبِّ هَبْ لِي مِن لَّدُنكَ ذُرِّيَّةً طَيِّبَةً ۖ إِنَّكَ سَمِيعُ الدُّعَاءِ
My Lord, grant me from Yourself good offspring. Indeed, You are the Hearer of supplication.
Sahihاللَّهُمَّ إِنِّي أَسْأَلُكَ خَيْرَهَا وَخَيْرَ مَا جَبَلْتَهَا عَلَيْهِ وَأَعُوذُ بِكَ مِنْ شَرِّهَا وَشَرِّ مَا جَبَلْتَهَا عَلَيْهِ
O Allah, I ask You for her goodness and the goodness of what You have created in her nature, and I seek refuge in You from her evil and the evil of what You have created in her nature.
Hasanرَبَّنَا هَبْ لَنَا مِنْ أَزْوَاجِنَا وَذُرِّيَّاتِنَا قُرَّةَ أَعْيُنٍ وَاجْعَلْنَا لِلْمُتَّقِينَ إِمَامًا
Our Lord, grant us from among our spouses and offspring comfort to our eyes, and make us a leader for the righteous.
Sahih