Detecting and monitoring toxic contaminants such as CrO42–, Cr2O72–, and tetracycline in water is critical due to their harm to biological and environmental systems; thus their trace-level detection has emerged as an important area of research. A family of heterometallic Cd–alkaline earth metal MOFs with formulas {[MCd(tpta)(H2O)]·2H2O}n (M = Mg, Ca, and Sr) based on π-conjugated 2,2′,4,4′-terphenyltetracarboxylic acid (H4tpta) was synthesized and characterized. The structures feature 3D porous frameworks constructed from heteronuclear {MCdO2}n chains bridged by tpta4− ligands, which retain their structural integrity under harsh acidic and basic conditions (pH 2–13). These MOFs exhibit strong blue solid-state luminescence that increases with the ionic radius of the alkaline earth metal. Among them, the representative CaII-CdII-2 shows selective luminescence quenching toward Cr2O72–, CrO42–, and oxytetracycline (OTC) in aqueous solutions. It exhibits excellent linearity in the concentration range of 2–40 μM with low detection limits of 1.575, 1.467, and 0.954 μM, respectively. The quenching efficiency remains unaffected by interfering species and is stable over multiple cycles, highlighting good reliability and recyclability. Comprehensive spectral analyses demonstrate that the turn-off response of CaII-CdII-2 toward Cr(VI) oxo-anions involves both IFE and static quenching, whereas OTC-induced quenching is dominated by static quenching via ground-state complex formation, potentially assisted by IFE. This work demonstrates the potential of heterometallic Cd–alkaline earth metal MOFs as microporous materials with accessible metal centers for effective luminescent sensing.