Aquaporin 9 (AQP9), as an aquaglyceroporin, is expressed in many immune cells and plays important role in tumor initiation and progression. However, the relationship between AQP9 and tumor-infiltrating cells, and its prognostic value in cancers still require comprehensive understanding. Herein, we aimed to elucidate the correlations of AQP9 with prognosis and immune infiltration levels in diverse cancers. We detected the expression and survival data of AQP9 through Oncomine, TIMER, Kaplan–Meier Plotter and PrognoScan databases. The correlations between AQP9 and immune infiltrates were analyzed in TIMER database. Our results found that high AQP9 expression was significantly correlated with worse prognosis in breast, colon and lung cancers, while predicted better prognosis in gastric cancer. Moreover, AQP9 had significant association with various immune infiltrating cells including CD8+ and CD4+ T cells, neutrophils, macrophages and dendritic cells (DCs), and diverse immune gene markers in BRCA, COAD, LUAD, LUSC and STAD. AQP9 was also significantly correlated with the regulation of tumor associated macrophages (TAM). These results indicate that AQP9 can play as a significant biomarker to determine the prognosis and the immune infiltrating levels in different cancers. It might also contribute to the development of the immunotherapy in breast, colon, lung and gastric cancers.