MCP Mysql

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 provided credentials or environment-configured values.

query

Executes a SQL query with optional prepared statement parameters to safely retrieve or modify data.

list_tables

Lists all tables in the connected database for quick inspection.

describe_table

Retrieves the structure and metadata of a specified table.