A side-by-side look at the Pgtuner MCP and PostgreSQL Performance (read Only) MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Pgtuner MCP for databases work as a local process; choose PostgreSQL Performance (read Only) for databases over a hosted endpoint. 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 | 52/100 · Good | 36/100 · Fair |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Remote HTTP/SSE |
| Auth | other | Not declared |
| Pricing | Free | Not declared |
| Required env vars | DATABASE_URI | None listed |
| Verified owner | Community listing | Community listing |
| GitHub stars | 29 | 0 |
| Directory activity | 3 views 0 installs 0 upvotes | 0 views 0 installs 0 upvotes |
| Tools | 16 | Not listed |
| Full listing | View Pgtuner MCP | View PostgreSQL Performance (read Only) |
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 recommendationsNo tool names declared yet. Check the project README from the listing page.
Paste 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": {
"pgtuner-mcp": {
"command": "uvx",
"args": [
"pgtuner_mcp"
],
"env": {
"DATABASE_URI": "YOUR_DATABASE_URI_HERE"
}
}
}
}
{
"mcpServers": {
"postgresql-performance-read-only": {
"url": "http://localhost:8080/mcp"
}
}
}