Elevated levels of prostaglandin E2 have been implicated in the pathophysiology of various diseases. Anti-inflammatory drugs that act through the inhibition of cyclooxygenase enzymatic activity, thereby leading to the suppression of prostaglandin E2, are often associated with several side effects due to their non-specific inhibition of cyclooxygenase enzymes. Consequently, the targeted suppression of prostaglandin E2 production with innovative molecules and/or mechanisms emerges as a compelling therapeutic strategy for the treatment of inflammatory-related diseases. Therefore, in this study, a systematic analysis of 28 pyrazole derivatives was conducted to explore their potential mechanisms for reducing prostaglandin E2 levels. In this context, the evaluation of these derivatives extended to examining their capacity to reduce prostaglandin E2 in vitro in human whole blood, inhibit cyclooxygenase-1 and cyclooxygenase-2 enzymes, modulate cyclooxygenase-2 expression, and suppress oxidative burst in human leukocytes. The results enabled the establishment of significant structure-activity relationships, elucidating key determinants for their activities. In particular, the 4-styryl group on the pyrazole moiety and the presence of chloro substitutions were identified as key determinants. Pyrazole 8 demonstrated the capacity to reduce prostaglandin E2 levels by downregulating cyclooxygenase-2 expression, and pyrazole-1,2,3-triazole 18 emerged as a dual-acting agent, inhibiting human leukocytes’ oxidative burst and cyclooxygenase-2 activity. Furthermore, pyrazole 26 demonstrated effective reduction of prostaglandin E2 levels through selective cyclooxygenase-1 inhibition. These results underscore the multifaceted anti-inflammatory potential of pyrazoles, providing new insights into the substitutions and structural frameworks that are beneficial for the studied activity.