MCP server for AWS PostgreSQL database that provides read-only SQL query capabilities
Single tool 'query' has a clear verb-noun name and basic schema, but lacks depth in descriptions and parameter guidance. Tool description is 95 chars (below baseline 194), parameter description is minimal (23 chars), and no output schema is documented. No error recovery guidance. Security validation (read-only check) is present but not reflected in tool annotations. Missing idempotent/readOnly hints.
Run a read-only SQL query against the AWS PostgreSQL database
Tool description is 95 characters, below baseline 194 chars. Lacks WHEN to use, prerequisites, and output structure guidance. LLMs cannot determine when to select this tool vs alternatives.
Parameter 'sql' description is only 23 chars ('The SQL query to execute (must be read-only)'). Does not explain format constraints, example patterns, or what 'read-only' means. LLMs will guess at valid queries.
No output schema documented. Response structure (rowCount, rows, fields) is returned as JSON text but not declared in tool definition. LLMs cannot plan downstream operations or extract fields reliably.
Error handling returns plain text error messages without recovery guidance. 'Only read-only queries are allowed' does not tell the LLM what to do next or how to fix the query.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | D | 56 | 2026-07-28+ | v2 |
Tool lacks readOnlyHint annotation despite enforcing read-only semantics. This prevents clients from optimizing caching or safety policies based on tool intent.