Mineru98_mysql-mcp-server
If you are the rightful owner of Mineru98_mysql-mcp-server 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 Server is a server application for MySQL database operations based on MCP (Model Context Protocol). This server provides tools that allow AI models to interact with the MySQL database.
MCP MySQL Server is a robust server application designed to facilitate MySQL database operations through the Model Context Protocol (MCP). It enables AI models to seamlessly interact with MySQL databases, providing a suite of tools for executing various database operations. The server is built using Python and leverages key libraries such as PyMySQL for database connectivity, pandas for data processing, and mcp for protocol implementation. It supports containerized deployment via Docker and Docker Compose, ensuring easy setup and scalability. The server architecture is structured into layers, including an interface layer for MCP communication, a business logic layer for handling operations, and a data access layer for managing database interactions. This design ensures efficient communication between AI models and the database, allowing for operations like table creation, schema viewing, query execution, and more.
Features
- Containerized deployment via Docker and Docker Compose
- Supports MySQL 8.0 for database management
- Implements Model Context Protocol for AI communication
- Provides a suite of tools for database operations
- Structured architecture with layered design
Tools
execute_create_table
Create a database table
execute_desc_table
View table structure
execute_explain
Get query execution plan
execute_insert_query
Perform an INSERT query
execute_select_query
Perform a SELECT query
execute_show_tables
Get a list of tables in the database
execute_insight_starter
Check the table structure to generate a report
execute_invoke_viz_pro
Recommended visual charts
