In this research, the development of new boronic acid-functionalized porphyrin-based metal-organic frameworks (MOFs) involves a crucial step: achieving efficient grafting of boric acid groups onto the MOF structures through post-modification strategy. First, the basic organic framework, with porphyrin as the core, is constructed (PCN224). Subsequently, 3-aminophenylboric acid is precisely grafted onto the pore surface of the MOF (BA-PCN-224) via a clever coupling reaction utilizing a post-modification strategy. This method not only preserves the original high specific surface area and porosity of PCN-224 but also imparts a unique and highly selective affinity for adenosine. Various characterization techniques, including FT-IR, XPS, XRD, TGA, SEM, and elemental analysis, were employed to analyze BA-PCN-224. The BA-PCN-224 demonstrated remarkable efficiency in removing adenosine from urine, primarily due to the specific interaction between the borate groups and the cis-dihydroxyl group of adenosine molecules. Experimental findings indicated that the adenosine removal rate in urine reached an impressive 96.19 %. Under optimal conditions, a DSPE-HPLC method for the determination of adenosine in urine sample is successfully established, with the LOD as low as 0.003 mu g mL-1, and the relative recovery ranging from 94.60 % to 102.84 %. In addition, after evaluation by GAPI, Complex GAPI, AGREE and AGREEprep metrics tools, the results show that the method has good greenness and applicability. Additionally, the application range of BA-PCN-224 has expanded to water treatment, where it achieved a high dye removal rate of 97.34 %, contributing positively to environmental protection and advancements in water treatment technologies.