A unique synthetic pathway consisting of many steps was devised for the synthesis of a range of pyrazole derivatives, which were subsequently characterised based on their chemical structures. The experimental procedure involved a series of sequential reactions utilising Meldrum acid, HATU, and DIPEA. These reactions led to the synthesis of a range of compounds exhibiting distinct characteristics and demonstrating promising prospects for utilisation within the domain of organic chemistry. This study presents a comprehensive dataset comprising detailed spectral and biological examination of ten chemicals, denoted as B6 to B10. The compounds in question have been subjected to characterization through the utilisation of infrared spectroscopy (IR), nuclear magnetic resonance (NMR), and mass spectrometry techniques. Additionally, their antibacterial and anticancer properties have been assessed. The nuclear magnetic resonance (NMR) spectra of compounds B6 to B10 were analysed. The nuclear magnetic resonance (NMR) spectra of each substance exhibit the chemical shifts of different proton and carbon signals. Theoretical and actual mass spectra are shown for each molecule. The measured masses exhibit a high degree of proximity to the corresponding theoretical masses, hence suggesting the precise synthesis of the compounds. The antibacterial properties of compounds B6 to B10 were assessed against Bacillus subtilis, Staphylococcus aureus, Escherichia coli, and Aspergillus Niger. The findings are presented in the tabular format, displaying the zone of inhibition measurements in millimetres. The present study aimed to assess the impact of vitamin B6 to B10 on the MCF-7 cell line, which is commonly associated with breast cancer, utilising the MTT assay technique. The obtained outcomes encompass measurements of concentration, absorbance, percentage of inhibition, and IC50 values.