dameng-mcp-server

Name: dameng-mcp-server
Author: 1092705638

@1092705638

Repository

About dameng-mcp-server

dameng-mcp-server

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Other MCP servers

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K