In spite of the fact that loose nanofiltration membrane (LNFM) technology has certified inspiring prospects in the remediation of dyestuff-comprising wastewater, omnipresent membrane fouling deteriorates its separation competence and hinders its practical application. Herein, a neoteric LNFM with finely tuned anti-fouling and self-cleaning properties was manufactured via the reformative phase inversion procedure integrated with the correctional interfacial polymerization process. By altering the casting solution (i.e., adding nano additives) and coagulation bath (i.e., applying melamine aqueous solution rather than pure water) recipes, the porphyrin-based covalent organic framework (COF-366) and melamine monomers were introduced into the polymeric matrix ingeniously in one step, participating the subsequent interfacial polymerization reaction straightly. The COF-366 with photocatalytic degradation performance and hydrophilicity bestows the resultant LNFM with superior decomposing capacity for organic micro-pollutants under visible light irradiation and better operation durability. Moreover, this substrate-confined amine diffusion combined with the high polarity of melamine enables the formation of a thinner nanofilm for easy mass transport. The best-performing LNFM invented in this work exhibited a high water permeance up to 65 L m−2 h−1 bar−1, excellent dye retention (95.7% against methyl blue), and salt/dye discrimination (27.1 for methyl blue and Na2SO4 selectivity) abilities. Eventually, the membrane could recover to original separation efficacy after the cyclic degradation testing. Overall, this work demonstrates an extensive perspective to pioneer an advanced self-cleaning membrane for dye/salt fractionation.