MCP server for DM8 database operations with enhanced security. Provides read-only database access via Model Context Protocol.
Server provides 5 database tools with reasonable naming (verb_noun pattern) and descriptions in Chinese. All tools have input schemas with type definitions and parameter descriptions. However, descriptions lack English translations (barrier for international LLM use), output schemas are not documented, and error handling guidance is minimal. Parameter constraints are present but could be more explicit. No tool annotations (readOnlyHint/destructiveHint) despite clear risk levels. Average tool quality is fair but not production-grade.
返回指定连接和 Schema 下的列名、类型、长度、是否可空,以及列注释(ALL_COL_COMMENTS),帮助 LLM 消歧字段语义
执行 SQL 语句。默认只读(SELECT/SHOW/DESCRIBE/EXPLAIN),实际允许的语句类型由所选连接的 sqlAccess 级别决定(readonly/dml/ddl/full)。支持多连接模式,schema 参数支持别名或实际模式名。结果超过 maxRows 时截断
返回指定表的索引名、是否唯一、索引列及列序(ALL_INDEXES + ALL_IND_COLUMNS),用于理解查询性能与唯一约束
返回以连接为第一公民的目录:每个连接可访问的 schema、跨连接同名 schema 警告、以及数据库中实际可见的 schema。多连接模式下据此选择 connection 参数。
返回指定连接和 Schema 下的所有表名
Descriptions are in Chinese only; international LLM clients cannot understand tool purpose or parameter semantics. Descriptions must be in English for cross-region deployment.
Output schemas are not documented. LLMs cannot predict response structure, field names, or types. This forces trial-and-error parsing and wastes tokens on clarification.
No tool annotations (readOnlyHint, destructiveHint, idempotentHint) despite execute_query supporting WRITE operations. Clients cannot distinguish safe vs. destructive tools.
Inferred effective spec: 2025-06-18+.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | D | 57 | 2025-06-18+ | v2 |
Error handling lacks recovery guidance. No indication of retryable vs. fatal errors, or what the LLM should do next (e.g., 'Try list_schemas() first to find valid schema names').
execute_query accepts maxRows up to 100,000 but no pagination (offset/limit) parameters. Large result sets will exhaust context windows and degrade LLM reasoning.