MCP.so
登录

MySQL MCP Server

@he426100

代码仓库

关于 MySQL MCP Server

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

基本信息

分类

数据库

许可证

MIT license

运行时

php

传输方式

stdio

发布者

he426100

配置

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

{
  "mcpServers": {
    "mysql-mcp-server-he426100": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "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

FAQ from MySQL MCP Server

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.

What are the runtime requirements for MySQL MCP Server?

PHP and Composer are required. A MySQL database server must be accessible, with connection details provided via environment variables.

How do I run MySQL MCP Server with Docker?

Build the image with docker build -t mysql-mcp-server ., then run with docker run -i --rm mysql-mcp-server --host 127.0.0.1.

Is there support for query whitelisting?

The README suggests considering query whitelisting for production use but does not implement it by default.

Where is database connection data stored?

Connection credentials are supplied via environment variables at runtime; no persistent credential storage is provided by the server.

评论

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

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818