dameng-mcp
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@dameng-mcplist all tables in the SYSDBA schema"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
达梦数据库 MCP Server
使用 JDBC 连接达梦数据库,暴露为 MCP 工具,供 AI 编码助手直接查询。
新增优化
JDBC statement 级查询超时(并保留 timer fallback)
describe_table现在包含主键 / 唯一约束 / 外键信息新增
dameng_health_check新增
dameng_list_indexes新增
dameng_list_procedures新增
dameng_list_triggers新增
dameng_list_synonyms增加 MCP
list_tools启动验证测试
Related MCP server: dameng-mcp-server
快速开始
cd dameng-mcp
pip install -e .
cp .env.example .env
python -m dameng_mcp.serverMCP 工具
工具 | 用途 |
| 执行只读 SQL |
| 列出 schema |
| 列出表 |
| 查看表结构、主键、唯一约束、外键 |
| 列出视图 |
| 查看指定表索引 |
| 列出过程对象(存储过程 / 函数 / 包) |
| 列出触发器 |
| 列出同义词 |
| 查看执行计划 |
| 检查连接健康与延迟 |
测试
pytest tests/ -v真实数据库联调:
DM_TEST_HOST=... \
DM_TEST_PORT=5236 \
DM_TEST_DATABASE=... \
DM_TEST_USER=SYSDBA \
DM_TEST_PASSWORD=... \
DM_TEST_SCHEMA=... \
JAVA_HOME=... \
pytest tests/ -vThis server cannot be deployed
Maintenance
Related MCP Connectors
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
MCP Server for JFrog, providing tools for development and artifact management.
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceEnables interaction with Dameng databases through natural language or direct SQL operations. Provides a web interface for listing tables, executing queries, and viewing table structures with MCP protocol support for AI model integration.1-
- AlicenseNot gradedqualityDmaintenanceMCP server for DaMeng database, enabling AI assistants to execute SQL queries, list tables, describe table structures, and retrieve schema information.24 npm7MIT
- AlicenseAqualityDmaintenanceMCP server for Dameng database, providing tools to test connection, list tables, count tables, and execute SQL via environment variables.9MIT
- AlicenseAqualityDmaintenanceMCP server enabling AI assistants to connect and query Dameng DM8 databases via JDBC. Supports SQL queries, listing tables, and describing schemas.323 npmMIT