mcp-server-mysql

mcp-server-mysql

0

The @enemyrr/mcp-mysql-server is a Model Context Protocol server designed to facilitate MySQL database operations by enabling AI models to interact with databases through a standardized interface. It supports multiple connection methods, secure connection handling, and provides comprehensive error handling.

@enemyrr/mcp-mysql-server

  • Provides a Model Context Protocol server for MySQL database operations.
  • Enables AI models to interact with MySQL databases via a standardized interface.
  • Features:
    • Multiple connection methods (URL, workspace, direct).
    • Secure connection handling with automatic cleanup.
    • Prepared statement support, schema management tools, comprehensive error handling, and TypeScript support.
    • Automatic workspace detection and SQL injection prevention.

Features

  • Secure password handling through environment variables.
  • Detailed error messages for connection failures, invalid queries, missing configurations, and schema validation.
  • Contributions are welcome through its GitHub repository.

Security

  • Validates queries before execution and automatically closes connections when done.

Error Handling

  • Provides detailed error messages for various failure scenarios.