Single crystals of a new organic–inorganic hybrid compound (C3H7N6)2[ZnCl4]·H2O was synthesized and characterized by X-ray diffraction at room temperature, FT-IR and FT-Raman spectroscopies, optical absorption and photoluminescence behavior. The title compound belongs to the triclinic space group P1¯, and in the crystal structure, the inorganic layers are built from tetrachloridozincate anions [ZnCl4]2− and free water molecules, linked together by O–H···Cl hydrogen bonds and halogen···halogen interactions. In addition, Hirshfeld surfaces and 2D fingerprint plots estimate the weak intermolecular interactions accountable for the generation of crystal packing. The optimized geometry, vibrational frequencies and various thermodynamic parameters of the title compound calculated using density functional theory (DFT) methods are in agreement with the experimental values. The theoretical calculations were performed using the DFT method at WB97XD/Lanl2dz basis set levels and we discussed topological analysis of atoms in molecules (AIM) at the BCP point. A detailed interpretation of the IR and Raman spectra were reported. Additionally, the simulated spectrum satisfactorily coincided with the experimental UV-Visible spectrum. A wide band gap exceeding 4 eV of the synthesized compound was recorded. The photoluminescence (PL) was characterized through two bands successively at 453 and 477 nm. Ultimately, antimicrobial activity and enzymatic inhibition assays of the complex were also investigated through microbial strains, agar diffusion method, minimum inhibitory concentration (MIC) determination, lipase and phospholipase A2 inhibition.