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":"postgres-mcp-pro-plus","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.
# Postgres MCP Pro Plus <p align="center"> <strong>Advanced PostgreSQL Database Analysis & Optimization Suite</strong><br> <em>Extended version based on <a href="https://github.com/crystaldba/postgres-mcp">crystaldba/postgres-mcp</a></em> </p> ## 🚀 Key Features - **🔍 Comprehensive Database Analysis**: Deep insights into schema structure, relationships, and performance - **⚡ AI-Powered Optimization**: Intelligent index recommendations using Database Tuning Advisor (DTA) and LLM methods - **🩺 Advanced Health Monitoring**: Multi-dimensional health checks with predictive analytics - **🔒 Lock & Blocking Analysis**: Real-time detection and resolution of query blocking and deadlocks - **🧹 Smart Maintenance**: Automated vacuum analysis with bloat detection and maintenance scheduling - **📊 Performance Intelligence**: Query performance analysis with resource usage optimization - **🔐 Security Assessment**: Comprehensive security analysis and recommendations - **🐳 Docker Ready**: Containerized deployment with Docker Compose support ## 📋 Available Tools ### Core Database Operations | Tool Name | Description | | -------------------- | ------------------------------------------------------------------------ | | `list_schemas` | List all schemas with ownership and type classification | | `list_objects` | Browse database objects (tables, views, sequences, extensions) by schema | | `get_object_details` | Detailed object analysis including columns, constraints, and indexes | | `execute_sql` | Execute SQL with safety controls (restricted/unrestricted modes) | ### Performance & Optimization | Tool Name | Description | | -------------------------- | -------------------------------------------------------------------------- | | `explain_query` | Advanced execution…
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.