It is crucial to precisely construct metal-organic framework (MOF) sub-nanochannels at the tip of micro/nanopipettes for fundamental research and sensing applications. The quality of the MOF modification plays a significant role in influencing subsequent research, particularly in sensing applications. In this work, we present a precise method of constructing MOF sub-nanochannels at the tip of glass micropipettes, which serve as a universal aptamer-based sensing platform for the selective detection of proteins. In situ scanning electron microscopy (SEM), energy-dispersive spectroscopy (EDS) mapping, and fluorescence microscopy results demonstrate that the synthesized MOF (UiO-66) nanocrystals fully block the orifice of glass micropipettes (UiO-66-GMs) without forming any nanometer-scale cracks and remain confined within the geometric boundaries of the orifice. The terminal phosphate-modified aptamer readily binds to the surface of UiO-66-GMs through metal (Zr)-phosphate coordination, ultimately forming the aptamer sensor (Apt-UiO-66-GMs). The selective quantification of proteins is achieved via a decrease in current resulting from protein binding to the aptamer. Our results indicate that the precisely constructed Apt-UiO-66-GMs sensor enables highly selective and sensitive detection of SARS-CoV-2 nucleocapsid protein and holds potential for real sample detection. Furthermore, given the sharp tip of the micropipets and the external sensing interface we have constructed, our aptamer-based sensing platform also opens avenues for single-cell analysis and in vivo sensing.