Using LLMs and MCP to Debug PostgreSQL Performance in Rails

pawelurbanek.com

8 pointsfurkansahin4 comments

It would be interesting to take this approach one step further and submit a PR with documentation.

Hi, author here. Can you elaborate?

I was thinking rails-pg-extras could output to Claude Code since it can see the actual codebase, and generate PRs.

For example, instead of just "add this index", it could see the models and relationships, figure out the right migration syntax, spot N+1 queries in controllers that are causing the slow lookups in the first place.

The workflow would be pretty clean too - let your MCP tool do what it's good at (finding the problems), then hand it off to Claude Code/Cursor/etc that understands the Rails apps to actually write the fixes.

Thoughts?

thanks for it works now, all the heavy lifting is done by LLM, gem only provides the data

Reply on news.ycombinator.com