{"id":6120,"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","github":"https://github.com/pawurb/rails-pg-extras-mcp","homepage":"","server_url":"","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","official":false,"stars":29,"status":"active","source":"mcpservers.org","created_at":"2026-05-25T13:18:56.882962+00:00","updated_at":"2026-05-28T11:52:00.196007+00:00","tags":[],"path":"rails-pg-extras-mcp"}