We aimed to confirm the inhibitory effect of nicotinamide on fibrotic scar formation following spinal cord injury in mice using functional metabolomics. We proposed a novel functional metabolomics strategy to establish correlations between gene expression changes and metabolic phenotypes using integrated multi-omics analysis. Through the integration of quantitative metabolites analysis and assessments of differential gene expression, we identified nicotinamide as a functional metabolite capable of inhibiting fibrotic scar formation and confirmed the effect invivo using a mouse model of spinal cord injury. Furthermore, to mimic fibrosis models invitro, primary mouse embryonic fibroblasts and spinal cord fibroblasts were stimulated by TGFβ, and the influence of nicotinamide on TGFβ-induced fibrosis-associated genes and its underlying mechanism were examined. Administration of nicotinamide led to a reduction in fibrotic lesion area and promoted functional rehabilitation following spinal cord injury. Nicotinamide effectively downregulated the expression of fibrosis genes, including Col1α1, Vimentin, Col4α1, Col1α2, Fn1, and Acta2, by repressing the TGFβ/SMADs pathway. Our functional metabolomics strategy identified nicotinamide as a metabolite with the potential to inhibit fibrotic scar formation following SCI by suppressing the TGFβ/SMADs signaling. This finding provides new therapeutic strategies and new ideas for clinical treatment.