MySQL MCP Server

@he426100

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

he426100

关于 MySQL MCP Server

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

MySQL MCP Server 配置

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

{
  "mcpServers": {
    "mysql-mcp-server-he426100": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mysql-mcp-server",
        "."
      ]
    }
  }
}

MySQL MCP Server 工具

工具列表暂未提供

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

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

概览

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that enables secure interaction with MySQL databases. It allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.

How to use MySQL MCP Server?

Clone the repository, install dependencies with Composer, and set environment variables for database connection (DB_HOST, DB_PORT, DB_USERNAME, DB_PASSWORD, DB_DATABASE). Run as a standalone server with php bin/console or via Docker.

Key features of MySQL MCP Server

List available MySQL tables as resources
Read table contents
Execute SQL queries with proper error handling
Secure database access through environment variables
Comprehensive logging

Use cases of MySQL MCP Server

AI-assisted database exploration and schema discovery
Controlled read and query access for AI assistants
Secure, logged database interaction in development environments
Automated data retrieval and analysis workflows

常见问题

How does MySQL MCP Server ensure security?

It uses environment variables for credentials, recommends creating a dedicated MySQL user with minimal permissions, never uses root credentials, and enables logging for audit purposes.