Hey HN,<p>Postgres Pro is an open source Model Context Protocol (MCP) server built to support every stage of the development process.<p>It does a lot more than help generate and run SQL—it helps you make sure your application and database actually run well.<p>Features:<p>- Industrial-strength tuning algorithms similar to those in MS SQL Server<p>- “What if?” tool to evaluate LLM-generated index suggestions<p>- Works with Cursor, etc., to make changes in ORM code<p>- Ensures safe SQL execution with restricted mode<p>- Includes health checks to stay ahead of production problems
Using AI to improve query performance seems inevitable, kind of how LLM's have made ffmpeg so much more usable.<p>There are just so many factors that go into writing a query that will be performant, not just basic indexes but joins vs. subqueries, single-column indexes vs. multi-column indexes with various sort orders, etc. And even if you write something that's performant at 1,000 rows in your test database, it falls apart with 1,000,000 rows in production.<p>But reliable AI that can actually understand all your queries together with the database structure, in order to find performance improvements, feels like it's going to become as helpful on the database side as Copilot etc. is on the regular coding side.