The preservation of freshwater resources in arid and semi-arid regions, which is crucial for sustainable development, depends heavily on the identification and management of the groundwater quality. Local authorities and water resource managers might divide the use of resources between agricultural and drinking purposes depending on the quality of the groundwater in different places. In the Tabriz aquifer, which is situated in the province of East Azerbaijan, northwest Iran, this study seeks to pinpoint regions where water pumping is appropriate for harvesting and use for drinking. A groundwater compatibility study was carried out using data from 39 wells collected between 2003 and 2014, including electrical conductivity (EC), total dissolved solids (TDS), chloride (Cl), calcium (Ca), magnesium (Mg), sodium (Na), potassium (K), sulphate (SO4), total hardness (TH), bicarbonate (HCO3), pH, carbonate (CO3), and sodium adsorption ratio (SAR). Due to their significant significance in determining the quality of water resources for irrigation and drinking, the Water Quality Index (WQI) and Irrigation Water Quality (IWQ) indexes are used in conjunction with one another. Water was zoned as excellent, good, or bad according to the WQI index for drinking water. The research comes to the conclusion that the majority of drinking water gathered for urban and rural regions is "excellent water" or "good water".