Install the Assistant

If you are using a dbForge product

1

Sign in to your Devart account

Your account conveniently delivers instant access to the purchased products, licenses, tech support, exclusive offers from Devart, and more.

Sign in
2

Prepare your dbForge product

Make sure you have a valid, active license for the dbForge product that you want to use dbForge AI Assistant with before getting started.

3

Open the AI Assistant

Launch your dbForge product and open the Assistant from the main toolbar. Next, you can either start a free 14-day trial of the Assistant or purchase a license.

Note
The dbForge product must be updated to version 2025.1 or later.

If you aren't using a dbForge product yet

Get started

Launch the Assistant

dbForge AI Assistant is compatible with dbForge products updated to version 2025.1
Launch AI Assistant
Attach a database

Key features of dbForge AI Assistant

Context-aware query generation

It's time to generate your queries in the smartest possible way, with context and precision - and now it's easier than ever. Just attach your database and let dbForge AI Assistant do the rest. All you need to do is ask, and the Assistant will generate SQL queries of any type and complexity that will be relevant to the attached database. Afterwards, you will be able to view and modify those queries, if necessary, run them immediately, or reuse them whenever you need.

Instant conversion of natural language to SQL

What if you'd rather input your queries in any language (even without the context) and have the Assistant translate them to SQL? That's a helpful capability whose objective is to simplify interactions with databases for analysts and non-technical users who are not well-versed in the subtleties of SQL.

No worries here. The Assistant will analyze your text, identify entities and relationships, map them to the structure of your database, and produce valid output.

Discover more

Query optimization

The optimization of manually written queries is yet another feature that is just as simple yet highly useful. After all, you don't want to use resource-consuming queries. Instead, you show a query to the Assistant and get it back, rewritten and thus optimized for top performance.

Discover more

SQL explanations

dbForge AI Assistant will also help you understand SQL queries by giving you clause-by-clause breakdowns of your code with explanations. This is especially useful if you are still learning SQL or if you are a non-technical user who wants to operate data with flexibility and convenience.

SQL troubleshooting

You can use the Assistant to analyze and troubleshoot your queries. Simply enter one; if there is something wrong with it, the Assistant will spot it and immediately provide you with explanations and actionable suggestions. In other words, you will be able to check and adjust your queries in no time.

Additionally, the Assistant is capable of effective error analysis. That is, if you encounter an error, the Assistant can inspect it, explain why it has occurred, and give recommendations on fixing it.

AI chat

Finally, if you have any questions regarding SQL in general or your current database, you can freely chat with the Assistant. After all, it isn't called the Assistant for nothing, and it will quickly provide you with all the required guidance, best practices, and other information in real time. You can even ask anything you'd like to know about your dbForge product, and the Assistant will guide you through every feature step by step.

Documentation

To help you get started even more effectively, we offer helpful and concise documentation that will walk you through the key features and capabilities of dbForge AI Assistant.

Should you have any further questions about the product, please feel free to get in touch with our support service. We will be glad to answer all of your questions.

Documentation Need more support?
Get your firsthand experience with dbForge AI Assistant today!
Use the power of AI to generate, fix, and optimize queries in no time
Purchase now