{"id":"krdk01-postgresql-mcp-server","name":"postgresql-mcp-server","af_score":42.0,"security_score":31.8,"reliability_score":12.5,"what_it_does":"Provides an MCP server (implemented as a Spring Boot app) that exposes read-only access to a PostgreSQL database. It offers an MCP tool to run validated SQL queries (requires WHERE clause; blocks SELECT *) and a resource endpoint for table schema discovery from information_schema.","best_when":"You want an MCP-compatible, STDIO-based (or optional SSE mode) way to retrieve read-only, paged query results and schema metadata with basic SQL safety constraints.","avoid_when":"You need robust security controls beyond “database credentials in env vars,” or you require guarantees about pagination/rate limiting/error handling behavior under load that are not documented.","last_evaluated":"2026-04-04T20:02:01.710557+00:00","has_mcp":true,"has_api":false,"auth_methods":["Database credentials via environment variables (DATABASE_URL, DATABASE_USERNAME, DATABASE_PASSWORD)","Assumes MCP client connects over local transport (STDIO) as configured via container/command"],"has_free_tier":false,"known_gotchas":["The query tool requires a WHERE clause and forbids SELECT *; the agent must ensure compliant SQL to avoid tool rejections.","Pagination is LIMIT/OFFSET based; ordering is not specified in the tool contract, so results may be nondeterministic across pages unless the agent includes an ORDER BY in the SQL.","Schema resources are dynamically discovered on each request; an agent may incur repeated metadata lookups and potential latency."],"error_quality":0.0}