达梦MCP

安装依赖

npm install

快速开始

使用示例

```

使用默认连接查询

list_tables() describe_table(table: "USERS") execute_query(query: "SELECT COUNT(*) FROM ORDERS")

list_schemas 输出示例

=== 已配置的连接 ===
  gasbase (默认连接) -> GASBASE [connection.default=true]
    - GASBASE
  hall -> HALL
    - HALL - 大厅服务
    - HALL_REPORT - 大厅报表

=== 已配置的 Schema 汇总 ===
  GASBASE
  HALL - 大厅服务
  HALL_REPORT - 大厅报表

=== 数据库中可见的模式 ===
  [gasbase] GASBASE, INSPECTION, SYSDBA
  [hall] HALL, SYSDBA

运行单个测试

npx vitest run tests/validation.test.ts

配置文件格式

.claude/dm8-mcp.json 支持多环境管理：

{
  "activeEnv": "dev",
  "environments": {
    "dev": {
      "defaultConnection": "gasbase",
      "connections": [
        {
          "name": "gasbase",
          "host": "11.14.2.1",
          "port": 5236,
          "username": "GASBASE",
          "password": "password1",
          "schema": "GASBASE",
          "default": true
        }
      ]
    },
    "staging": {
      "connections": [
        {
          "name": "test_db",
          "host": "192.168.1.100",
          "port": 5236,
          "username": "TESTER",
          "password": "test_password",
          "schema": "TEST_SCHEMA"
        }
      ]
    },
    "prod": {
      "connections": [
        {
          "name": "BASE",
          "host": "10.31.193.111",
          "masterHost": "10.31.193.121",
          "port": 5236,
          "username": "BASE",
          "password": "password",
          "schema": "BASE",
          "default": true
        },
        {
          "name": "HALL",
          "host": "10.31.193.111",
          "masterHost": "10.31.193.121",
          "port": 5236,
          "username": "HALL",
          "password": "password",
          "schema": "HALL"
        }
      ]
    }
  }
}

备选配置方式（CLI / 环境变量）

除了配置文件，也可以通过 CLI 参数或环境变量传入连接信息（适合简单场景或 CI 环境）：

```bash

命令行参数

配置优先级（高→低）：CLI 参数 → 环境变量 → 配置文件。