Using Azure OpenAI to retrieve SQL data

Question

Is it preferred to provide the full schema (lets say into a .sql file) to GPT model?

or instead give it instructions to search for it directly in the database which is quick to produce better results.

Answer 1

Hi Janarthanan,

Great question let me get you though this, the choice between providing a full schema in a .sql file or instructing a GPT model to search directly in a database depends on various factors like security, maintenance, and performance. Providing a .sql file can enhance security and predictability but requires manual maintenance. Direct database access offers real-time data but necessitates robust security measures and may impact performance, depending on the database's complexity. The decision should align with project requirements and consider the trade-offs between convenience and security.

If you find this answer useful kindly accept it, for assistance ping here thanks.