This paper proposed a comprehensive and automated framework that integrates the entire urban drainage design process, from refined land use segmentation, to catchment subdivision and characterization, to network topology generation, and finally to hydraulic estimation of pipeline capacity, based on multiple open-source datasets. The method incorporated deep learning-based semantic segmentation, GIS-based hydrological characterization, topology generation and hydraulic calculation algorithms. The performance and applicability of the method were validated through case studies of two cities. The results showed that the deep learning model with prior knowledge could accurately segment urban land use to obtain the detailed shape and boundary description, and achieved higher detection accuracy for water bodies, buildings, and roads. The stormwater drainage topology and conveyance capacity were automatically generated based on subcatchment division and hydrological characterization under a set of topological parameter conditions. In the optimal Critical Success Index (CSI) scenario, only 8% and 21% of the generated pipelines were inconsistent with the expert-designed networks. Compared to the traditional manual design process, the automated approach can save significant time and resources and reduce the reliance on field surveys and empirical/expert work. At the same time, the tool can be employed for system layout and capacity optimization, providing important support for the automation, design, and rehabilitation of stormwater drainage systems.