The SQL console provides AI capabilities to assist users in better SQL development.
Background information
The SQL console integrates AI capabilities to help users query OceanBase Database knowledge and SQL development techniques. It also supports intelligent processing of SQL statements, such as generation, rewriting, correction, and formatting. The SQL console provides shortcut dialog boxes and independent dialog windows in the SQL editing page to assist users in quickly developing SQL statements.
Prerequisites
An LLM is configured. For more information, see Integrate with LLMs.
Intelligent SQL editing
In the SQL editing area, you can invoke the AI dialog box in the following ways:
Select the content to be edited and click Edit in the right-side toolbar to open the AI dialog box.
Select the content to be edited, right-click the selected content, and choose AI Inline Chat, SQL Debugging, SQL Optimization, AI Format Document, or AI Format Selection from the shortcut menu.
Press
CTRL + K/COMMAND + Kto quickly invoke the AI dialog box.