19.1 Generating SQL queries
Access the Text2sql Tool
Open the AI2SQL platform
Navigate to the Text to SQL or SQL File Uploader feature
Upload SQL Files (if needed)
Click the upload option
Ensure files are in .txt format (convert .sql to .txt if necessary)
Name your file and select it for upload
Click "Finish" to complete the upload
Select Database Engine
Choose your database type from the dropdown menu
Choose Data Source
Click "Add Tables to Query"
In the "Select File" modal, choose from: • Uploaded files • ERD uploads • Database schema imports • Existing databases • Option to add new tables
Select Specific Files/Tables
Check boxes next to desired files/tables
Click "Select" to confirm
Enter Your Query
Type your question or request in natural language in the query box
Generate and Review SQL
Click "Generate" to create the SQL query
Review the generated SQL for accuracy and usability
This streamlined process allows you to upload SQL files, select relevant data sources, and generate SQL queries from natural language inputs, all within the same tool.
Last updated