MCP Servers / database / Rails PG Extras MCP

Rails PG Extras MCP

ssenone★ 29database

An MCP interface for the rails-pg-extras gem, providing PostgreSQL metadata and performance analysis through LLM prompts.

Install

How to run this server

[ { "cmd": "npm install -g mcp-remote", "imports": [] } ]

server path: rails-pg-extras-mcp

Tools

What this server exposes

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.

Configuration

Environment & auth

authnone

envRAILS_PG_EXTRAS_MCP_DATABASE_URL

Resources