mcp-mysql-server
The @f4ww4z/mcp-mysql-server is a Model Context Protocol server specifically designed for AI models to interact with MySQL databases seamlessly. It offers secure connection handling, robust error handling, and supports TypeScript, making it a reliable choice for database operations.
How do I install the MCP MySQL server?
You can install it via Smithery using the command npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude or manually with npx @f4ww4z/mcp-mysql-server.
What environment variables are required for configuration?
You need to set MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP settings configuration file.
How does the server handle security?
The server uses prepared statements to prevent SQL injection and supports secure password handling through environment variables.
What types of queries can be executed?
The server supports SELECT, INSERT, UPDATE, and DELETE queries with optional prepared statement parameters.
How can I contribute to the project?
Contributions are welcome! You can submit a Pull Request to the GitHub repository at https://github.com/f4ww4z/mcp-mysql-server.