Next generation SQL writing with the all new AI Assistant
We've all been enjoying code completion in development tools. With added smart features like join-completion and filtering, it was quick and easy to write SQL statements.
Yet, it's time to move forward. Embrace the power of AI.
Speed up your SQL development, save time, avoid syntax errors, improve productivity. Enjoy.
Note: a subscription for the AI Assistant can be purchased from the customer area or with your new license.
- Integrated AI chat
- Context aware text-to-SQL query generation
- Explain and fix complex SQL statements
- Speed up table design
- Improve database documentation
Context aware text-to-SQL
The integrated AI chat is the easiest way to generate SQL queries using plain text. Connect to a database, open the chat and ask away. The AI Assistant will answer.
The assistant knows about database, about SQL, about database specific features, syntax and functions. It's there to help.
Ask a question, the assistant will check the database tables and columns and generate your query.
Speed up table design
You can quickly create new tables using the AI Assistant by describing the table purpose. The more detail the better.
For existing tables, you can use the AI Assistant to create column descriptions, based on the table description or purpose and the column names and data types.
Explain and fix SQL
Got a query or stored procedure that's quite complex? You can use the AI Assistant to break it up and explain it to you.
The AI Assistant can also help to fix your SQL statements. It will check your syntax, check the functions used and check the columns used. Fixes are proposed and you can accept them using a button in the chat window.
Frequently Asked Questions
Purpose and usage
Yes. Simply describe the result you want to achieve, and the AI Assistant can generate a query for you. You can also provide an existing query and ask the AI Assistant to improve or modify it based on your requirements.
Yes. The AI Assistant can analyze complex queries, explain individual clauses, identify potential issues, and suggest improvements.
Yes. The AI Assistant supports multiple SQL dialects and can help convert queries between different database systems.
Yes. Like all AI systems, the AI Assistant can produce incorrect, incomplete, or misleading results. Generated code and recommendations should always be reviewed and tested before use.
Yes. You can provide error messages, and the AI Assistant can help explain their meaning, identify possible causes, and suggest solutions.
Yes. The AI Assistant can analyze SQL queries and suggest potential optimizations. As performance depends on your database structure, indexes, and data volume, all recommendations should be tested before use.
Yes. You can describe what you want in plain language, and the AI Assistant will help generate and explain SQL queries.
The AI Assistant supports all database systems supported by Database Workbench.
Privacy and AI Service Providers
The AI Assistant sends database metadata to the selected AI service provider to provide context for your requests. It does not send table records and has no direct access to your database contents. Any information you enter in the conversation will be sent to the provider as part of your request.
To provide context, the AI Assistant may send database metadata such as table names, column names, data types, schema information, and query text. Table records are not sent automatically.
No. The AI Assistant does not connect directly to your database and cannot access table records. It only receives metadata and information that you explicitly provide in a conversation.
No. Data sent through the Upscene AI Subscription is not used by the supported AI providers to train their models.
For the Upscene AI Subscription, you can currently choose between OpenAI and Mistral AI. OpenAI services are hosted in the United States, while Mistral AI services are hosted in the European Union.
OpenAI services are hosted in the United States, while Mistral AI services are hosted in the European Union. You can choose which provider to use with your Upscene AI Subscription.
No. The AI Assistant is only used when explicitly invoked by the user and requires an active AI Subscription.
No. The Upscene AI Subscription includes access to the supported AI providers. You do not need to create or maintain a separate OpenAI or Mistral AI account to use the AI Assistant.
Yes, for certain AI service providers and Database Workbench editions. Please refer to the product documentation for the currently supported providers and editions.
Limits and license
The subscription includes approximately 20 million tokens per month, shared across all users of the subscription. This should be sufficient for typical day-to-day usage.
If the monthly usage limit is reached, AI functionality may become temporarily unavailable until the next billing period or until additional capacity is purchased.
Each Database Workbench license requires its own login to access the AI Subscription. However, a single subscription may be shared by multiple users. Please note that all users sharing the subscription also share the monthly usage limits.
