SQL Assistant
Powerful assistant for SQL generation, modification, fixing, and completion with LLM
Last updated
Powerful assistant for SQL generation, modification, fixing, and completion with LLM
Last updated
SQL Assistant is a feature that understands your intent and generates the necessary SQL for you.
By telling the analysis you want to perform or the SQL you want to generate in natural language, SQL Assistant generates or modifies SQL accordingly.
Navigate to Workspace settings > Integration and enable it. After enabling it, you can use SQL Assistant by choosing an SQL Block and clicking the top right corner of it.
SQL Generation:
After creating an SQL Block, select the table to be referenced by the Assistant and specify the analysis you want to perform.
SQL Modification:
Select the SQL Block you want to modify and instruct the Assistant on how to modify it.
SQL Auto Fix:
By selecting "Auto fix" on an SQL Block that has an error, the Assistant will perform corrections based on the SQL statements that need fixing and the error messages.
SQL Completion:
Write an explanation of the SQL you want to generate in the SQL Block, place the cursor on the next line, and press ⌥ + Enter to generate SQL at the cursor position.
By pressing ⌥ + Shift + Enter, you can request a model that prioritizes speed over accuracy.
These requests are sent to each LLM platform you choose but are not used for training purposes.
The data included in key features are as follows:
SQL statement within the SQL block
The schema of the referenced table and the schema of the result of the SQL execution, as specified in:
Tables and SQL Blocks referenced within the SQL block
Tables explicitly referenced in the GUI
Request messages input by the user
To use SQL Assistant feature with your own API key, please contact us via chat or [email protected]
