Abstract The dynamic heterogeneity of water drive sandstone reservoir in high water cut stage is strong, which leads to the differential enrichment and distribution of remaining oil. The adjustment of injection-production relationship can effectively guide the work of stabilizing oil and controlling water. Based on the principle of inter-well connectivity, this paper comprehensively considers the geological characteristics and development dynamics, and constructs the multi-layer reservoir joint well network inter-well connectivity model. By integrating the automatic history matching and the real-time injection-production optimization algorithms, the accurate inversion of connectivity parameters and real-time optimization prediction of production dynamics are realized. Field applications in the block X demonstrated that this method resulted in an annual increase in oil production of 16,000 cubic meters and a reduction in water cut by 0.87%, showing significant enhancement in oil recovery and water control. This method can be applied to guide the adjustment of the planar injection-production structure in similar reservoirs.