mcp-mysql-server
23
The project provides a Model Context Protocol server for MySQL databases, facilitating AI model interactions through a standardized interface. It features multiple connection methods, secure handling, error validation, and TypeScript support.
@enemyrr/mcp-mysql-server
A Model Context Protocol server for MySQL database operations, allowing AI models to interact with MySQL databases through a standardized interface.
Features
- Multiple connection methods (URL, workspace, direct)
- Secure connection handling with automatic cleanup
- Prepared statement support for query parameters
- Schema management tools
- Comprehensive error handling and validation
- TypeScript support
- Automatic workspace detection
Security
- Uses prepared statements to prevent SQL injection
- Supports secure password handling through environment variables
- Validates queries before execution
- Automatically closes connections when done
Error Handling
- Detailed error messages for connection failures, invalid queries, missing configuration, and schema validation errors
Contributing
Contributions are welcome at the GitHub repository.
License
MIT