Rails PG Extras MCP
JSON →An MCP interface for the rails-pg-extras gem, providing PostgreSQL metadata and performance analysis through LLM prompts.
Install
npm install -g mcp-remote Tools · 5
- calls Returns a list of bottleneck queries based on call frequency.
- outliers Returns a list of bottleneck queries based on execution time outliers.
- explain Runs EXPLAIN on a given query to provide execution plan insights.
- explain_analyze Runs EXPLAIN ANALYZE on a given query to provide detailed execution plan with actual timings.
- connections Shows which database user the LLM is connected with.
Environment variables
RAILS_PG_EXTRAS_MCP_DATABASE_URL
Links
★ 29 GitHub stars