SQL agent: foreign key relationships as a graph? #2916
nick-youngblut
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
The sql-agent tutorial and other SQL agent architectures that I've found do not really understand how schema in a relational database are associated, so they are generally terrible at query tasks that require table joins.
Are there any tools that represent the schema relationships as a graph database (e.g., neo4j), which the agent then uses to identify how X schema is related to Y and Z schemas in order to properly write the SQL for joining all of those tables? I haven't been able to find such a tool.
Beta Was this translation helpful? Give feedback.
All reactions