The MySQL MCP Server allows interaction with MySQL databases via JSON commands in a Docker container. You can:

• Execute read-only SQL queries (query)

• Test SQL write queries with automatic rollback (test_execute)

• List all tables in the database (list_tables)

• Describe the structure of a specific table (describe_table)

Runs as a containerized service with special configurations for host connectivity, allowing MySQL database access from Docker environments with proper networking setup.

Uses environment variables stored in .env files for configuration management, particularly for sensitive database connection credentials.

Enables interaction with MySQL databases through read-only queries, schema exploration, and safe testing of write operations (with rollback). Provides tools for executing queries, listing tables, and describing table structures.

Implemented in TypeScript, providing type-safe database interactions with MySQL.

1. Click on "Install Server".

2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.

3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MySQL MCP Server list all tables in the database"

That's it! The server will respond to your query, and you can continue using it as needed.

Here is a step-by-step guide with screenshots.

MYSQL_HOST=host.docker.internal # Hostname to access host services from Docker container
MYSQL_PORT=3306
MYSQL_USER=root
MYSQL_PASSWORD=your_password

{
 "mcpServers": {
 "mysql": {
 "command": "docker",
 "args": [
 "run",
 "-i",
 "--rm",
 "--add-host=host.docker.internal:host-gateway",
 "--env-file",
 "/Users/username/.mcp/.env",
 "ghcr.io/xiangma9712/mcp/mysql"
 ]
 }
 }
}

docker run -i --rm --add-host=host.docker.internal:host-gateway --env-file ~/.mcp/.env ghcr.io/xiangma9712/mcp/mysql

{
 "type": "query",
 "payload": {
 "sql": "SELECT * FROM your_table"
 }
}

{
 "success": true,
 "data": [
 {
 "id": 1,
 "name": "example"
 }
 ]
}

{
 "type": "test_execute",
 "payload": {
 "sql": "UPDATE your_table SET name = 'updated' WHERE id = 1"
 }
}

{
 "success": true,
 "data": "The UPDATE SQL query can be executed."
}

{
 "type": "list_tables"
}

{
 "success": true,
 "data": ["table1", "table2", "table3"]
}

{
 "type": "describe_table",
 "payload": {
 "table": "your_table"
 }
}

{
 "success": true,
 "data": [
 {
 "Field": "id",
 "Type": "int(11)",
 "Null": "NO",
 "Key": "PRI",
 "Default": null,
 "Extra": ""
 },
 {
 "Field": "name",
 "Type": "varchar(255)",
 "Null": "YES",
 "Key": "",
 "Default": null,
 "Extra": ""
 }
 ]
}