Any process that activates or increases the frequency, rate or extent of a small molecule metabolic process.