MySQL MCP Server

@ganganbiz1

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

ganganbiz1

关于 MySQL MCP Server

暂无概览

MySQL MCP Server 配置

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

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

MySQL MCP Server 工具

工具列表暂未提供

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

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

概览

What is MySQL MCP Server?

A MySQL Model Context Protocol (MCP) server implemented with FastMCP 2.0 and Python. It enables AI assistants and MCP clients to execute SQL queries, retrieve database schema information, and explore MySQL databases via standardized MCP tools.

How to use MySQL MCP Server?

Deploy using Docker (recommended) or run locally with Poetry. Set environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) to connect to a MySQL instance. For Cursor integration, add the provided configuration to ~/.cursor/mcp.json. The server exposes five MCP tools: execute_query, execute_update, get_tables, get_table_schema, and describe_database.

Key features of MySQL MCP Server

Execute SQL queries and return results via MCP
Get schema information for tables and entire database
Fully containerized with Docker and docker-compose
Packaged with Poetry for dependency management
Provides five ready-to-use MCP tools

Use cases of MySQL MCP Server

AI assistants querying MySQL databases in real time
Dynamic schema exploration for database documentation
Automating data retrieval and updates via MCP clients
Integrating MySQL with Cursor or other MCP-supporting IDEs

常见问题

What are the prerequisites for running MySQL MCP Server?

Docker and docker-compose are required for containerized deployment. For local development, you need Python 3.13+ and Poetry.

How do I connect the server to my MySQL database?

Set the environment variables `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASSWORD`, and `MYSQL_DATABASE` before starting the container. The Docker run command passes these variables from the host environment.

What MCP tools does the server provide?

Five tools: `execute_query` (read-only SQL), `execute_update` (INSERT/UPDATE), `get_tables`, `get_table_schema`, and `describe_database` (comprehensive structure).

How do I integrate MySQL MCP Server with Cursor?

Add the provided JSON block to `~/.cursor/mcp.json`, specifying the Docker command and environment variables. The server will then be available as an MCP tool within Cursor.

Can I develop or run the server locally without Docker?

Yes, the project is packaged with Poetry for local development. The README lists Poetry as a prerequisite for non-Docker usage, though no explicit local run command is given.

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

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.