Everything @scharleswatson and @anon10827405 said. However, I have a text to sql application that retrieves data from a MySQL database, so that is possible.
All of my AI development is in PHP. I use Drupal as my infrastructure. So, I am able to utilize the Drupal core REST API and direct the OpenAI LLM to execute the database calls via that API.
Your biggest challenge, as I see it, is coming up with the prompts that will define your database tables in a way to ensure that the model responds adequately to your end-user queries.
Some notes:
- SQL
- OpenAI Text to SQL
- Prompt Example - Natural Language to SQL
- https://platform.openai.com/examples/default-sql-translate
- OpenAI Functions calling the Poor Developers Vector Database
- Private Chat with CSV Data (@DevGirl explanation):
- My Prompt Example:
- OpenAI Text to SQL
- Functions