4 ms·
How do you present the interrelations between the tables when you're dealing with complex table structures?
by rtkwe 10mo ago
How do you present the interrelations between the tables when you're dealing with complex table structures?
- simlan 10mo agoPrompting 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.
- lateforwork 10mo agoUse a tool to do that. Try https://visualdb.com https://visualdb.com it can send the relationships and table definitions to AI.
- rtkwe 10mo agoWe'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.
- sfn42 10mo agoI 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.