{"slug":"pawurb/rails-pg-extras-mcp","name":"Rails PG Extras MCP","description":"An MCP interface for the rails-pg-extras gem, providing PostgreSQL metadata and performance analysis through LLM prompts.","category":"database","tags":[],"official":false,"stars":29,"transport":"sse","install":[{"cmd":"npm install -g mcp-remote","imports":[]}],"tools":[{"name":"calls","description":"Returns a list of bottleneck queries based on call frequency."},{"name":"outliers","description":"Returns a list of bottleneck queries based on execution time outliers."},{"name":"explain","description":"Runs EXPLAIN on a given query to provide execution plan insights."},{"name":"explain_analyze","description":"Runs EXPLAIN ANALYZE on a given query to provide detailed execution plan with actual timings."},{"name":"connections","description":"Shows which database user the LLM is connected with."}],"env_vars":["RAILS_PG_EXTRAS_MCP_DATABASE_URL"],"auth_type":"none","github":"https://github.com/pawurb/rails-pg-extras-mcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}