MCP Server MCP

MySQL MCP Server

By github 👁 1 views ▲ 0 votes

Python MCP server for MySQL database inspection and querying

Homepage Verified source GitHub

Install

uvx mdev-mysql-mcp-server

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "pypi",
      "registryBaseUrl": "https://pypi.org",
      "identifier": "mdev-mysql-mcp-server",
      "version": "0.1.2",
      "runtimeHint": "uvx",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "MySQL host",
          "default": "localhost",
          "name": "MYSQL_HOST"
        },
        {
          "description": "MySQL port",
          "default": "3306",
          "name": "MYSQL_PORT"
        },
        {
          "description": "MySQL username",
          "default": "root",
          "name": "MYSQL_USER"
        },
        {
          "description": "MySQL password",
          "isSecret": true,
          "name": "MYSQL_PASSWORD"
        },
        {
          "description": "MySQL database name",
          "isRequired": true,
          "name": "MYSQL_DATABASE"
        },
        {
          "description": "MySQL connection pool size",
          "default": "5",
          "name": "MYSQL_POOL_SIZE"
        },
        {
          "description": "Python logging level",
          "default": "INFO",
          "name": "LOG_LEVEL"
        },
        {
          "description": "Maximum rows returned by read queries",
          "default": "1000",
          "name": "MYSQL_READ_QUERY_LIMIT"
        }
      ]
    }
  ]
}

mcp model-context-protocol pypi