{"repo":"pawurb/rails-pg-extras-mcp","free":true,"listed":false,"github":"https://github.com/pawurb/rails-pg-extras-mcp","clone":"git clone https://github.com/pawurb/rails-pg-extras-mcp.git","description":"MCP (Model Context Protocol) LLM interface for rails-pg-extras gem","language":"Ruby","stars":29,"topics":[],"license":"MIT","category":"mcp-servers","readme_excerpt":"Rails PG Extras MCP MCP (Model Context Protocol) interface for rails-pg-extras gem. Easily explore PostgreSQL metadata and debug performance issues. Check for table bloat, slow queries, unused indexes, and more. Run EXPLAIN ANALYZE on bottlenecks and get clear, LLM-powered insights to optimize your database. Use a minimally privileged, read-only user to eliminate the risk of data modification or exposure. Check out this post for more in-depth info on the project. Installation The library supports MCP protocol via HTTP SSE interface. config/routes.rb with optional authorization: Refer to the fast-mcp docs for a complete list of supported options (the opts hash is passed directly as-is). For production deployments, you'll likely need a similar config: Next, install mcp-remote: and in your LLM of choice: You can now ask LLM questions about the metadata and performance metrics of your database. Optional EXPLAIN ANALYZE support calls and outliers methods return a list of bottleneck queries. LLM can get better insights into these queries by performing EXPLAIN and EXPLAIN ANALYZE analysis. MCP server exposes two optional methods for this purpose: explain and explain analyze . You can enable them by setting the following ENV variables: ENV['PG EXTRAS MCP EXPLAIN ENABLED'] = 'true' ENV['PG EXTRAS MCP EXPLAIN ANALYZE ENABLED'] = 'true' Enabling these features means that an LLM, can run arbitrary queries in your database. The execution context is wrapped in a transaction and rolled back","default_branch":null,"files":null,"tree":[],"storefront":"/r/pawurb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pawurb/rails-pg-extras-mcp/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}