Assistant with text-to-SQL Performance

API
, , ,
29

Whoa … no no no. That’s to much finger crossing hoping it understands what you need it to do. you still got a lot of prep work to do.

  1. You need to document every singe table and put this in a well documented/laid out markdown file.

  2. You need to pull all the relationships from the DB, get AI to analyse that and put those results in a markdown file as well.

  3. Based on those 2 files, you need to then hand them back to the AI to analyse and create a detailed Mermaid file showing all the relationships as a mermaid flowchart.

  4. Next generate a doc with AI to document how to use these files to work out a search.

  5. Next with the help of AI, create as many relevant views as possible and create a tool call for each 1.

This should work, I know because I have done it.

This is an old post, was tool calling around back then?

1 Like