Little is known about the metabolomic profile of quercetin and its biological effects. This study aimed to determine the biological activities of quercetin and its metabolite products, as well as the molecular mechanisms of quercetin in cognitive impairment (CI) and Parkinson's disease (PD). Key methods used were MetaTox, PASS Online, ADMETlab 2.0, SwissADME, CTD MicroRNA MIENTURNE, AutoDock, and Cytoscape. A total of 28 quercetin metabolite compounds were identified by phase I reactions (hydroxylation and hydrogenation reactions) and phase II reactions (methylation, O-glucuronidation, and O-sulfation reactions). Quercetin and its metabolites were found to inhibit cytochrome P450 (CYP) 1A, CYP1A1, and CYP1A2. The studied compounds demonstrated significant gastrointestinal absorption and satisfied Lipinsky's criterion. Due to their high blood-brain barrier permeability, P-glycoprotein inhibition, anticancer, anti-inflammatory, and antioxidant capabilities, quercetin and its metabolite products have been proposed as promising molecular targets for the therapy of CI and PD. By regulating the expression of crucial signaling pathways [mitogen-activated protein kinase (MAPK) signaling pathway, and neuroinflammation and glutamatergic signaling], genes [brain derived neurotrophic factor (BDNF), human insulin gene (INS), and dopamine receptor D2 (DRD2), miRNAs (hsa-miR-16-5p, hsa-miR-26b-5p, hsa-miR-30a-5p, hsa-miR-125b-5p, hsa-miR-203a-3p, and hsa-miR-335-5p], and transcription factors [specificity protein 1 (SP1), v-rel avian reticuloendotheliosis viral oncogene homolog A (RELA), and nuclear factor Kappa B subunit 1 (NFKB1)], quercetin exhibited its neurotherapeutic effects in CI and PD. In addition to inhibiting β-N-acetylhexosaminidase, quercetin also showed robust interactions and binding affinities with heme oxygenase 1 (HMOX1), superoxide dismutase 2 (SOD2), tumor necrosis factor (TNF), nitric oxide synthase 2 (NOS2), brain-derived neurotrophic factor (BDNF), INS, DRD2, and γ-aminobutyric acid type A (GABAa). This study identified 28 quercetin metabolite products. The metabolites have similar characteristics to quercetin such as physicochemical properties, absorption, distribution, metabolism, and excretion (ADME), and biological activities. More research, especially clinical trials, is needed to find out how quercetin and its metabolites protect against CI and PD.