A side-by-side look at the Postgres 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 Postgres 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.
POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB.query, execute, explain_query.Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 56/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 | POSTGRES_USERPOSTGRES_PASSWORDPOSTGRES_DB | None listed |
| Verified owner | Community listing | Community listing |
| GitHub stars | 12 | 0 |
| Directory activity | 3 views 0 installs 0 upvotes | 0 views 0 installs 0 upvotes |
| Tools | 15 | Not listed |
| Full listing | View Postgres MCP | View PostgreSQL Performance (read Only) |
queryExecute read-only SQL queries against the databaseexecuteExecute write operations (INSERT/UPDATE/DELETE) when enabledexplain_queryGet EXPLAIN plan for query optimizationlist_schemasList all schemas in the databaselist_tablesList tables in a specific schemadescribe_tableGet table structure (columns, types, constraints)list_viewsList views in a schemadescribe_viewGet view definition and columnslist_functionsList functions and procedurestable_statsGet table statistics (row count, size, bloat)list_indexesList indexes for a tablelist_constraintsList constraints (PK, FK, UNIQUE, CHECK)No 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": {
"javimaligno-postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@javiagui/postgresql-mcp"
],
"env": {
"POSTGRES_USER": "YOUR_POSTGRES_USER_HERE",
"POSTGRES_PASSWORD": "YOUR_POSTGRES_PASSWORD_HERE",
"POSTGRES_DB": "YOUR_POSTGRES_DB_HERE"
}
}
}
}
{
"mcpServers": {
"postgresql-performance-read-only": {
"url": "http://localhost:8080/mcp"
}
}
}