Mushroom dendritic spine structures are essential for memory storage and the loss of mushroom spines may explain memory defects in aging and Alzheimer's disease (AD). The stability of mushroom spines depends on stromal interaction molecule 2 (STIM2)-mediated neuronal-store-operated Ca influx (nSOC) pathway, which is compromised in AD mouse models, in aging neurons, and in sporadic AD patients. Here, we demonstrate that the Transient Receptor Potential Canonical 6 (TRPC6) and Orai2 channels form a STIM2-regulated nSOC Ca channel complex in hippocampal mushroom spines. We further demonstrate that a known TRPC6 activator, hyperforin, and a novel nSOC positive modulator, NSN21778 (NSN), can stimulate activity of nSOC pathway in the spines and rescue mushroom spine loss in both presenilin and APP knock-in mouse models of AD. We further show that NSN rescues hippocampal long-term potentiation impairment in APP knock-in mouse model. We conclude that the STIM2-regulated TRPC6/Orai2 nSOC channel complex in dendritic mushroom spines is a new therapeutic target for the treatment of memory loss in aging and AD and that NSN is a potential candidate molecule for therapeutic intervention in brain aging and AD. Mushroom dendritic spine structures are essential for memory storage and the loss of mushroom spines may explain memory defects in Alzheimer's disease (AD). This study demonstrated that Transient Receptor Potential Canonical 6 (TRPC6) and Orai2 form stromal interaction molecule 2 (STIM2)-regulated neuronal-store-operated Ca influx (nSOC) channel complex in hippocampal synapse and the resulting Ca influx is critical for long-term maintenance of mushroom spines in hippocampal neurons. A novel nSOC-positive modulator, NSN21778 (NSN), rescues mushroom spine loss and synaptic plasticity impairment in AD mice models. The TRPC6/Orai2 nSOC channel complex is a new therapeutic target and NSN is a potential candidate molecule for therapeutic intervention in brain aging and AD.