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.