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.