A side-by-side look at the PostgreSQL Performance (read Only) and Pgtuner MCP MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose PostgreSQL Performance (read Only) for databases work over a hosted endpoint; choose Pgtuner MCP for databases as a local process. You can also run both side by side in one mcpServers block.
DATABASE_URI.get_slow_queries, analyze_query, get_table_stats.Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 36/100 · Fair | 52/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Remote HTTP/SSE | Local subprocess (stdio) |
| Auth | Not declared | other |
| Pricing | Not declared | Free |
| Required env vars | None listed | DATABASE_URI |
| Verified owner | Community listing | Community listing |
| GitHub stars | 0 | 29 |
| Directory activity | 0 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | Not listed | 16 |
| Full listing | View PostgreSQL Performance (read Only) | View Pgtuner MCP |
No tool names declared yet. Check the project README from the listing page.
get_slow_queriesRetrieve slow queries from pg_stat_statements with detailed stats (total time, mean time, calls, cache hit ratio). Excludes system catalog queries.analyze_queryAnalyze a query's execution plan with EXPLAIN ANALYZE, including automated issue detectionget_table_statsGet detailed table statistics including size, row counts, dead tuples, and access patternsanalyze_disk_io_patternsAnalyze disk I/O read/write patterns, identify hot tables, buffer cache efficiency, and I/O bottlenecks. Supports filtering by analysis type (all, buffer_pool, tables, indexes, temp_files, checkpoints).get_index_recommendationsAI-powered index recommendations based on query workload analysisexplain_with_indexesRun EXPLAIN with hypothetical indexes to test improvements without creating real indexesmanage_hypothetical_indexesCreate, list, drop, or reset HypoPG hypothetical indexes. Supports hide/unhide existing indexes.find_unused_indexesFind unused and duplicate indexes that can be safely droppedcheck_database_healthComprehensive health check with scoring (connections, cache, locks, replication, wraparound, disk, checkpoints)get_active_queriesMonitor active queries, find long-running transactions and blocked queries. By default excludes system processes.analyze_wait_eventsAnalyze wait events to identify I/O, lock, or CPU bottlenecks. Focuses on client backend processes.review_settingsReview PostgreSQL settings by category with optimization recommendationsPaste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
{
"mcpServers": {
"postgresql-performance-read-only": {
"url": "http://localhost:8080/mcp"
}
}
}
{
"mcpServers": {
"pgtuner-mcp": {
"command": "uvx",
"args": [
"pgtuner_mcp"
],
"env": {
"DATABASE_URI": "YOUR_DATABASE_URI_HERE"
}
}
}
}