Newly synthesized Zn(II) and Cd(II)-based complexes show unique selectivity towards inorganic pyrophosphate (PPi) in 100% aqueous medium at pH = 7.4 and act as a "turn-on" and "turn-off" real-time assay, respectively, for the evaluation of the enzymatic activity of alkaline phosphatase.