One of the most popular and the basic type of cyber attacks that implement arbitrary malicious code to obtain the sensitive and the confidential information of a client or an organization residing in the database are the SQL injection attacks. The underneath paper aims in hampering an overview and the vulnerabilities caused due to the sql injection attack. Based on this analysis we try to study various preventive solutions and one of this include preventing it with the help of the LightGBM algorithm. It also focuses on the different stages of the working model and the future application of the particular algorithm in various methods.