Comment by rtkwe
2 days ago
How do you present the interrelations between the tables when you're dealing with complex table structures?
2 days ago
How do you present the interrelations between the tables when you're dealing with complex table structures?
Prompting with documentation and examples works. In an agentic tool having an MCP server for the db helps assuming it is a straightforward schema with explicitly defined relationships. Also helps if the tables correspond to entities in a natural way.
Use a tool to do that. Try https://visualdb.com it can send the relationships and table definitions to AI.
We're pretty locked down around AI tools. Right now we can only really use GH Copilot, it's been ok so far though it's funny to see it suggest edits then suggest the opposite on the next time it review the PR if you accept them.
I just go into SSMS and expand the columns for the tables I care about in the left hand explorer, screenshot it and send that to copilot.