SuMiaoALi/mysql-mcp-server

The MySQL MCP Server is a specialized server designed to facilitate secure and efficient interactions with MySQL databases through the Model Context Protocol (MCP). It is tailored for AI assistants and other MCP clients, ensuring that database operations are conducted safely and effectively. The server supports a range of operations, including executing SQL queries, retrieving table information, and inserting data, all while maintaining a strong focus on security. By leveraging parameterized queries and automatic LIMIT clauses, the server mitigates risks such as SQL injection and large data dumps. Additionally, connection pooling is employed to manage database connections efficiently, preventing resource exhaustion. The server is easily configurable through environment variables, allowing users to customize their database connections according to their needs. With its robust feature set and security measures, the MySQL MCP Server is an ideal solution for applications requiring reliable database interactions.

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["mysql-mcp-server"],
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-username",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_DB": "your-database"
      }
    }
  }
}

bash
npx mysql-mcp-server