Olivine minerals possess significant potential for CO2 sequestration through carbonation reactions, with their reactivity highly influenced by cation composition. This study employs first-principles calculations to systematically investigate the impact of metal cations (Mg2+, Ca2+, Mn2+, Fe2+, Co2+) on the carbonation behavior of five olivine structures: forsterite (Mg2SiO4), calcio-olivine (γ-Ca2SiO4), tephroite (α-Mn2SiO4), fayalite (α-Fe2SiO4), and Co-olivine. Analyses of bond characteristics, total bond order density, and local density of states reveal fundamental differences between alkaline earth and transition metal olivines. We have found that in alkaline earth (AE) olivines, carbonation primarily involves an electrophilic attack of O2− by H+ and a nucleophilic attack of metal cations by HCO3−/CO32− species. Calcio-olivine exhibits higher reactivity than forsterite due to enhanced Ca2+ nucleophilicity. Conversely, transition metal (TM) olivine reactivity is governed by the multivalent cations, contributing significantly to both electrophilic and nucleophilic pathways. Considering both mineral reserves and carbonation reaction mechanisms, calcio-olivine is determined to be the most advantageous among the five olivine minerals in terms of carbonation reactivity. This atomic-scale understanding guides the development of olivine-based materials with improved carbonation performance for efficient CO2 sequestration and utilization in carbon capture, utilization, and storage technologies.