Integrating photoactive π-chromophoric guest molecules inside the MOF nanopore can result in the emergence of light-responsive features, which in turn can be utilized for developing photoactive materials with inherent properties of MOF. Herein, we report the confining of π-chromophoric tetracene (TET) molecules inside the nanospace of postmodified Zr-MOF-808 (Zr-MOF) with MBA molecules (MBA = 2-(5′-methyl-[2,2′-bipyridine]-5-yl)acetic acid) for effectively utilizing its light-harvesting properties toward photocatalytic CO 2 reduction. The confinement of the TET molecules as a photosensitizer and the covalent grafting of a catalytically active [Re(MBA)(CO) 3 Cl] complex, postsynthetically, result in a single integrated catalytic system named Zr-MBA-TET-Re-MOF. Photoreduction of CO 2 over Zr-MBA-TET-Re-MOF showed the evolution of 805 μmol g −1 CO with 99.9% selectivity after 10 h of continuous visible light irradiation in water without any additional sacrificial electron donor and having the apparent quantum efficiency of 1.3%. In addition, the catalyst demonstrated an appreciable activity even under direct sunlight irradiation in aqueous medium with a maximum production of 362.7 μmol g −1 CO, thereby mimicking artificial photosynthesis. Moreover, electron transfer from TET to the catalytic center was supported by the formation of photoinduced TET radical cation, as inferred from in situ UV−vis spectra, electron paramagnetic resonance (EPR) analysis, and transient absorption (TA) studies. Additionally, the in situ diffuse reflectance infrared Fourier transform (DRIFT) measurements support that the photoreduction of CO 2 to CO proceeds via *COOH intermediate formation.The close proximity of the light-harvesting molecule and catalytic center facilitated facile electron transfer from the photosensitizer to the catalyst during the CO 2 reduction.