While numerous genomic loci have been identified for neuropsychiatric conditions, the contribution of protein-coding variants has yet to be determined. Here we conducted a large-scale whole-exome-sequencing study to interrogate the impact of protein-coding variants on 46 neuropsychiatric diseases and 23 traits in 350,770 adults from the UK Biobank. Twenty new genes were associated with neuropsychiatric diseases through coding variants, among which 16 genes had impacts on the longitudinal risks of diseases. Thirty new genes were associated with neuropsychiatric traits, with SYNGAP1 showing pleiotropic effects across cognitive function domains. Pairwise estimation of genetic correlations at the coding-variant level highlighted shared genetic associations among pairs of neurodegenerative diseases and mental disorders. Lastly, a comprehensive multi-omics analysis suggested that alterations in brain structures, blood proteins and inflammation potentially contribute to the gene-phenotype linkages. Overall, our findings characterized a compendium of protein-coding variants for future research on the biology and therapeutics of neuropsychiatric phenotypes.