dameng-mcp-server

Name: dameng-mcp-server
Author: 1092705638

@1092705638

代码仓库

关于 dameng-mcp-server

dameng-mcp-server

基本信息

分类

其他

运行时

python

传输方式

stdio

发布者

1092705638

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "dameng-mcp-server": {
      "command": "python",
      "args": [
        "-m",
        "dameng.server"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is dameng-mcp-server?

dameng-mcp-server is an MCP (Model Context Protocol) server for Dameng 8 (达梦8) databases. It enables clients to execute SQL queries, list database tables as resources, and read table contents. The server is aimed at developers and applications that need programmatic access to Dameng 8 via the MCP protocol.

How to use dameng-mcp-server?

Clone the repository, install dependencies with pip install -r requirements.txt, configure database and OpenAI API credentials in a .env file (variables: DAMENG_USER, DAMENG_PASSWORD, DAMENG_HOST, DAMENG_DATABASE, DASHSCOPE_API_KEY, BASE_URL, MODEL), then start the server with python -m dameng.server and the client with python -m dameng.client. SQL queries are sent through the client, for example: execute_sql {"query": "SELECT * FROM TABLE_NAME LIMIT 10"}.

Key features of dameng-mcp-server

Execute SQL queries on Dameng 8 and return results
List database tables as MCP resources
Read table content data
Uses the MCP protocol for client-server communication
Configurable via environment variables (.env file)

Use cases of dameng-mcp-server

Query Dameng 8 databases from an MCP‑compatible client (e.g., AI agents)
Browse available tables and their schemas programmatically
Extract data from specific tables for analysis or migration

FAQ from dameng-mcp-server

What dependencies are required?

Python 3.7+, dmPython (Dameng database driver), mcp, pydantic, openai, and dotenv. Install them via pip install -r requirements.txt.

How do I configure the database connection?

Create a .env file in the project root with variables DAMENG_USER, DAMENG_PASSWORD, DAMENG_HOST, and DAMENG_DATABASE. Make sure the Dameng 8 database service is running and accessible.

How do I start the server and client?

Run python -m dameng.server to start the MCP server, and python -m dameng.client in a separate terminal to run the client that sends queries.

What operations does the server support?

It supports executing arbitrary SQL statements (via execute_sql), listing all tables as resources, and reading the contents of a table.

Are there any prerequisites for using dameng-mcp-server?

You must have the dmPython driver installed and the Dameng 8 database service running. Environment variables must be set correctly. The client also requires an OpenAI API key and base URL to function.