Ceramic membranes have been increasingly employed in water treatment owing to their merits such as high-stability, anti-oxidation, long lifespan and environmental friendliness. The application of ceramic membranes mainly focuses on microfiltration and ultrafiltration processes, and some precise separation can be achieved by introducing novel porous materials with superior selectivity. Recently, metal–organic frameworks (MOFs) have developed a wide spectrum of applications in the fields of the environment, energy, water treatment and gas separation due to the diversity and tunable advantages of metal clusters and organic ligands. Although the issue of water stability in MOF materials inhibits the development of MOF membranes in water treatment, researchers still overcome many obstacles to advance the application of MOF membranes in water treatment processes. To the best of our knowledge, there is still a lack of a reviews on the development process and prospects of ceramic-based MOF membranes for water treatment. Therefore, in this review, we mainly summarize the fabrication method for ceramic-based MOF membranes and their application in water treatment, such as water/salt separation, pollutant separation, heavy metal separation, etc. Following this, based on the high structural, thermal and chemical stability of ceramic substrates, and the high controllability of MOF materials, the superiority and insufficient use of ceramic-based MOF membranes in the field of water treatment are critically discussed.