Provides readonly access to MySQL databases, allowing listing tables, describing table structures, executing SELECT queries, showing databases, and switching databases.

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 list tables on the production server"

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.

npm install -g @your-username/mysql-mcp

git clone <repository-url>
cd mysql-mcp
npm install

{
 "production": {
 "host": "prod.example.com",
 "port": 3306,
 "user": "prod_user",
 "password": "prod_password",
 "database": "prod_db"
 },
 "staging": {
 "host": "staging.example.com",
 "port": 3306,
 "user": "staging_user",
 "password": "staging_password",
 "database": "staging_db"
 },
 "local": {
 "host": "localhost",
 "port": 3306,
 "user": "root",
 "password": "local_password",
 "database": "test_db"
 }
}

cp .env.example .env

{
 "mcpServers": {
 "mysql": {
 "command": "mysql-mcp",
 "env": {
 "MYSQL_SERVERS": "{\"production\":{\"host\":\"prod.example.com\",\"port\":3306,\"user\":\"prod_user\",\"password\":\"prod_password\",\"database\":\"prod_db\"},\"staging\":{\"host\":\"staging.example.com\",\"port\":3306,\"user\":\"staging_user\",\"password\":\"staging_password\",\"database\":\"staging_db\"}}"
 }
 }
 }
}

{
 "mcpServers": {
 "mysql": {
 "command": "node",
 "args": ["path/to/mysql-mcp/server.js"],
 "env": {
 "MYSQL_SERVERS": "{\"production\":{\"host\":\"prod.example.com\",\"port\":3306,\"user\":\"prod_user\",\"password\":\"prod_password\",\"database\":\"prod_db\"},\"staging\":{\"host\":\"staging.example.com\",\"port\":3306,\"user\":\"staging_user\",\"password\":\"staging_password\",\"database\":\"staging_db\"}}"
 }
 }
 }
}

{
 "mcpServers": {
 "mysql": {
 "command": "node",
 "args": ["path/to/mysql-mcp/server.js"],
 "env": {
 "MYSQL_HOST": "localhost",
 "MYSQL_PORT": "3306",
 "MYSQL_USER": "your_username",
 "MYSQL_PASSWORD": "your_password",
 "MYSQL_DATABASE": "your_database"
 }
 }
 }
}

// List tables from production server
await list_tables({ server: "production" })

// Query staging server
await query({ 
 sql: "SELECT * FROM users LIMIT 10",
 server: "staging"
})

// Describe table on local server
await describe_table({ 
 table_name: "products",
 server: "local"
})

// If no server is specified, "default" is used
await list_tables() // Uses "default" server

Looking for Admin?