dameng-mcp-server
About
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…
Details
- Author
- 1092705638
- GitHub stars
- 1
- Downloads
- 207
- Categories
- Other
Jump to
- 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)
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
dameng-mcp-serverCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
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"}.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"dameng-mcp-server": {
"dameng-mcp-server": {
"command": "python",
"args": [
"-m",
"dameng.server"
]
}
}
}
}McpServers
{
"dameng-mcp-server": {
"command": "python",
"args": [
"-m",
"dameng.server"
]
}
}dameng-mcp-server
达梦8数据库的MCP服务项目简介
dameng-mcp-server 是一个基于 MCP (Model Context Protocol) 协议的达梦8数据库服务，提供了与达梦数据库交互的能力，支持执行SQL查询、列出数据库表资源和读取表内容等功能。
功能特性
- 执行SQL查询：支持在达梦数据库上执行SQL语句并返回结果
- 列出数据库表：将数据库表作为资源列出
- 读取表内容：支持读取表的内容数据
- 基于MCP协议：通过MCP协议与客户端进行通信
- 环境变量配置：支持通过环境变量配置数据库连接信息
项目结构
dameng-mcp-server/
├── dameng/
│ ├── __init__.py # 包初始化文件，提供main入口
│ ├── client.py # MCP客户端实现
│ └── server.py # MCP服务器实现
└── README.md # 项目说明文档
依赖要求
- Python 3.7+
- dmPython（达梦数据库驱动）
- mcp（MCP协议库）
- pydantic
- openai（客户端使用）
- dotenv（加载环境变量）
安装方法
1. 克隆项目到本地
git clone <repository-url>
cd dameng-mcp-server
2. 安装依赖
pip install -r requirements.txt
环境变量配置
在项目根目录创建 .env 文件，配置以下环境变量：
```env
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
