dm-mcp-server
The project is an MCP service built around the Dameng database, providing tools for listing tables, executing read-only queries, and describing table structures. It aims to facilitate database interactions using a consistent protocol.
Dameng Database MCP Service
Project Overview
This project is a Microservice Communication Protocol (MCP) service based on the Dameng database, offering functionalities such as:
- Listing tables in the database
- Executing read-only SQL queries with support for SELECT, SHOW, DESCRIBE, and EXPLAIN statements
- Displaying table structure
Usage
You can download the dm-mcp-server binary file for Windows and add it to the PATH. The project can also be installed using Go install. The configuration requires setting environment variables for DM_PORT, DM_HOST, DM_USERNAME, DM_PASSWORD, and DM_SCHEMA.
Quick Start
Requirements
- Go version 1.16 or higher
- Dameng database installed and configured
- Ensure the 'github.com/mark3labs/mcp-go' library is installed
Installation
Initialize Go Modules and download dependencies in the project root directory.
Database Configuration
Configure Dameng database connection via command-line or environment variables.