I agree. Claude Code writes superb SQL queries for very complex data. I was dealing with PostgreSQL recently, and it improved the query from 30 seconds to 5 seconds. I couldn't figure it out myself.

▲

rtkwe 6 hours ago | parent | next [-]

How do you present the interrelations between the tables when you're dealing with complex table structures?

▲

simlan 6 hours ago | parent | next [-]

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.

▲

lateforwork 5 hours ago | parent | prev [-]

Use a tool to do that. Try https://visualdb.com it can send the relationships and table definitions to AI.

	▲	rtkwe 4 hours ago \| parent [-]
		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.

▲

baq 5 hours ago | parent | prev [-]

sonnet 4.5 was really bad at anything more than simple queries. even GPT 5 was not great. gemini was consistently good even at 2.5; caught multiple bugs in outputs of either. I haven't tested Opus 4.5 properly at SQL yet, but I've got a feeling Anthropic doesn't prioritize it in training and google does.