For Maine:
Maine's Prescription Monitoring Program (PMP) is a tool created to prevent and detect prescription drug misuse and diversion, and improve patient care through better coordination of care. PMP maintains a database of all transactions for schedule II, III and IV controlled substances dispensed in the State of Maine. This database is available free online to prescribers and dispensers by the Office of Substance Abuse and Mental Health Services (SAMHS) in the Maine Department of Health and Human Services. Anyone with a DEA number is encouraged to register to request patient reports. The database is searchable online, so it is available anywhere one has Internet access. Clinicians can use the program to check the history of a new patient and to monitor on-going treatment. PMP is another tool clinicians can add to their toolkit for preventing and intervening against misuse and diversion of prescription drugs.
So it looks like it is not a mandate for you in Maine.