A Model Context Protocol server that provides MySQL database operations. This server enables AI models to interact with MySQL databases through a standardized interface.
Establish connection to MySQL database using provided credentials.
Execute SELECT queries with optional prepared statement parameters.
Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.
List all tables in the connected database.
Get the structure of a specific table.
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": ["-y", "@f4ww4z/mcp-mysql-server"],
"env": {
"MYSQL_HOST": "your_host",
"MYSQL_USER": "your_user",
"MYSQL_PASSWORD": "your_password",
"MYSQL_DATABASE": "your_database"
}
}
}
}