Water scarcity in arid regions has become an urgent global challenge, highlighting the need for efficient freshwater production technologies. Sorption-based atmospheric water harvesting (SAWH) offers a promising approach, with its core relying on high-performance sorbents and practical device design. Among various candidates, metal-organic frameworks (MOFs) attracted considerable attention, but biocompatibility is essential for drinking water collection. This requirement motivates the investigation of cyclodextrin-based MOFs (CD-MOFs), which feature green synthesis, non-toxicity, and even digestibility. Herein, three CD-MOFs (alpha-CD-Na, beta-CD-K, and gamma-CD-K) were synthesized and systematically evaluated, revealing beta-CD-K as the most promising SAWH sorbent. It exhibits an almost S-shaped water sorption isotherm, relatively high water uptake, robust structural stability, and the potential for scalable preparation. We further investigated its water adsorption mechanism and identified optimal operating conditions. Finally, a portable, sunlight-driven SAWH device was designed to harvest freshwater under real outdoor conditions. Under identical conditions, beta-CD-K produced 12.5 mL of water, equal to 0.47 L & sdot;kg-1 per day. This offers valuable insights for the design of portable water collection devices.