Ceramic membranes are a promising alternative to polymeric membranes for selective separations, given their ability to operate under harsh chemical conditions. However, current fabrication technologies fail to construct ceramic membranes suitable for selective molecular separations. Herein, we demonstrate a molecular-level design of ceramic thin-film composite membranes with tunable subnanometer pores for precise molecular sieving. Through burning off the distributed carbonaceous species of varied dimensions within hybrid aluminum oxide films, we created membranes with tunable molecular sieving. Specifically, the membranes created with methanol showed exceptional selectivity toward monovalent and divalent salts. We attribute this observed selectivity to the dehydration of the large divalent ions within the subnanometer pores. As a comparison, smaller monovalent ions can rapidly permeate with an intact hydration shell. Lastly, the flux of neutral solutes through each fabricated aluminum oxide membrane was measured for the demonstration of tunable separation capability. Overall, our work provides the scientific basis for the design of ceramic membranes with subnanometer pores for molecular sieving using atomic layer deposition.