The integrated AI Assistant Chat is part of several AI features. You can open the chat using:
| • | the toolbar button or Welcome Window button |
| • | the menu via Tools, AI Assistant Chat |
| • | the menu via View, AI Assistant Chat |
The chat window will appear at the right side of the main window. By default, it will use the current session for context, you can attach a specific session if you have multiple sessions and want to make sure it uses a particular database.
The AI Assistant is aware of your database brand (eg, MySQL, Firebird or PostgreSQL) and the version.
What is a "chat"? What is an archived chat?
At the top of the AI Assistant Chat window, a toolbar allows you to start new chats, archive the current chat or manage chat archives.
A "chat" is a conversation of multiple messages back and forth, including any information about the database used during the conversation. You can stop the current chat by using New Chat.
You can save a chat for later using Archive Chat. A quick list to restore one of the archived chats is available via the drop down button.
When you want to delete one or more archived chats, use Manage Archive.
Delete archived chats
Execute generated SQL
Whenever the AI Assistant produces SQL, the chat window will display this with extra buttons just above the SQL and with syntax highlighting. The buttons can be used to, from left-to-right:
| • | create a new SQL Editor and add the code to that editor |
| • | replace the code in the current open SQL editor |
| • | copy the code to the clipboard |
Generated SQL code, as displayed in the chat window
By using these buttons, you can quickly modify the queries in your current SQL Editor and execute the statements to see if they generate the results you want.