Transdermal drug delivery is of vital importance for medical treatments. However, user adherence to long-term repetitive drug delivery poses a grand challenge. Furthermore, the dynamic and unpredictable disease progression demands a pharmaceutical treatment that can be actively controlled in real-time to ensure medical precision and personalization. Here, we report a spatiotemporal on-demand patch (SOP) that integrates drug-loaded microneedles with biocompatible metallic membranes to enable electrically triggered active control of drug release. Precise control of drug release to targeted locations (<1 mm²), rapid drug release response to electrical triggers (<30 s), and multi-modal operation involving both drug release and electrical stimulation highlight the novelty. Solution-based fabrication ensures high customizability and scalability to tailor the SOP for various pharmaceutical needs. The wireless-powered and digital-controlled SOP demonstrates great promise in achieving full automation of drug delivery, improving user adherence while ensuring medical precision. Based on these characteristics, we utilized SOPs in sleep studies. We revealed that programmed release of exogenous melatonin from SOPs improve sleep of mice, indicating potential values for basic research and clinical treatments.