Development environment integrated with a large language model

Abstract

A system allows generation of information used by an integrated development environment using a machine learning-based language model, for example, a large language model. The integrated development environment is for developing applications, e.g., database applications. The system receives a natural language request for information related to development of the database application. The system determines contextual information describing a development task associated with the database application and generates a prompt for a machine learning based language model based on the natural language request and the contextual information and receives a response. The system extracts the information related to development of the database application from the response. In response to a natural request, the system may generate a database query, provide a resultset by executing the database query, automatically determine a type of chart and generate one or more charts for visually displaying the result.

What is claimed is: 
     
         1 . A computer-implemented method comprising:
 configuring a user interface of an integrated development environment for developing database applications, wherein the user interface is configured to display one or more of: code being developed for a database application, a schema of a database for storing data of the database application, or sample data processed by the database application;   sending the user interface of the integrated development environment for display via a client device;   receiving via the user interface of the integrated development environment, a natural language request for information related to development of the database application;   determining contextual information describing a development task associated with the database application being developed;   generating a prompt for input to a machine learning based language model based on the natural language request and the contextual information;   providing the prompt to the machine learning based language model for execution;   receiving a response to the prompt from the machine learning based language model;   extracting the information related to development of the database application from the response generated by the machine learning based language model; and   displaying the information via the user interface of the integrated development environment.   
     
     
         2 . The computer-implemented method of  claim 1 , wherein the information related to development of the database application represents sample data for providing as input to the code being developed for the database application. 
     
     
         3 . The computer-implemented method of  claim 1 , wherein the contextual information describing the development task associated with the database application being developed comprises description of one or more code submissions to a code repository storing code of the database application being developed. 
     
     
         4 . The computer-implemented method of  claim 1 , wherein the integrated development environment stores code of the database application being developed in a code repository, the computer-implemented method further comprising:
 accessing from a code repository, information describing a project associated with the database application being developed, wherein the contextual information comprises the information describing the project.   
     
     
         5 . The computer-implemented method of  claim 1 , wherein the information related to development of the database application represents description of a schema for storing data processed by the database application. 
     
     
         6 . The computer-implemented method of  claim 5 , wherein the information related to development of the database application represents database commands for generating the schema of a database for storing data processed by the database application. 
     
     
         7 . The computer-implemented method of  claim 5 , wherein the information related to development of the database application represents one or more of:
 a database query for accessing data stored using the schema of the database;   a resultset obtained by executing the database query; or   a chart representing the resultset obtained by executing the database query.   
     
     
         8 . The computer-implemented method of  claim 7 , wherein the information related to development of the database application represents information describing one or more indexes for efficient execution of the one or more database queries for accessing data stored using the schema of the database. 
     
     
         9 . The computer-implemented method of  claim 7 , wherein the information related to development of the database application represents database commands for generating one or more indexes for efficient execution of the one or more database queries for accessing data stored using the schema of the database, the computer-implemented method further comprising:
 executing the database commands for generating the one or more indexes for efficient execution of the one or more database queries.   
     
     
         10 . The computer-implemented method of  claim 7 , wherein the information related to development of the database application represents one or more unit tests for testing the database application. 
     
     
         11 . A non-transitory computer readable storage medium storing instructions that when executed by one or more computer processors, cause the one or more computer processors to performs steps comprising:
 configuring a user interface of an integrated development environment for developing database applications, wherein the user interface is configured to display one or more of: code being developed for a database application, a schema of a database for storing data of the database application, or sample data processed by the database application;   sending the user interface of the integrated development environment for display via a client device;   receiving via the user interface of the integrated development environment, a natural language request for information related to development of the database application;   determining contextual information describing a development task associated with the database application being developed;   generating a prompt for input to a machine learning based language model based on the natural language request and the contextual information;   providing the prompt to the machine learning based language model for execution;   receiving a response to the prompt from the machine learning based language model;   extracting the information related to development of the database application from the response generated by the machine learning based language model; and   displaying the information via the user interface of the integrated development environment.   
     
     
         12 . The non-transitory computer readable storage medium of  claim 11 , wherein the information related to development of the database application represents sample data for providing as input to the code being developed for the database application. 
     
     
         13 . The non-transitory computer readable storage medium of  claim 11 , wherein the contextual information describing the development task associated with the database application being developed comprises description of one or more code submissions to a code repository storing code of the database application being developed. 
     
     
         14 . The non-transitory computer readable storage medium of  claim 11 , wherein the integrated development environment stores code of the database application being developed in a code repository, the instructions causing the one or more computer processors to performs steps comprising:
 accessing from a code repository, information describing a project associated with the database application being developed, wherein the contextual information comprises the information describing the project.   
     
     
         15 . The non-transitory computer readable storage medium of  claim 11 , wherein the information related to development of the database application represents description of a schema for storing data processed by the database application. 
     
     
         16 . The non-transitory computer readable storage medium of  claim 15 , wherein the information related to development of the database application represents database commands for generating the schema of a database for storing data processed by the database application. 
     
     
         17 . The non-transitory computer readable storage medium of  claim 15 , wherein the information related to development of the database application represents one or more of:
 a database query for accessing data stored using the schema of the database;   a resultset obtained by executing the database query; or   a chart representing the resultset obtained by executing the database query.   
     
     
         18 . The non-transitory computer readable storage medium of  claim 17 , wherein the information related to development of the database application represents information describing one or more indexes for efficient execution of the one or more database queries for accessing data stored using the schema of the database. 
     
     
         19 . The non-transitory computer readable storage medium of  claim 17 , wherein the information related to development of the database application represents database commands for generating one or more indexes for efficient execution of the one or more database queries for accessing data stored using the schema of the database, the instructions causing the one or more computer processors to performs steps comprising:
 executing the database commands for generating the one or more indexes for efficient execution of the one or more database queries.   
     
     
         20 . A computer system comprising:
 one or more computer processors; and   a non-transitory computer readable storage medium storing instructions that when executed by one or more computer processors, cause the one or more computer processors to performs steps comprising:
 configuring a user interface of an integrated development environment for developing database applications, wherein the user interface is configured to display one or more of: code being developed for a database application, a schema of a database for storing data of the database application, or sample data processed by the database application; 
 sending the user interface of the integrated development environment for display via a client device; 
 receiving via the user interface of the integrated development environment, a natural language request for information related to development of the database application; 
 determining contextual information describing a development task associated with the database application being developed; 
 generating a prompt for input to a machine learning based language model based on the natural language request and the contextual information; 
 providing the prompt to the machine learning based language model for execution; 
 receiving a response to the prompt from the machine learning based language model; 
 extracting the information related to development of the database application from the response generated by the machine learning based language model; and 
 displaying the information via the user interface of the integrated development environment.