MySQL MCP Server

Name: MySQL MCP Server
Author: blanplan-ai

@blanplan-ai

Repository

About MySQL MCP Server

No overview available yet

Basic information

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.