MySQL MCP Server

Name: MySQL MCP Server
Author: blanplan-ai

@blanplan-ai

代码仓库

关于 MySQL MCP Server

暂无概览

基本信息

分类

数据库

许可证

Apache-2.0 license

运行时

传输方式

stdio

发布者

blanplan-ai

配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

工具

未检测到工具

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

概览

What is MySQL MCP Server?

A MySQL database connection server built on go-mcp, supporting communication with clients via stdio for executing SQL queries and data manipulation operations. It is designed for developers and AI assistants that need to interact with MySQL databases through the Model Context Protocol.

How to use MySQL MCP Server?

Install via go install github.com/blanplan-ai/ai2mysql-mcp-server/cmd/ai2mysql-mcp-server@latest or build from source. Configure using environment variables (e.g., MYSQL_HOST, MYSQL_USER, MYSQL_PASS) and run the server binary. In clients like Cursor, add a JSON configuration to the MCP servers list.

Key features of MySQL MCP Server

Communicates with clients through the MCP protocol
Supports SELECT, SHOW, DESCRIBE queries
Supports INSERT, UPDATE, DELETE with permission control
Flexible configuration via environment variables
Debug mode with detailed logging to file
Provides mysql_query and mysql_execute tools

Use cases of MySQL MCP Server

AI-powered database assistants executing read queries
Automated data reporting and analysis workflows
Controlled data modification with insert/update/delete permissions
Integration with MCP-compatible IDEs like Cursor

FAQ from MySQL MCP Server

What SQL operations are supported?

Query operations (SELECT, SHOW, DESCRIBE) and data manipulation (INSERT, UPDATE, DELETE). Permission to manipulate data must be explicitly enabled via ALLOW_INSERT, ALLOW_UPDATE, and ALLOW_DELETE environment variables.

How do I enable write operations?

Set ALLOW_INSERT=true, ALLOW_UPDATE=true, or ALLOW_DELETE=true in the environment configuration. By default, only read queries are allowed.

How does the server communicate with clients?

The server uses stdio transport and conforms to the MCP protocol, making it compatible with clients that support MCP, such as Cursor.

What are the runtime dependencies?

The server is written in Go and uses the MySQL driver (go-sql-driver/mysql). No external runtime beyond the compiled binary is required.

How can I troubleshoot connection issues?

Enable development mode by setting IS_DEV=true. This outputs detailed logs to the configured log file (default /tmp/ai2mysql.log) showing requests, responses, errors, and query execution time.