Home / MCP / MCP MySQL Server

MCP MySQL Server

Provides a MySQL database operation interface for AI models via the Model Context Protocol.

typescript

9stars

View on GitHub

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
    "mcpServers": {
        "mcp_mysql_server": {
            "url": "http://your-server-address:port/mcp-mysql-server"
        }
    }
}

You can access and manipulate MySQL databases through a standardized MCP interface that lets AI models perform queries, list tables, and inspect table structures safely and efficiently. This server handles connection pooling, multi-user concurrency, and secure handling of credentials so you can focus on building AI-powered data workflows.

How to use

You will interact with this MCP server through an MCP client that calls predefined tools to connect to MySQL, run queries, list tables, and describe table structures. There are two deployment approaches: local (stdio) mode where you run the server on your machine or environment, and remote (http) mode where you point clients at a remote MCP endpoint.

How to install

Prerequisites: you need Node.js installed on your system. It is recommended to use a recent LTS version of Node.js and npm or npx is available with your Node installation.

# Install the MCP server locally and prepare to run it
# Ensure Node.js and npm are installed on your system

# Install and run the MCP server locally (stdio mode)
export MYSQL_HOST=your_host
export MYSQL_USER=your_user
export MYSQL_PASSWORD=your_password
export MYSQL_DATABASE=your_database
export MYSQL_PORT=3306  # optional, defaults to 3306

npx -y @malove86/mcp-mysql-server

Additional configuration and usage notes

Configure how the server is exposed to clients using the two deployment modes described below. You can choose the local, self-contained approach or the remote endpoint approach based on your environment and security needs.

Configuration options

Local runtime configuration (stdio) lets you include runtime settings in a MCP config file. Use the following structure to define the local server entry. It starts the MCP server via npx and passes the necessary environment variables for MySQL access.

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@malove86/mcp-mysql-server"],
      "env": {
        "MYSQL_HOST": "your_host",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database",
        "MYSQL_PORT": "3306"
      }
    }
  }
}

Remote URL mode (http)

If you want to run the MCP server remotely, you can point clients at a remote endpoint. Use a configuration that specifies the remote URL of the MCP server. The server will accept connections by URL and handle requests over HTTP.

{
  "mcpServers": {
    "mcp-mysql-server": {
      "url": "http://your-server-address:port/mcp-mysql-server"
    }
  }
}

Available tools

connect_db

Establishes a connection to the MySQL database using the provided credentials or environment variables.

query

Executes a SELECT query with optional prepared statement parameters.

list_tables

Lists all tables in the connected database.

describe_table

Retrieves the structure of a specified table.