System and method for improving efficiency in natural language query processing utilizing language model

A non-transitory computer-readable medium storing a set of instructions for generating a database query based on a natural language query, the set of instructions comprising:

• one or more instructions that, when executed by one or more processing circuitries of a device, cause the device to:
• receive an unstructured natural language query directed to a security database, wherein the security database includes a representation of a computing environment;
• select a database query from a plurality of preexisting database queries based on a similarity to the unstructured natural language query;
• generate a context for processing by a language model, the context including the selected database query, an identified technology, and a schema of the computing environment;
• process a prompt and the generated context utilizing the language model to generate a second database query;
• and
• execute the second database query on the security database.

A system for generating a database query based on a natural language query comprising:

• a processing circuitry;
• a memory, the memory containing instructions that, when executed by the processing circuitry, configure the system to:
• receive an unstructured natural language query directed to a security database, wherein the security database includes a representation of a computing environment;
• select a database query from a plurality of preexisting database queries based on a similarity to the unstructured natural language query;
• generate a context for processing by a language model, the context including the selected database query, an identified technology, and a schema of the computing environment;
• process a prompt and the generated context utilizing the language model to generate a second database query;
• and
• execute the second database query on the security database.