Photocatalytic CO2 reduction offers a promising, sustainable approach to solar-driven methanol (MeOH) synthesis. The current photocatalytic efficiency of available covalent organic frameworks (COFs) remains insufficient for practical industrial-scale utilization. Herein, a non-functionalized COF (COF-TPDA) is constructed reasonably to anchor isolated Cu atoms at its imine N sites via the photodeposition method (Cu1/COF-TPDA), thereby enhancing both charge-separation efficiency and intramolecular electron-migration rate within the aromatic skeleton. Cu1/COF-TPDA exhibits strong, reliable photocatalytic activity for the selective conversion of CO2 to MeOH in neutral water under simulated sunlight, without sacrificial reagents. A MeOH yield of 875.2 μmol·gcat-1·h-1 is achieved, surpassing the performance of state-of-the-art photocatalysts under the same reaction conditions. In situ characterization and theoretical calculations reveal that forming Cu-N coordination enhances the catalyst's photoelectric conversion efficiency. Cu single atoms redirect the CO* hydrogenation pathway, which has a free energy barrier of 1.37 eV and is catalyzed by N sites in COF-TPDA, toward the direct hydrogenation of HCOOH* on Cu1/COF-TPDA. It also lowers the free-energy barrier for HCOO* formation during MeOH synthesis to 0.76 eV, thereby significantly enhancing the photocatalytic activity of the catalyst. This research shows that the photocatalytic performance of COFs can be efficiently adjusted by anchoring metal single atom sites, offering universal guidelines for creating COF-based photocatalysts that are both highly active and scalable.