Dm8 MCP

🚀 MCP DM8 Server

A TypeScript-based Dameng DM8 Model Context Protocol (MCP) service that provides table structure browsing and read-only query capabilities, and supports proxy connections.

🚀 Quick Start (Recommended Methods)

Method 1: Use directly with npx (no installation required)

npx mcp-dm8-server --host 127.0.0.1 --port 5236 --username SYSDBA --password your_password --schema SYSDBA

Method 2: Install globally and then use

# Global installation
npm install -g mcp-dm8-server

# Use the command
mcp-dm8 --host 127.0.0.1 --port 5236 --username SYSDBA --password your_password --schema SYSDBA

Method 3: Use with proxy connection

npx mcp-dm8-server \
  --host your_dm_host \
  --username SYSDBA \
  --password your_password \
  --schema SYSDBA \
  --proxy-enabled \
  --proxy-host proxy.company.com \
  --proxy-port 8080 \
  --proxy-type http

⚙️ MCP Client Configuration

Claude Desktop Configuration (Most commonly used)

Configuration file location:

• Windows: %APPDATA%\Claude\claude_desktop_config.json
• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Linux: ~/.config/Claude/claude_desktop_config.json

Basic configuration (without proxy)

{
  "mcpServers": {
    "dm8": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dm8-server",
        "--host", "127.0.0.1",
        "--port", "5236",
        "--username", "SYSDBA",
        "--password", "your_password",
        "--schema", "SYSDBA"
      ]
    }
  }
}

Proxy configuration (for enterprise environments)

{
  "mcpServers": {
    "dm8": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dm8-server",
        "--host", "your_dm_host",
        "--username", "SYSDBA",
        "--password", "your_password",
        "--schema", "SYSDBA",
        "--proxy-enabled",
        "--proxy-host", "proxy.company.com",
        "--proxy-port", "8080",
        "--proxy-type", "http"
      ]
    }
  }
}

Environment variable configuration (more secure)

{
  "mcpServers": {
    "dm8": {
      "command": "npx",
      "args": ["-y", "mcp-dm8-server"],
      "env": {
        "DM_USERNAME": "SYSDBA",
        "DM_PASSWORD": "your_password",
        "DM_HOST": "your_dm_host",
        "DM_PORT": "5236",
        "DM_SCHEMA": "SYSDBA",
        "DM_DB_PROXY_ENABLED": "true",
        "DM_DB_PROXY_HOST": "proxy.company.com",
        "DM_DB_PROXY_PORT": "8080",
        "DM_DB_PROXY_TYPE": "http",
        "NODE_OPTIONS": "--openssl-legacy-provider"
      }
    }
  }
}

Other MCP Client Configurations

Cline (VSCode Extension)

Configure in VSCode Settings → Cline → MCP Settings:

{
  "mcpServers": {
    "dm8": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dm8-server",
        "--host", "127.0.0.1",
        "--port", "5236",
        "--username", "SYSDBA",
        "--password", "your_password",
        "--schema", "SYSDBA"
      ]
    }
  }
}

mcp-router Configuration

Configure in ~/.mcp-router/config.json:

{
  "servers": {
    "dm8": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dm8-server",
        "--host", "127.0.0.1",
        "--port", "5236",
        "--username", "SYSDBA",
        "--password", "your_password",
        "--schema", "SYSDBA"
      ],
      "env": {
        "NODE_OPTIONS": "--openssl-legacy-provider"
      }
    }
  }
}

🌐 Proxy Support Details

Supported Proxy Types

• HTTP: Standard HTTP proxy
• HTTPS: HTTPS proxy
• SOCKS4: SOCKS4 proxy
• SOCKS5: SOCKS5 proxy

Configuration Parameters

Environment Variable Configuration Example

export DM_DB_PROXY_ENABLED="true"
export DM_DB_PROXY_HOST="proxy.company.com"
export DM_DB_PROXY_PORT="8080"
export DM_DB_PROXY_TYPE="http"

npx mcp-dm8-server --username SYSDBA --password your_password --host your_dm_host --schema SYSDBA

🛠️ Available Tools

⚠️ Security Restriction: Only SELECT/SHOW/DESCRIBE/EXPLAIN statements are allowed.

📋 Command Line Parameters

🔧 Development and Local Build

# Clone the project
git clone https://github.com/lianekai/mcp-dm8-server.git
cd mcp-dm8-server

# Install dependencies
npm install

# Development mode
npm run dev

# Build
npm run build

# Local testing
npm test

# Local run
node dist/index.js --host 127.0.0.1 --port 5236 --username SYSDBA --password your_password --schema SYSDBA

📌 Notes

Node.js Version Requirement

• Node.js 16.x: Use directly
• Node.js 18.x+: Add the --openssl-legacy-provider parameter

# Usage for Node.js 18+
NODE_OPTIONS=--openssl-legacy-provider npx mcp-dm8-server --host 127.0.0.1 --username SYSDBA --password your_password --schema SYSDBA

Security Best Practices

1. Password Security: It is recommended to use environment variables to store sensitive information.
2. Network Security: Use proxy connections in enterprise environments.
3. Permission Control: Use read-only database users.
4. Audit Logs: Enable the database audit function.

🛡️ Security Features

• ✅ SQL injection protection
• ✅ Connection pool management
• ✅ Read-only query enforcement
• ✅ Input validation and timeout control
• ✅ Structured logging

❓ Frequently Asked Questions

Q: Failed to start with Node.js 18+? Use the NODE_OPTIONS=--openssl-legacy-provider parameter.

Q: Proxy connection failed?

• Check the proxy server status.
• Verify the proxy address and port.
• Confirm that the network connection is stable.

Q: How to use it in Claude Desktop? Add the configuration to the claude_desktop_config.json file.

Q: What database operations are supported? Only read-only operations are supported: SELECT, SHOW, DESCRIBE, EXPLAIN.

📄 License

ISC License

Maintenance Status: Production-ready, actively maintained npm Package: mcp-dm8-server GitHub: lianekai/mcp-dm8-server