Objectives Recent years have seen a significant evolution in the understanding pertaining to mental health issues. The analysis of the intricate interplay between an individual’s sociodemographic factors, genetic makeup, the environment, and clinical profile (diagnosis and treatment) of patients will help us understand the prevalence and types of mental health disorders prevalent in Assam, which is a culturally, ethnically and socially diverse state. The pattern of utilization of electroconvulsive therapy has also been analyzed. The aims and objectives of the study is to analyze the sociodemographic characteristics and clinical profile of patients admitted in Psychiatry ward, Assam Medical College and Hospital. Material and Methods An analysis on the case records of all individuals admitted to the hospital’s Psychiatry ward between August 1, 2022 and July 31, 2023 was done. Data on socio-demographic details such as age, gender, domicile and clinical profile (diagnosis, mode of discharge, duration of stay and treatment) was compiled using semi-structured format designed by authors. Information regarding patients undergoing electroconvulsive therapy was also gathered from the records. Statistical analysis: The data were subjected to analysis utilizing the Statistical Package for Social Sciences (IBM SPSS Statistics for Windows, version 25.0). Results A total of 680 patients got admitted of which higher proportion constituted of male (77.58%) and majority individuals were aged between 30 and 39 years (29.65%). The predominant diagnosis among the inpatients was substance use disorders (39.09%). Out of all the psychotropic drugs, olanzapine (17.94%) was mostly prescribed on discharged followed by risperidone (10.15%). Escitalopram (3.97%) was the mostly prescribed antidepressant on discharge. Patients diagnosed as substance use disorders were mostly discharged on lorazepam (5%), baclofen (14.26%) and received an average number of 1.8 sessions of Motivational Enhancement Therapy (MET). Whereas, schizophrenia and related disorders was the most common diagnosis among inpatients receiving ECT (51.52%). Conclusion Our study helped to understand the socio-demographic attributes and clinical profile of the inpatients to foster better management approaches.