According to the European Commission, in 2016 the residential sector represented 25.4% of the final energy consumption. Heating and cooling in EU households account for 69.1% of the total energy consumption. The fraction of 84% for heating and cooling is still generated from fossil fuels, and only 16% is generated from renewable energy. To decrease carbon dioxide emissions of fossil fuel consumption, it is crucial to find alternatives to supply the heating and cooling demand. Alternatives such as adsorption-based heat pumps and desiccant cooling systems are receiving much attention because of their moderate energy consumption. These systems are based on the energetic exchange during the adsorption/desorption of working fluids. In this work, we combined experiments and simulations to evaluate the viability of several zeolites and MOFs with water for cooling systems applications. We combined the study of adsorption mechanisms and the dynamics of water inside the pores of the structures, thereby obtaining an overall understanding of the working pair. We found that the Al content in FAU-topology zeolites is a key factor for an efficient process. We also identify ZJNU-30 metal-organic framework as a suitable candidate for cooling applications because of its outstanding water capacity, cooling capacity, and coefficient of performance.