Melatonin, which is classified as a dietary supplement by the Saudi Food and Drug Authority, is used to manage sleep disorders. In this study, community pharmacists’ knowledge and attitudes about dispensing melatonin supplements and the perceived safety and effectiveness of melatonin were assessed. A cross-sectional survey of community pharmacists in Jeddah, Saudi Arabia was conducted from March–June 2023. Community pharmacists’ knowledge and attitudes towards prescribing and dispensing melatonin supplements, the methods of dispensing melatonin supplements (prescription, over the counter, self-administered), indications, ages of users, dosage forms, and adverse drug reactions related to melatonin use among consumers were surveyed using a questionnaire. Potential participants were approached face to face, a questionnaire was administered to those agreeing to participate in the study, and responses were recorded electronically. The response rate of the 300 community pharmacists who participated in this study was 83.5%. The mean age of participants was 33.6 years, and 89.3% (n = 268) of community pharmacists reported dispensing melatonin supplements. Self-medication and over the counter (n = 213; 71.2%) were the most common dispensing and prescribing patterns (p = 0.001). Awareness rates about melatonin supplement pharmacokinetics and pharmacodynamics among community pharmacists were 38% and 37%, respectively. Despite its popularity, community pharmacists reported relatively low rates of awareness of melatonin supplement pharmacokinetics and pharmacodynamics. Further attention to this issue is needed.