We perform experimental studies of resonantly enhanced sum-frequency mixing (SFM), driven by tunable, spectrally narrowband mid-infrared and fixed-frequency nanosecond laser pulses, aiming at applications in molecular gas detection. The mid-infrared pulses are tuned in the vicinity of two-photon rovibrational transitions in the electronic ground state to provide strong resonance enhancements of the nonlinear susceptibility, while a probe laser at shorter wavelength uses an off-resonant single-photon coupling to excited electronic states. This SFM approach benefits from the advantageous combination of typically small detunings among the mid-infrared, vibrational transitions and the typically large transition dipole moment for couplings of electronic states. Moreover, compared to resonantly enhanced third harmonic generation (THG), a signal wave at much shorter wavelength permits simple and efficient detection. We demonstrate resonantly enhanced SFM via rovibrational states in gaseous hydrogen chloride molecules and compare its features to THG. The SFM spectra offer a large signal-to-noise ratio of 4 orders of magnitude and a detection limit down to a pressure of 0.1 mbar, corresponding to a particle density of 0.35 × 10 15 per cm 3 .