The server defines 3 tools with basic input schemas and descriptions. However, critical gaps prevent higher scoring: (1) No output schemas are documented for any tool, LLMs cannot know what fields to expect in responses. (2) Parameter descriptions exist but are minimal (10-30 chars), below the 72-char baseline for production tools. (3) Tool names are adequately action-oriented (show_*, execute_*), but descriptions lack WHEN/WHY guidance and don't explain error recovery. (4) No error handling guidance, execute_query silently returns error dicts instead of actionable error messages. (5) Input validation is weak: execute_query checks for 'SELECT' prefix but doesn't prevent injection or provide recovery hints. (6) No pagination support on show_tables despite potentially returning many rows. (7) No timeout or rate-limit documentation in descriptions. Most production tools at this maturity level score 45-55; this server is near that median.

• Document output schemas for all tools. Example: show_databases returns List[str] (database names); show_tables returns List[{database: str, name: str, comment: str|null, columns: List[{Field: str, Type: str, Null: str, Key: str, Default: str, Extra: str}], create_table_query: str}]. execute_query returns List[Dict[str, Any]] on success, {error: str} on error (clarify which case returns which).
• Expand parameter descriptions to 72+ chars with format/constraint details. Example: 'The database name (alphanumeric, 1-64 chars, case-insensitive; required to match an existing schema in Doris)' instead of 'The database name'.
• Document the SELECT-only constraint explicitly in execute_query description: 'Only SELECT queries are allowed for security reasons. UPDATE, DELETE, INSERT, and DDL queries will fail with "Only SELECT queries are allowed".'
• Add pagination to show_tables: introduce optional 'limit' (default 20, max 100) and 'offset' (default 0) parameters. Document result count in response: 'Call again with offset += limit to fetch next page.'
• Add explicit error recovery guidance to execute_query description: 'On timeout (queries >30s): try simplifying the query, adding WHERE filters, or raising the timeout server configuration. On validation error: check that the query is a valid SELECT statement.'
• Add dependency hints: show_tables description should say 'Call show_databases first if you need to discover available schemas.' show_databases description should say 'Use the returned database names as input to show_tables.'

Inferred effective spec: <=2025-11-25.

• Relies on Logging (deprecated) - log to stderr or use OpenTelemetry