Five molecular complexes with different non-noble metal centers were synthesized. The Co-based complex displays the highest photocatalytic performance for CO2 to CO conversion in aqueous media. It achieves high activity (TON = 41 017 and TOF = 3.80 s-1) and selectivity (87%) for the production of CO.