Which integrations are available for this server?

Provides read-only access to MySQL databases with tools for executing SELECT queries and automatic discovery of table schemas, columns, types, keys, and constraints.

How do I use MySQL MCP Server?

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 show me the top 10 customers by total purchase amount" 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 MCP Server

A Model Context Protocol server that provides read-only access to MySQL databases.

Features

Tools

query - Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
- All queries run within READ ONLY transactions

Resources

Table schemas - Automatic discovery of tables and columns with their types, keys, and constraints

Installation

Docker

docker build -t mcp/mysql . docker run -i --rm mcp/mysql mysql://user:password@host:3306/database

NPM

npm install -g @modelcontextprotocol/server-mysql

NPX

npx -y @modelcontextprotocol/server-mysql mysql://user:password@localhost:3306/database

Usage

Add to your MCP's config:

Using Docker image (recommended)

docker pull guidomarinho/mcp-mysql

{ "mcpServers": { "your_mcp": { "type": "stdio", "command": "docker", "args": [ "run", "-i", "--rm", "guidomarinho/mcp-mysql:latest", "mysql://root:password@host.docker.internal:3306/you_db" ], "env": {} } } }

Using local Docker

{ "mcpServers": { "mysql": { "command": "docker", "args": [ "run", "-i", "--rm", "mcp/mysql", "mysql://root:password@host.docker.internal:3306/database" ] } } }

Using NPX

{ "mcpServers": { "mysql": { "command": "npx", "args": [ "-y", "@modelcontextprotocol/server-mysql", "mysql://user:password@localhost:3306/database" ] } } }

Note: When using Docker to connect to a MySQL server on your host machine, use host.docker.internal instead of localhost.

Connection String Format

mysql://username:password@host:port/database

Development

npm install npm run build node dist/index.js mysql://user:password@localhost:3306/database

License

MIT

This server cannot be installed

-

security - not tested

A

license - permissive license

-

quality - not tested

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Report Issue

Related Servers

MySQL MCP Server

MySQL MCP Server

Features

Tools

Resources

Installation

Docker

NPM

NPX

Usage

Using Docker image (recommended)

Using local Docker

Using NPX

Connection String Format

Development

License

Resources

Appeared in Searches

New MCP Servers

Latest Blog Posts

MCP directory API