MCP-MySQL-server-implementation
If you are the rightful owner of MCP-MySQL-server-implementation 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.
A Model Context Protocol server that provides access to MySQL databases, enabling LLMs to inspect database schemas and execute SQL queries.
The MCP Server for MySQL based on NodeJS is a robust solution for integrating MySQL databases with language model applications. It allows language models to interact with databases by inspecting schemas and executing SQL queries. The server supports both read and write operations, with configurable permissions for INSERT, UPDATE, and DELETE actions. It is designed to be secure, with features like SQL injection prevention and query whitelisting. The server also offers performance optimizations such as connection pooling and query caching, and it includes monitoring tools for logging and metrics collection. Installation and configuration are streamlined through various methods, including Smithery and MCP Get, making it accessible for different development environments.
Features
- Supports MySQL 5.7 and higher, with recommended use of MySQL 8.0+.
- Configurable permissions for write operations (INSERT, UPDATE, DELETE).
- Security features include SQL injection prevention and query whitelisting.
- Performance optimizations such as connection pooling and query caching.
- Comprehensive monitoring and debugging tools, including query logging and performance metrics.
