Skip to main content
Glama
Sign In
guido-marinho

MySQL MCP Server

by guido-marinho
OverviewSchemaSourceRelated ServersDiscussionsAdmin
JavaScript
Hybrid

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

Related MCP server: Simple MCP MySQL Server

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 deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • @cano721/mysql-mcp-server

    cano721
    A
    license
    A
    quality
    D
    maintenance
    Enables read-only MySQL database access, allowing listing databases, tables, describing schemas, and executing SELECT/SHOW/DESCRIBE/EXPLAIN queries.
    7
    15 npm
    4
    MIT

  • Simple MCP MySQL Server

    alexcc4
    F
    license
    Not graded
    quality
    D
    maintenance
    Enables AI assistants to securely interact with MySQL databases, including listing tables, viewing schemas, and executing read-only SQL queries through natural language.
    7
    -

  • MySQL MCP Server

    eltonf
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables schema introspection and safe read-only queries on MySQL databases, supporting table/column discovery, relationship exploration, and controlled SELECT queries.
    8 npm
    MIT

  • Text-to-SQL MCP Server

    down530
    F
    license
    Not graded
    quality
    D
    maintenance
    Enables secure SQL query execution on MySQL databases with authentication and permission control, allowing users to explore database tables and run read-only queries.
    -

Appeared in Searches