Get started
with a full-featured free edition
Get your firsthand experience with the AI Assistant for free—and then upgrade to get more tokens.
Get started
dbForge AI Assistant
What if we said that you could reinvent your SQL coding with an AI-powered assistant? Here it is, ready to keep your manual work to a minimum.
Built for SQL professionals
Database developers
dbForge AI Assistant is a high-end AI tool for SQL coding 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
With the Assistant, DBAs receive the best AI tool for SQL query optimization and troubleshooting. 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. Using 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
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.
What's more, even without the context, you can input a request in any language and have the Assistant translate it to valid SQL in a matter of moments. This is an invaluable time saver for pros and beginners alike.
Here is another feature that is just as simple yet highly helpful. After all, you don't want to use resource-consuming queries. Just show them to the AI Assistant and get them back, rewritten and thus optimized for top performance.
The AI Assistant will also help you understand SQL queries by giving you clause-by-clause breakdowns of your code with detailed explanations. This is especially useful if you are still learning the subtleties of SQL.
You can use dbForge AI Assistant to analyze and fix your SQL. Simply enter a query; if there is something wrong with it, the Assistant will spot it and immediately provide you with explanations and actionable suggestions.
Finally, should you have any questions regarding SQL in general or your current case in particular, feel free to chat with the AI Assistant. Additionally, it will guide you through any feature of the dbForge product you're using.
Let's begin
dbForge AI Assistant integrates with various dbForge products, from all-in-one IDEs to specialized database applications. Choose any for your daily tasks, and the AI Assistant will be a great guide.
dbForge
Studio for SQL Server
A high-end IDE that covers nearly every aspect of work with SQL Server and Azure SQL
dbForge
SQL Complete
The ultimate add-in to level up your SQL development in SSMS and Visual Studio
dbForge
SQL Tools
A bundle of 15 essential tools and add-ins for SSMS and Visual Studio
dbForge
Studio for Oracle
A feature-rich IDE that simplifies the management of Oracle databases
dbForge
Studio for MySQL
An all-in-one IDE that helps develop and manage MySQL and MariaDB databases
dbForge
Studio for PostgreSQL
A powerful IDE for PostgreSQL, Supabase, Amazon Redshift, and related cloud services
dbForge
Edge
A unified solution for managing the entire database lifecycle across multiple systems and cloud services
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.
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
Monthly billing
Yearly billing
Express
Available
Free
Get started now
Key features:
- Context-aware query generation
- Natural language to SQL
- Query optimization
- SQL explanations
- SQL troubleshooting
- Error analysis and clarifications
- AI chat with web search
- Integration with dbForge tools
Professional
Starts from
$9.95
$99.95
per month
per year
All features from Express +
- A greatly increased number of available tokens; by getting a paid plan, you upgrade from 200,000 to 20 million tokens per month
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
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 the best AI tool for SQL developers.
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
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 integrated into multiple dbForge products and designed as the ultimate AI tool for SQL Server, MySQL, MariaDB, Oracle, PostgreSQL, and a number of related databases.
The AI Assistant is focused on generating, fixing, explaning, and optimizing SQL queries, as well as getting AI-powered guidance on everything SQL.
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.
Is dbForge AI Assistant available inside 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 LLMs by OpenAI and Anthropic 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?
dbForge AI Assistant currently uses LLMs by OpenAI (GPT-5.4, GPT-5.5) and Anthropic (Claude Haiku 4.5, Claude Sonnet 4.6, Claude Sonnet 5).
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 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.
Is there a free plan for dbForge AI Assistant?
Yes, there is a completely free plan that is perfectly suitable for getting acquainted with the capabilities of dbForge AI Assistant.
What is included in the free plan?
Both free and paid plans provide the complete feature set, including context-aware SQL generation, optimization, explanations, and troubleshooting; error analysis and recommendations; and an AI chat for everything related to SQL and databases with integrated web search. The only difference is the number of available tokens per month: 200,000 for the free plan, which can be substantially upgraded to 20 million for the paid plan.
Can I upgrade if I need higher usage limits?
Sure! You can easily upgrade to a paid plan to level up the number of available tokens per month. 20 million tokens is sufficient for intensive usage.
What license is required for AI features? Is it included in my dbForge license?
The paid version of dbForge AI Assistant requires a separate license; it is not included in the licenses of other dbForge products. Note that the Assistant is available as a free SQL AI tool as well.
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 free edition of the Assistant 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 free and paid plans?
The Assistant is available as a free AI tool for SQL query generation; the said free plan includes 200,000 tokens per month. The paid plan boosts this number up to 20 million tokens per month, which 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 deactivated by default and can be activated under a free or paid plan.
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/or Anthropic, 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 started for free
Here's all it takes to reinvent your routine SQL development today! Start using dbForge AI Assistant for free and experience its powerful capabilities in action.
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?
If you need any help with dbForge AI Assistant or have questions about other dbForge products, just get in touch with us. Our response won't keep you waiting.