Magnetic and superconducting ground states can compete, cooperate and coexist. MnP provides a compelling and potentially generalizable example of a material where superconductivity and magnetism may be intertwined. Using a synchrotron-based non-resonant X-ray magnetic diffraction technique, we reveal a spiral spin order in MnP and trace its pressure evolution towards superconducting order via measurements in a diamond anvil cell. Judging from the magnetostriction, ordered moments vanish at the quantum phase transition as pressure increases the electron kinetic energy. Spins remain local in the disordered phase, and the promotion of superconductivity is likely to emerge from an enhanced coupling to residual spiral spin fluctuations and their concomitant suppression of phonon-mediated superconductivity. As the pitch of the spiral order varies across the 3d transition metal compounds in the MnP family, the magnetic ground state switches between antiferromagnet and ferromagnet, providing an additional tuning parameter in probing spin-fluctuation-induced superconductivity.