dameng-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DM_HOST | No | Database host | 127.0.0.1 |
| DM_MODE | No | readonly or readwrite | readonly |
| DM_PORT | No | Database port | 5236 |
| DM_USER | Yes | Database username (required) | |
| DM_SCHEMA | No | Schema to switch to after login | |
| DM_MAX_ROWS | No | Maximum rows returned by read_query | 200 |
| DM_PASSWORD | Yes | Database password (required) | |
| DM_AUDIT_LOG | No | Audit log file path | ./dameng_audit.log |
| DM_QUERY_TIMEOUT | No | Single SQL timeout in seconds | 30 |
| DM_LD_LIBRARY_PATH | No | Path to Dameng dpi library directory |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| extensions | {
"io.modelcontextprotocol/ui": {}
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_schemasA | 列出达梦数据库中所有用户(schema)。无参数。 |
| list_tablesA | 列出表。可选 schema 过滤；省略时用连接配置的 schema。 返回 [{schema, name}, ...]。 |
| describe_tableA | 描述某张表的列(名/类型/长度/可空/默认值/是否主键)。 name 为表名，schema 可选。 |
| read_queryA | 执行只读查询(SELECT/WITH)。sql 用 ? 占位符，参数放 params。 受 DM_MAX_ROWS 限制；返回 {columns, rows, row_count, truncated}。 |
| get_audit_logB | 读取最近的写操作审计记录(任何模式可用，便于 LLM 自查写历史)。 |
| execute_writeA | 执行 DML(INSERT/UPDATE/DELETE/MERGE)，仅读写模式可用。 每次调用写入审计日志。返回 {status, rows_affected, seq}。 |
| execute_ddlB | 执行 DDL(CREATE/ALTER/DROP/TRUNCATE...)，仅读写模式可用。 每次调用写入审计日志。返回 {status, rows_affected, seq}。 |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 7 tools
Each tool has a unique purpose: listing schemas, listing tables, describing a table, executing read queries, retrieving audit logs, executing DML, and executing DDL. There is no ambiguity or overlap between them.
All tool names follow a consistent verb_noun pattern (e.g., list_schemas, execute_write). The naming is clear and predictable, making it easy for an agent to understand the action and target.
With 7 tools, the server covers essential database operations (schema navigation, table description, querying, auditing, and writes) without being over- or under-sized. The count is well-scoped for its purpose.
The tool surface covers the full lifecycle: schema exploration (list_schemas, list_tables), schema introspection (describe_table), read queries (read_query), DML (execute_write), DDL (execute_ddl), and auditing (get_audit_log). No obvious gaps for typical usage.