Built for SQL professionals

Database developers

dbForge AI Assistant is a high-end solution that perfectly addresses the needs of both individual developers and entire teams operating with databases and business data.

2x-4x

Faster SQL development

Database administrators

DBAs can use dbForge AI Assistant to optimize and troubleshoot SQL queries in no time. It has never been easier to keep database performance at an all-time high.

+30%

Productivity in administration

Data analysts

Analysts use SQL queries to retrieve and scrutinize data. With dbForge AI Assistant, they can get valid queries of any complexity within moments—and run them right away.

1.5x

Faster data retrieval for analysis

Try before you buy with a free 14-day trial

You can access the AI Assistant from multiple dbForge products and activate it for a free trial.

Get started
Activate the AI Assistant for a free 14-day trial and see all of its features in action

Key features of dbForge AI Assistant

Attach a database of your choice, and dbForge AI Assistant will use its context to generate relevant SQL queries of any complexity at your request. Afterwards, you will be able to copy, modify, and run them against the database.
Get started

Let's begin

dbForge AI Assistant is seamlessly integrated into your current dbForge product. Simply launch that product, activate your AI Assistant license, and you're all set to start your work with it.

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.

3

Open the AI Assistant

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

Note

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

Pricing

Your ultimate SQL AI tool
for query generation & optimization

  • Context-aware query generation
  • Query optimization
  • Conversion of natural language to SQL
  • Error analysis & clarifications
  • SQL explanations
  • AI chat
  • SQL troubleshooting
  • Web search
Monthly billing Yearly billing
$9.95
$99.95
1-month subscription
Buy now
The AI Assistant requires a separate license
Get a free trial of dbForge AI Assistant today
Free trial

Without a doubt, you would like to explore the capabilities of dbForge AI Assistant before purchasing it. That's why we gladly invite you to start with a free 14-day trial.

Get started

Why users love
dbForge AI Assistant

If writing SQL code is part of your daily work, you won't be surprised by smart code completion or as-you-type syntax validation. But now we offer you a step forward. Instant generation of context-aware queries based on natural language input. Automated code analysis and optimization. Real-time consultations on everything SQL. You can have it all with dbForge AI Assistant at your service. And that's why users around the world love it.

A helper for everyday coding tasks
A helper for everyday coding tasks
SQL coding can be time-consuming and prone to errors. But not for you, and not any longer. Now you can automate the generation of SQL queries with an AI tool at hand.
The simplest path to peak productivity
The simplest path to peak productivity
You can do much more in less time: create context-aware SQL queries from scratch, analyze and optimize your code, and get extensive consultations.
A solution for various database systems
A solution for various database systems
dbForge AI Assistant is well-versed in the specifics of the most popular database management systems, including SQL Server, MySQL, MariaDB, Oracle Database, and PostgreSQL.

Frequently asked questions

What is dbForge AI Assistant?

dbForge AI Assistant is your ultimate tool for generating, fixing, and optimizing SQL queries, as well as getting AI-powered guidance on everything SQL. The Assistant is integrated into multiple dbForge products, and is available for SQL Server, MySQL, MariaDB, Oracle, and PostgreSQL databases.

Why has dbForge created its own AI Assistant?

AI is getting progressively better all the time, and we had the idea of making a smart assistant that would help users auto-generate error-free queries, optimize manually written queries, and give consultations on any SQL-related issues directly from dbForge products.

How does dbForge AI Assistant compare to other AI assistants?

dbForge AI Assistant is a worthwhile competitor to any other built-in AI assistant. It is context-aware and well-versed in everything related to SQL and databases. Additionally, it is integrated with the dbForge product documentation, and, if asked, will guide you on any requested topic.

Can the Assistant be used to enhance query writing?

Yes. You can input a query, and the Assistant will be able to analyze it, locate errors, if any, and suggest improvements that will help boost its performance. You can also attach a database and thus empower the Assistant with its context (including index metadata) to create relevant queries.

Can the Assistant serve as an AI SQL generator?

Yes, that's one of its primary purposes. It generates context-aware SQL queries that you can further review, copy to SQL Editor, tweak to your preferences, if necessary, and run against your databases.

Can the Assistant be used as an AI SQL query builder to simplify the creation of complex queries?

Yes, the Assistant can handle queries of any complexity. Still, we recommend reviewing complex queries before executing them, just to make sure you are getting exactly what you need.

How does the Assistant utilize AI for SQL to optimize database performance?

The Assistant utilizes AI to optimize queries in order to make them more effective and less expensive in terms of execution. The workflow is simple: you give the Assistant a query, and in return you get optimization suggestions. And if you need even more precise and relevant suggestions within the context of a particular database, just attach it and thus let the Assistant read its metadata (including index information) and generate answers based on it.

In what ways does dbForge AI Assistant help with query troubleshooting?

If you have a query that doesn't work as expected, you can show it to the Assistant. Additionally, if you get an error, you can ask the Assistant to explain and fix it. Your troubleshooting will be done in a few clicks.

How does the Assistant integrate with dbForge products?

dbForge AI Assistant is directly integrated into multiple dbForge products and can be accessed from there.

Can the Assistant's SQL query generator assist in learning the SQL syntax and best practices?

