Any process that stops, prevents or reduces the frequency, rate or extent of a small molecule metabolic process.