Mysql MCP Server

@Mineru98

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

Mineru98

关于 Mysql MCP Server

A server application designed on top of MCP to interact with Cursor and MySQL.

#mysql #mcp

Mysql MCP Server 配置

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

{
  "mcpServers": {
    "mysql-mcp-server-mineru98": {
      "command": "python",
      "args": [
        "mysql_mcp_server/main.py",
        "run"
      ]
    }
  }
}

Mysql MCP Server 工具

工具列表暂未提供

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

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

概览

What is mysql-mcp-server?

mysql-mcp-server is a server application for MySQL database operations built on the Model Context Protocol (MCP). It provides tools that allow AI models to interact with a MySQL database.

How to use mysql-mcp-server?

Deploy via Docker, Docker Compose, or run directly with Python. Set environment variables for MySQL connection (host, port, user, password, database). For Cursor IDE, version 0.46+ and a Pro account are required. Use python mysql_mcp_server/main.py run for local execution.

Key features of mysql-mcp-server

Docker and Docker Compose deployment
Python-based MCP server using FastMCP
Tools for CREATE, SELECT, INSERT, DESC, EXPLAIN, SHOW TABLES
Database connection management via singleton pattern
Environment variable configuration for credentials
Visualization chart recommendation tool

Use cases of mysql-mcp-server

AI models querying MySQL databases via natural language
Automated database schema exploration and reporting
Generating data analysis reports with chart recommendations
Executing safe SQL operations through tool-based access
Integrating MySQL into MCP-enabled workflows

常见问题

What database tools does mysql-mcp-server provide?

It offers tools for creating tables, viewing schemas, executing SELECT and INSERT queries, retrieving table lists, explaining query plans, and generating insight reports.

What are the runtime requirements for mysql-mcp-server?

Python with dependencies (mcp, PyMySQL, pandas, python-dotenv, fire) and MySQL 8.0. Docker and Docker Compose are optional for containerized deployment.

How do I add a new tool to mysql-mcp-server?

Create an executor file in `mysql_mcp_server/executors`, then import it in `__init__.py` and add it to the `__all__` array. The `@tool` decorator registers it with MCP.

Are there any security considerations for mysql-mcp-server?

Database credentials are managed via environment variables. Use strong passwords in production and consider implementing SSL/TLS encryption for database connections.

Does mysql-mcp-server support Cursor IDE?

Yes, it works with Cursor version 0.46 and above, but only for Cursor Pro account users. Configuration requires adding the server in Cursor settings.

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

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

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