广告合作
MCP.so
登录

AnalyticDB for MySQL MCP Server

@MCP-Mirror

代码仓库

基本信息

分类

数据库

许可证

Apache-2.0 license

传输方式

stdio

作者

MCP-Mirror

关于 AnalyticDB for MySQL MCP Server

Mirror of

#mathgpt#math-solver#math-assistant

AnalyticDB for MySQL MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "aliyun_alibabacloud-adb-mysql-mcp-server": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "-r",
        "pyproject.toml"
      ]
    }
  }
}

AnalyticDB for MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is AnalyticDB for MySQL MCP Server?

AnalyticDB for MySQL MCP Server is a universal interface that enables AI Agents to communicate with AnalyticDB for MySQL databases. It helps AI Agents retrieve database metadata and execute SQL operations.

How to use AnalyticDB for MySQL MCP Server?

Configure the server by adding an entry to your MCP client configuration file, setting environment variables for host, port, user, password, and database. Two deployment modes are supported: using a local clone of the GitHub repository with uv, or installing via pip with the adb-mysql-mcp-server package.

Key features of AnalyticDB for MySQL MCP Server

  • Connects AI Agents to AnalyticDB for MySQL databases
  • Provides three SQL-related tools: execute_sql, get_query_plan, get_execution_plan
  • Exposes database resources and resource templates via URI schemes
  • Allows retrieval of all databases, tables in a schema, table DDL, and config values
  • Supports both local source and pip-based installation

Use cases of AnalyticDB for MySQL MCP Server

  • AI Agents running ad-hoc SQL queries against AnalyticDB for MySQL
  • Retrieving database metadata (schemas, tables, DDL) for automated analysis
  • Obtaining query plans and runtime execution statistics for performance tuning
  • Building custom MCP servers on top of the provided Python package

常见问题

1

What does the AnalyticDB for MySQL MCP Server do?

It acts as a bridge between AI Agents and AnalyticDB for MySQL, allowing agents to fetch database metadata and execute SQL queries.

2

How do I install and configure the server?

Use either a local clone of the GitHub repository with `uv` or install via `pip install adb-mysql-mcp-server`. Then add the corresponding JSON entry to your MCP client configuration, setting the required environment variables.

3

What tools and resources are available?

The server offers three tools: `execute_sql`, `get_query_plan`, and `get_execution_plan`. Built-in resources include fetching all databases (`adbmysql:///databases`) and resource templates for tables (`adbmysql:///{schema}/tables`), DDL (`adbmysql:///{database}/{table}/ddl`), and config values (`adbmysql:///{config}/{key}/value`).

4

What dependencies are needed for development?

You need to install the `uv` package manager, `Node.js` (for `npx`), and the Python dependencies from `pyproject.toml`. The project source is available on GitHub.

5

Does the server include any prompts?

No, prompts are not provided at the present moment.

评论

数据库 分类下的更多 MCP 服务器

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Elasticsearch MCP Server

elastic

685

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
广告合作