MySQL

pcpro-mcp-mysql

javascript

0

GitHub Stars

javascript

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "franhr11-pcpro-mcp-mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@f4ww4z/mcp-mysql-server",
        "mysql://user:password@localhost:port/database"
      ],
      "env": {
        "MYSQL_HOST": "your_host",
        "MYSQL_USER": "your_user",
        "MYSQL_DATABASE": "your_database",
        "MYSQL_PASSWORD": "your_password"
      }
    }
  }
}

You can use this MCP server to let AI models perform MySQL database operations through a standardized interface. It provides secure, parameterized queries, table descriptions, and convenient helpers to connect, query, and modify data without exposing raw SQL handling to the model.

How to use

To use the MySQL MCP server from an MCP client, first establish a connection to your MySQL database using the provided connect_db tool. Then perform read operations with query, write operations with execute, and inspect database structure with describe_table or list_tables. All actions are executed through the MCP server, which manages connections, prepares statements, and returns results in a structured format. Ensure you supply the correct host, user, password, and database so the MCP client can connect securely and reuse connections where possible.

How to install

Prerequisites: Node.js and npm (or a compatible runtime for your environment) must be installed on your system. You may install the MCP server either via a client installation flow or run it locally.

npx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude

Manual installation runs the MCP server locally using the packaged CLI. Run the following command to start the server directly.

npx @f4ww4z/mcp-mysql-server

Additional configuration and usage notes

Configure the MCP server in your MCP settings to provide a concrete connection to your MySQL instance. You can either embed the full DSN in the startup command or set environment variables for the host, user, password, and database. The following examples show two valid configuration approaches.

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

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

Available tools

connect_db

Establish a connection to the MySQL database using provided credentials.

query

Execute SELECT queries with optional prepared statement parameters.

execute

Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.

list_tables

List all tables in the connected database.

describe_table

Get the structure of a specific table.