Five- and six-membered heterocycles containing nitrogen or oxygen have been considered as privileged scaffolds in organic chemistry and the chemical industry because of their usage in high-value commodities. Herein, we report a two-dimensional (2D) Cu(II)-based MOF catalyst, IITKGP-40, via the strategic employment of ample Lewis acid-base bifunctional sites (open metal nodes and free pyrazine moieties) along the pore wall. IITKGP-40 could convert toxic CO2 to cyclic carbonates in an atom-economical manner under solvent-free conditions and aromatic aldehyde to bioactive 1,4-DHPs via Hantzsch condensation. Exceptional catalytic performance (99%) and turnover number under mild reaction conditions for CO2 fixation using sterically hindered styrene oxide, and good-to-excellent yields for a wide range of aromatic aldehydes toward 1,4-dihydropyridines (1,4-DHPs) make IITKGP-40 promising as a multipurpose heterogeneous catalyst. Moreover, to demonstrate the practical utility of the catalyst, two biologically important drug molecules, diludine and nitrendipine analogue, have also been synthesized. IITKGP-40 is recyclable for at least three consecutive runs without significant loss of activity, making it promising for real-time applications.