A unique Schiff base ligand (BCA), 4-(2-((1E,2E)-1-(2-(p-tolyl)hydrazono)propan-2-ylidene)hydrazinyl)quinazoline, was synthesized and complexed with Mn [II], Co [II], Cu [II, and Cd [II] ions, with 1,10-Phenanthroline (PHN) as an auxiliary ligand. The unique Schiff base ligand BCA and its metal complexes were characterized using multiple analytical techniques, including elemental analysis, UV–visible spectroscopy, FT-IR, mass spectrometry, and conductometric measurements. These methods provided detailed insights into the compounds’ structural and electronic properties. Density Functional Theory (DFT) computations complemented the experimental data, elucidating electronic configuration stability, HOMO-LUMO energy gaps, chemical hardness, and dipole moments. The computational results confirmed the distorted octahedral structure of the complexes. Antimicrobial testing against various bacterial and fungal strains revealed that the Cd (II) complex exhibited the highest activity, with inhibition zones ranging from 19.7 ± 0.6 mm to 35.0 ± 1.0 mm, surpassing the activity of standard antibiotics in some cases. Notably, the compounds displayed significant efficacy against Helicobacter pylori, with the Cd (II) complex showing an inhibition zone of 32.67 ± 0.58 mm and a minimum inhibitory concentration (MIC) of 7.8 μg/ml. Anticancer properties were evaluated against MCF-7 (Breast carcinoma) cells, with the [(BCA)(PHN)Cd(H2O)].2Cl·2H2O complex demonstrating superior activity (IC50 = 29.97 μg/ml) compared to the free ligand (IC50 = 183.96 μg/ml) and other metal complexes. Notably, the Cd(II) complex showed reduced cytotoxicity towards normal VERO cells, suggesting potential selectivity for cancer cells. Molecular docking simulations evaluated the complexes’ binding interactions with protein targets associated with Helicobacter pylori, MCF cancer cells, and the COVID-19 virus. The main objective of this research was to design and synthesize a unique Schiff base ligand and its new corresponding Ternary metal complexes and then investigate their potential medical applications. Specifically, the study aimed to evaluate the compounds’ effectiveness as antibiotics, antitumor agents, and possible treatments for COVID-19.