Database Workbench comes with an optional AI features. The AI Assistant can be used to write SQL, explain SQL code, convert stored routines from one system to another, search your database and much more.
Overview
The AI features can be used to:
| • | Convert normal language into SQL queries, based on your database. Describe what you need and the AI Assistant will write the SQL for you. You can test your queries, add filtering, joins and so on. |
| • | Explain SQL directly from the SQL Editor or View Editor. Use the context menu, let the AI Assistant break down your SQL statement and explain it you clause by clause. |
| • | Fixing mistakes in your SQL has never been easier. Submit your SQL statement and the AI Assistant will check for syntax errors, invalid column names or incorrect system functions. |
| • | Create tables even faster by describing table purpose and let the AI Object Assistant generate the columns. |
Note:
The AI features are powered by third party services created by AI providers. Using these services comes at an additional costs, which is why you need an additional subscription, either from Upscene or by yourself from one of the supported providers.
Upscene AI Subscription
You can purchase "Upscene AI Subscription" from the customer area of the website or when purchasing a new license.
After your subscription has been activated in your account, you need to log in using the button at the top right of the main screen.
Web account log in window
Enter the username and password you received and click Login. This will fetch your details and cache those locally. You will get a warning before your subscription runs out.
Using your own API key
You can go to File, Preferences, AI Assistant and open the settings. Here you can select between supported AI providers, enter your API key details and use the AI features.
Requirements for an AI service and model in Database Workbench:
| • | supports tool function calling |
| • | supports JSON schema formatted response |