You do not need to use the exact same wording as ours to get results. We got the correct SELECT query that only displays records in which the Total values are more than 4. Show all invoices from Germany with a total more 4 Let’s run the same query but add a condition to it: As you can see, our text was converted into a valid SQL query, and it was automatically executed since we checked the corresponding box in the preferences. Next, we will click the Translate button. Let’s try showing all invoices from our German customers. Now we can check how it works with an example using our sample SQLite database. You can use the GPT-3 Smart Completion on any SQL database supported by DBeaver. All other settings can be left as default, but if you want to change them, please read our documentation for details. The main thing you need to do is to enter the API token. On the first launch, you will see the Preferences window. If you click the Confirm button, you can open a GPT Smart Completion window. On the first run, you will see a warning that the metadata information needs to be transferred to OpenAI API. In the left toolbar of SQL Editor, you can find a new icon that, when clicked, will open an AI assistant. To access this feature in the Community version, you first need to install the extension. For example, if you have a table with invoices, you can write something like “show all invoices”, and this request will be converted into a valid Select query.įor DBeaver PRO, GPT-3 will be available out of the box. You simply need to describe the desired query and get the result. Thanks to our new feature, you can convert sentences written in human language into SQL. And now, it can become your assistant in writing SQL queries in DBeaver. One of its more popular uses is to help you write code in various languages. Thanks to that, GPT-3 is able to perform tasks it was not explicitly trained on and with few to no examples.Ĭompared to its predecessor, GPT-2, which was practically incapable of doing this, GPT-3 has taken a huge step forward and quickly gained popularity around the world. It has 175 billion parameters and was trained on 570 gigabytes of text. GPT-3 is a large language model chatbot developed by the artificial intelligence company OpenAI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |