11.8. Generating SQL Queries
Last updated
Last updated
Once you have your token, you can start using the AI2SQL Chatgpt plugin. Here's how:
With the AI2SQL Chatgpt plugin, you can generate SQL queries using natural language prompts. Here's how:
Open the ChatGPT application where you have installed the AI2SQL plugin.
Navigate to the AI2SQL plugin interface. This can typically be found in the 'Plugins' section of the application.
Once you've opened the AI2SQL plugin, you'll see a field for entering your natural language prompt. For example, "Show me all users who have made a purchase in the last 30 days."
After entering your prompt, click on the 'Generate SQL' button.
The plugin will process your prompt and generate the corresponding SQL query.
You can then run this query directly on your connected database by clicking on the 'Run Query' button.