Effective transfection of genetic molecules such as DNA usually relies on vectors that can reversibly uptake and release these molecules, and protect them from digestion by nuclease. Non-viral vectors meeting these requirements are rare due to the lack of specific interactions with DNA. Here, we design a series of four isoreticular metal-organic frameworks (Ni-IRMOF-74-II to -V) with progressively tuned pore size from 2.2 to 4.2 nm to precisely include single-stranded DNA (ssDNA, 11–53 nt), and to achieve reversible interaction between MOFs and ssDNA. The entire nucleic acid chain is completely confined inside the pores providing excellent protection, and the geometric distribution of the confined ssDNA is visualized by X-ray diffraction. Two MOFs in this series exhibit excellent transfection efficiency in mammalian immune cells, 92% in the primary mouse immune cells (CD4+ T cell) and 30% in human immune cells (THP-1 cell), unrivaled by the commercialized agents (Lipo and Neofect).