dbForge AI Assistant helps you write and improve SQL code in dbForge products. It offers suggestions, explanations, and fixes in real time—all within your development environment—and reduces manual effort in SQL writing, debugging, and other routine tasks.
You can use AI Assistant to:
Generate SQL queries from natural language: Describe what you need (for example, filtering data, joining tables, or summarizing values) and get a ready-to-use SQL query.
Use database context: Attach a database so AI Assistant can provide suggestions and responses based on your actual schema.
Explore your database: Ask questions about table structures, data types, and relationships between objects, or request specific information, such as the number of clients or recent transactions.
Get explanations of SQL code: Submit a query or function to get a clear explanation of how it works.
Fix mistakes in SQL code: Share the SQL code that returns an error or produces unexpected results to learn how to correct it.
Explain errors: View details about the error cause and suggested fixes directly from the Error List.
Web search: Enable web search to include information from online sources—such as documentation, articles, and tutorials—in the AI Assistant response. This gives you more complete explanations and instructions with references you can review.
Compare DDL statements: Ask AI Assistant to analyze and compare the structure of two database objects, and highlight the differences between them.
Access AI Assistant directly from SQL Editor: Select code and ask AI Assistant to explain, optimize, or fix it.
Chat with AI Assistant: Submit requests, ask follow-up questions, and review suggestions through a built-in chat window.
You can start with a free trial that gives you full access to all features. No separate installation is required—AI Assistant is built into compatible dbForge tools. After the trial ends, a license is required to continue using AI Assistant. Licenses are tied to your account and apply across all compatible dbForge products you own.
AI Assistant is available only in compatible dbForge products. For a complete list, see Requirements and compatibility.