This study successfully prepared different loading levels of cyano-functionalized RCC3 molecular cage silica gel stationary phase (RCC3-CN@SiO2) through aldehyde-amine condensation reaction and subsequent modification strategies. Fourier transform infrared spectroscopy, thermogravimetric analysis, nitrogen adsorption-desorption, and scanning electron microscopy confirmed the successful synthesis of RCC3-CN@SiO2 chromatographic stationary phase. The research demonstrates that due to hydrophobic/hydrophilic interactions, π-π interactions, hydrogen bonding, and size-selective porous structure, the stationary phase effectively separates moderately polar and weakly polar compounds in reversed-phase liquid chromatography (RPLC) mode, exhibiting hydrophobic selectivity comparable to the commercial DaisoC18-RP columns. Additionally, the tertiary amine and cyanogen groups on the molecular cage surface enhance the interaction with polar compounds, successfully separating nucleosides, sulfonamides, amino acids, and sugars in hydrophilic interaction chromatography (HILIC) mode. Further applications in the separation analysis of acidic drugs, alkaline drugs, cinnamic acid natural products, and chiral compounds demonstrate the multifunctional chromatographic capabilities for diverse compound types. Compared to Unitary Diol commercial columns, the prepared stationary phase showed significant advantages in wide polarity range separation performance. Moreover, through nucleoside compound separation mode switching analysis, RCC3-CN@SiO2 stationary phase further validates its favorable performance in both RPLC and HILIC modes, demonstrating extensive potential applications in the field of analytical chemistry. Importantly, the stationary phase exhibits efficient separation of nucleoside compounds in pure water systems, aligning with the principles of green analysis.