Automated Query Analysis and Remediation Tool

A method, comprising:

• at a computing platform comprising at least one processor, a communication interface, and memory:
• receiving, by the at least one processor, via the communication interface, an input query for analysis;
• loading, by the at least one processor, an extensible markup language (XML) query execution plan for the received query, wherein the query execution plan comprises a sequence of operations used to access data in a relational database;
• shredding, by the at least one processor, XML data from the query execution plan into relational database tables;
• identifying, by the at least one processor, tuning parameters based on the shredded XML data;
• generating, by the at least one processor, based on the identified tuning parameters and using a machine learning engine, an optimized query;
• and
• causing, by the at least one processor, the optimized query to be displayed on one or more user interfaces.

One or more non-transitory computer-readable media storing instructions that, when executed by a computing platform comprising at least one processor, a communication interface, and memory, cause the computing platform to:

• receive, via the communication interface, an input query for analysis;
• load an extensible markup language (XML) query execution plan for the received query, wherein the query execution plan comprises a sequence of operations used to access data in a relational database;
• shred XML data from the query execution plan into relational database tables;
• identify tuning parameters based on the shredded XML data;
• generate, based on the identified tuning parameters and using a machine learning engine, an optimized query;
• and
• cause the optimized query to be displayed on one or more user interfaces.