mcp-mysql

mcp-mysql

3.2

If you are the rightful owner of mcp-mysql and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

mcp-mysql is a MySQL MCP Server implementation focusing on the DBA perspective, utilizing the MCP protocol.

The mcp-mysql project is designed to implement a MySQL server using the Model Context Protocol (MCP). It is structured to provide a modular and organized approach to server development, focusing on core functionalities, tools, and resources specific to MySQL. The project is divided into several directories, each serving a distinct purpose, such as core functionalities, MCP tools, and resources, as well as utilities for common functions. The project also emphasizes testing, documentation, and examples to ensure ease of use and understanding for developers. The design principles focus on modularity, separation of concerns, testability, comprehensive documentation, and example-driven learning.

Features

  • Modular Design: The project is organized into distinct directories for core functionalities, tools, and resources, promoting modularity and ease of maintenance.
  • Comprehensive Testing: Includes unit and integration tests to ensure the correctness and reliability of individual components and their interactions.
  • Extensive Documentation: Provides API documentation and user guides to facilitate understanding and usage of the MCP server.
  • Configuration Management: Contains a dedicated directory for configuration files, supporting server and database connection settings.
  • Example-Driven Learning: Offers example code and use cases to help users quickly grasp and utilize the MCP server.

Tools

  1. Query Execution

    Tool for executing MySQL queries within the MCP server.

  2. Table Management

    Tool for managing MySQL tables, including creation, deletion, and modification.