Systems and methods for query optimization

A computer-implemented method comprising:

• providing, by one or more processors, a proposed database query to a machine-learning model, wherein the machine-learning model has been trained, using one or more gathered and/or simulated sets of query execution overhead data and one or more gathered and/or simulated sets of database queries, to determine a potential execution overhead of a database query and output a query execution score;
• outputting, by the machine-learning model, the query execution score based on the proposed database query;
• determining, by the one or more processors, that the query execution score exceeds a query execution score threshold;
• identifying, by a natural language processor, one or more of a database update command or a database information request of the proposed database query;
• and
• generating, by the natural language processor, an optimized database query including the one or more of the database update command and the database information request.

A system comprising:

• a memory storing instructions and a machine-learning model that has been trained to find associations between one or more gathered and/or simulated sets of query execution overhead data and one or more gathered and/or simulated sets of database queries to determine a potential execution overhead of a database query and output a query execution score;
• and
• a processor operatively connected to the memory and configured to execute the instructions to perform operations including:
• capturing, by one or more processors, a proposed database query input into a user interface;
• providing, by the one or more processors, the proposed database query to the machine-learning model;
• outputting, by the machine-learning model, the query execution score based on the proposed database query;
• determining, by the one or more processors, that the query execution score exceeds a query execution score threshold;
• and
• triggering, by the one or more processors, a corrective action based on the query execution score exceeding the query execution score threshold.