Schema | dameng-mcp-server

dameng-mcp-server

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

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": true }
`logging`	{}
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`extensions`	{ "io.modelcontextprotocol/ui": {} }
`experimental`	{}

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}。

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/yizhilangou/dameng-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server