PostgreSQL Tuning and Analysis Tool
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"orange-postgres-mcp","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
<div align="center"> <img src="assets/postgres-pro.png" alt="Postgres Pro Logo" width="600"/> [](https://opensource.org/licenses/MIT) [](https://pypi.org/project/postgres-mcp/) [](https://discord.gg/4BEHC7ZM) [](https://x.com/auto_dba) [](https://github.com/crystaldba/postgres-mcp/graphs/contributors) <h3>A Postgres MCP server with index tuning, explain plans, health checks, and safe sql execution</h3> <div class="toc"> <a href="#overview">Overview</a> • <a href="#demo">Demo</a> • <a href="#quick-start">Quick Start</a> • <a href="#technical-notes">Technical Notes</a> • <a href="#mcp-server-api">MCP API</a> • <a href="#related-projects">Related Projects</a> </div> </div> ## Overview **Postgres Pro** is an open source Model Context Protocol (MCP) server built to support you and your AI agents throughout the **entire development process**—from initial coding, through testing and deployment, and to production tuning and maintenance. Postgres Pro does much more than wrap a database connection. Features include: <table> <tr> <td width="50%"> <h4>🔍 Database Health</h4> <ul> <li>Detect unused/duplicate indexes</li> <li>Monitor cache hit rates</li> <li>Check connection utilization</li> <li>Identify vacuum needs before problems occur</li> </ul> </td> <td width="50%"> <h4>⚡ Index Tuning</h4> <ul> <li>Generate optimal indexes using proven algorithms</li> <li>Validate AI-suggested indexes</li> <li>Simulate performance impacts with hypothetical indexes</li> <li>Balance performance gain vs storag…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.