High stability and transparent superhydrophobic coating on a glass substrate that can effectively repel the wetting dust as a self-cleaning property are beneficial traits for solving the decrease in optical lens clarity in an unmanned underground mining environment. However, the transparent superhydrophobic coating has still not been applied due to the contradiction between visibility, hydrophobicity and durability. Herein, a sandwich-like superhydrophobic coating was designed and prepared on borosilicate glass, which consisted of a micro/nanostructure body of neutral silicone sealant (primer) and hydrophobic silica nanoparticles (interlayer), as well as a protective layer of ultraviolet (UV) gel. The coated glass exhibited excellent superhydrophobicity towards many aqueous solutions, and had highly visible light transparency of 80% at 4 wt.% primer mass content. Furthermore, significant tests including the droplet impact, hot water boiling, stirring in acetic acid aqueous solution and sandpaper abrasion were performed on our superhydrophobic coating, which indicated that the obtained transparent coating had good stability and excellent mechanical durability. The coated glass also showed a more wonderful self-cleaning property compared with that of the original glass. This superhydrophobic coating on glass substrate, fabricated by a facile and cost-effective layer-by-layer construction approach, has great potential for general and practical application in the unmanned mining environment under multiple dust and atomized water conditions.