MCP.so
登录

MySQL MCP Server

@blanplan-ai

基本信息

分类

数据库

许可证

Apache-2.0 license

传输方式

stdio

作者

blanplan-ai

关于 MySQL MCP Server

暂无概览

MySQL MCP Server 配置

暂无标准配置

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

代码仓库

MySQL MCP Server 工具

工具列表暂未提供

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

工具是从 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

常见问题

1

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.

2

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.

3

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.

4

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.

5

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.

评论

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