At present, most calculation results regarding foundation pit dewatering are ideal values, making construction resources prone to being wasted. In order to optimize the traditional pipe well design of large wells, the linear programming solution module in Excel is used, with the total water inflow taken as the objective function, the water level drawdown used as the constraint and test condition, and a station project on the Chengdu Metro Line 7 serving as the subject of this study. The total water inflow of the traditional pipe well design is optimized by the simplex method, producing a total water inflow of 4 040.65 m3/d, which, compared with 4 829.79 m3/d, the total water inflow calculated by means of the traditional design optimization method, engenders a reduction of roughly 16% per day. The feasibility of the optimization methodology is verified by the drawdown constraint, which reveals the decrease of construction costs and the diminution of the influence that the lowered groundwater level has on the surroundings of the metro station. Finally, references are provided as to optimizing the dewatering designs for other metro stations in similar engineering and hydrogeological conditions.