Single-atom catalysts (SACs), due to their maximum atomic utilization rate, show tremendous potential for application in the electrocatalytic synthesis of ammonia from nitrate. Yet, the development of superior supports that preserve the high selectivity, activity, and stability of SACs remains an imperative challenge. In this work, based on first-principles calculations and tight-binding (TB) model analysis, a new two-dimensional (2D) carbon nitride monolayer, C7N6, is proposed. The C7N6 structure exhibits a strong covalent network, with dynamical, thermal, and mechanical stability. Surprisingly, the structural transition from C9N4 to C7N6 corresponds to a semimetallic state transition. Further symmetry analysis unveils that the Dirac states in C7N6 are protected by space–time inversion symmetry, and the physical origin of the Dirac cone was confirmed using the TB model. Additionally, a non-zero Z2 invariant and significant topological edge states demonstrate its topologically nontrivial nature. Considering the excellent structural and topological properties of C7N6, a three-step screening strategy is designed to identify eligible SACs for electrochemical nitrate reduction reaction (NO3RR), and Ti@C7N6 is identified as possessing the best activity, with the last proton-electron coupling step *NH2→*NH3 being the potential-determining step (PDS), for which the limiting potential is 0.48 V. Moreover, a free energy diagram shows that the *NOH reaction pathway is energetically preferred on Ti@C7N6, and ab initio molecular dynamics (AIMD) calculations at 500 K confirm its good thermal stability. Our study not only provides excellent CN-based support material but also offers theoretical guidance for constructing highly active and selective SACs for nitrate reduction.