zhaoxin34_mcp-server-mysql
If you are the rightful owner of zhaoxin34_mcp-server-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.
A Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
The MCP Server for MySQL based on NodeJS is designed to facilitate read-only interactions with MySQL databases. It allows Language Model Machines (LLMs) to access and inspect database schemas, execute read-only queries, and gather comprehensive database information. The server is equipped with features that enhance security, performance, and monitoring, making it a robust solution for database interactions. It supports various installation methods, including Smithery, MCP Get, and manual installation via npm or pnpm. The server is optimized for performance with features like connection pooling, query caching, and large result set streaming. Security is prioritized with SQL injection prevention, query whitelisting, and rate limiting. Additionally, the server offers extensive monitoring and debugging capabilities, including query logging and performance metrics collection.
Features
- SQL injection prevention through prepared statements
- Optimized connection pooling and query result caching
- Comprehensive query logging and performance metrics collection
- Rate limiting and query complexity analysis
- Read-only transaction enforcement
