a month ago
A Model Context Protocol (MCP) server that gives AI agents direct access to MySQL databases even on production environments.
Server Config
{
"mcpServers": {
"mysql": {
"command": "node",
"args": [
"/absolute/path/to/mysql-mcp/dist/index.js"
],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "mcp_user",
"MYSQL_PASSWORD": "your_password",
"MYSQL_DATABASE": "",
"MAX_ROWS": "1000",
"ALLOW_DESTRUCTIVE_DDL": "false"
}
}
}
}