dameng-mcp-server

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.