zhaoxin34_mcp-server-mysql
This project is a Model Context Protocol server for MySQL databases that operates in a read-only mode. It enables secure and optimized querying by large language models, providing comprehensive database introspection capabilities. The server offers features like security, performance optimization, and extensive monitoring and debugging tools.
MCP Server for MySQL based on NodeJS
A Model Context Protocol server that provides read-only access to MySQL databases. This server allows large language models (LLMs) to inspect database schemas and execute read-only queries.
Features
- Execute read-only SQL queries with security features like SQL injection prevention.
- Provides comprehensive database information, including table schemas and foreign key relationships.
- Offers performance optimizations such as query result caching and connection pooling.
- Includes monitoring and debugging tools like query logging and health check endpoints.
Installation
You can install the server using Smithery, MCP Get, or manually with npm/pnpm. Configuration is needed to connect with your MySQL database.
Configuration
Supports both automatic configuration with Smithery and manual configuration methods.
Testing
Includes a comprehensive test suite to ensure reliability.
Troubleshooting
Guidelines are provided for common issues like connection problems and performance tuning.
Contributing
Contributions are welcome and instructions are provided for development setup and submitting changes.
License
Licensed under the MIT License.