Malove86_mcp-mysql-server
If you are the rightful owner of Malove86_mcp-mysql-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 Model Context Protocol-based server for interacting with MySQL databases, allowing AI models to communicate with databases through a standardized interface.
The mcp-mysql-server is a specialized server designed to facilitate seamless interaction between AI models and MySQL databases using the Model Context Protocol (MCP). It provides a standardized interface that abstracts the complexities of database operations, enabling AI models to perform database tasks efficiently. The server supports both local and remote deployment modes, allowing flexibility in how it is integrated into existing systems. With features like multi-user concurrency, efficient connection pool management, and detailed logging, the server is optimized for high performance and reliability. It also emphasizes security by using environment variables for sensitive information and supports pre-processed statements to prevent SQL injection. The server is designed to handle up to 50 concurrent connections, making it suitable for high-demand environments.
Features
- Multi-user concurrency support for handling multiple requests simultaneously.
- Efficient connection pool management with support for up to 50 concurrent connections.
- Request-level isolation with unique identifiers for tracking and debugging.
- Detailed logging of request execution and resource usage.
- Improved error handling for precise database error reporting.
Tools
connect_db
Use the provided credentials to establish a connection to the MySQL database
query
Execute SELECT query, support optional preprocessing statement parameters
list_tables
List all tables in the connected database
describe_table
Get the structure of a specific table
