A method, non-transitory computer readable medium, and apparatus for analyzing a database includes obtaining SQL code defining one or more databases, each including a plurality of objects, wherein the SQL code is stored on one or more database servers. Defects in the SQL code are identified by applying a plurality of rules to the SQL code. Information regarding each identified defect is stored. The information regarding each identified defect is selectively provided to one or more defect closing interface modules.