Sure! You can ask the Assistant to explain any specific query or ask any general SQL-related question to get a helpful answer.

What are the benefits of using the Assistant as an AI SQL query builder for database administrators?

The best thing is that you don't have to know SQL to build queries with the Assistant. Thanks to its ability to convert natural language to SQL, you are free to express your requests in any way, like "Give me a list of all employees from the sales department whose last names begin with A, B, or C"—and the Assistant will examine the metadata of your database and give you a working query that, if executed, will return the said list.

I'm getting errors while using the Assistant. What should I do?

dbForge AI Assistant relies on the context of your conversation. Including more details in your questions might help the Assistant understand you better. For further convenience, you can attach any required database and thus provide the Assistant with its metadata so it can generate relevant answers based on it.

What data does dbForge AI Assistant send from my dbForge product to LLM providers?

dbForge AI Assistant is based on OpenAI and is available under their terms and conditions. The Assistant does not have access to the actual data of your databases, only to the metadata (for context purposes). The information stored on the server is strictly limited to your conversation with the Assistant.

Will the data sent by dbForge AI Assistant to LLM providers be used to train models?

No, it won't. And we'd like to reiterate that, besides your actual conversation with the Assistant, nothing is stored on the server.

Is the code suggested by dbForge AI Assistant secure?

Yes, the Assistant generates secure SQL code. Nevertheless, you should double-check it before execution to make sure you are getting exactly what you need.

What LLMs are used by the Assistant? Are there any plans to include additional models?

The single LLM currently used by the Assistant is OpenAI. There might be additional models included in the future, but there are no specific plans for that.

Where are the dbForge AI servers hosted?

dbForge AI Assistant works via OpenAI, whose servers are currently located in the United States of America.

I have dbForge AI Assistant in my dbForge product, but I haven't enabled it. Does it send my data to the server?

No, it doesn't.

Can I remove the Assistant from my dbForge product?

dbForge AI Assistant is an integrated feature of multiple dbForge products, and you cannot uninstall it completely. The Assistant can be enabled—when you activate it for a trial or purchase a license for it—but you can just as easily disable it at any given moment.

How do I start using dbForge AI features in my dbForge product?

Go to your dbForge product and open the AI Assistant. Attach the required database, and the Assistant will take a few moments to learn the context via its metadata. After that, you are free to begin your conversation.

Is the trial period available only once?

Yes, the 14-day trial period is available only once. You can use it to explore the capabilities of the Assistant and see whether it's helpful in daily work.

What license is required for AI features? Is it included in my dbForge license?

dbForge AI Assistant requires a separate license; it is not included in the licenses of other dbForge products.

I have a subscription to a commercial dbForge product. Can I use dbForge AI Assistant?

Yes, you can go to your dbForge product and either enable the Assistant for a free trial or purchase a license for it.

I use the Express edition of a dbForge product. Can I use dbForge AI Assistant?

Yes, dbForge AI Assistant is available in the Express editions of dbForge products under the same conditions as in the paid editions.

What is the volume of usage included in the paid plan?

The paid plan includes around 20 million tokens per month. This is quite enough even for intensive usage.

If I have started using the Assistant in dbForge Studio, do I need to pay again to use it in another dbForge product?

No. Once you purchase a license for the Assistant under your Devart account, it will apply to all compatible dbForge products associated with the said account.

Can I use or buy dbForge AI Assistant if I do not use any dbForge product?

No, the Assistant is an integrated feature of dbForge products and is not available as a standalone application.

If I have purchased multiple dbForge licenses, do I need to buy the same number of licenses for the AI Assistant?

No, you need only one license for the Assistant, which can further be used with all compatible dbForge products you have purchased.

Are there any special offers for dbForge AI Assistant?

Volume discounts are possible, but it depends on your particular case. You can contact our sales department for further information.

Why is dbForge AI Assistant not available in some countries?

dbForge products, including the Assistant, might be unavailable in terrorist states like the Russian Federation. We do not wish to fund warmongers.

How can I turn off the AI functionality for a specific dbForge product?

dbForge AI Assistant comes turned off by default and can be turned on under a free trial or with a purchased license.

I want to use dbForge AI Assistant in my organization. Is it possible?

This depends on the policies of your organization, especially those that concern sensitive data. If these policies don't clash with the terms and conditions of OpenAI, and if your organization is using dbForge products, you can easily use the Assistant along with them.

How can I contribute to dbForge AI Assistant?

If something goes wrong, you can send us a dump of your chat with the AI Assistant, and we will scrutinize it and see what can be improved. And as usual, we would appreciate any kind of feedback you would like to send us.

Ready to get started?

Get your 14-day trial of dbForge AI Assistant

Get a 14-day trial

Without a doubt, you would like to explore the capabilities of dbForge AI Assistant before purchasing it. That's why we gladly invite you to start with a free 14-day trial. It includes the features of the Professional edition and is limited only by usage volume.

Get discounts on multiple licenses

Multiple license discounts

Take note that we provide flexible purchasing options, which include bulk discounts on multiple licenses, to meet the budget of each and every customer.

Need a hand? Just get in touch with us!

Need a hand?

If you need any help with the AI Assistant or have questions about other dbForge products, just get in touch with us. Our response won't keep you waiting.