I posted here examples of the actual system and user message prompts I use in one application to achieve the text to SQL process similar to what @DevGirl outlined above: How to apply user based access control check while generating SQL queries using OpenAI API using langchain? - #4 by SomebodySysop
It’s really a cool way to use the LLM and your existing data without having to embed it.
A few quick examples I cut and pasted from my log:
please list the last 20 log type = sql entries. Just display the descriptions.
what was the last model used for log type ‘sql’?
what was the last model used for sql queries?
show me 10 queries from users other than Reggie or somebody. Only show the user, question, notes and date.
when was the first query I posted?
what have my queries been about?
how many queries have I made?
what has been the average cost of my queries?
show me the total time elapsed for all of my queries?
show me the dates and descriptions and cost and elapsed time and models used for the last 5 questions I asked.