MySQL MCP

{
  "_meta": {
    "io.modelcontextprotocol.registry/official": {
      "status": "active",
      "isLatest": true,
      "updatedAt": "2026-10-22T08:39:58.558168Z",
      "publishedAt": "2026-10-22T08:39:58.558168Z",
      "statusChangedAt": "2026-10-22T08:39:58.558168Z"
    }
  },
  "server": {
    "name": "io.github.gistrec/mcp-mysql-client",
    "title": "MySQL MCP",
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
    "version": "1.0.1",
    "packages": [
      {
        "version": "1.0.1",
        "transport": {
          "type": "stdio"
        },
        "identifier": "mcp-mysql-client",
        "registryType": "npm",
        "registryBaseUrl": "https://registry.npmjs.org",
        "environmentVariables": [
          {
            "name": "MYSQL_HOST",
            "default": "127.0.0.1",
            "description": "Database host."
          },
          {
            "name": "MYSQL_PORT",
            "default": "3306",
            "description": "Database port."
          },
          {
            "name": "MYSQL_USER",
            "isRequired": true,
            "description": "MySQL user. Use one with the least privileges the task needs, never root."
          },
          {
            "name": "MYSQL_PASS",
            "isSecret": true,
            "description": "Password for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead."
          },
          {
            "name": "MYSQL_DB",
            "isRequired": true,
            "description": "The one database this server is bound to. No tool can leave it."
          },
          {
            "name": "MYSQL_SSL",
            "default": "false",
            "description": "Require a TLS connection to the server."
          },
          {
            "name": "MYSQL_SSL_CA",
            "description": "Path to the CA bundle verifying the server certificate; implies MYSQL_SSL."
          },
          {
            "name": "ALLOW_INSERT_OPERATION",
            "default": "false",
            "description": "Allow INSERT statements through the execute tool."
          },
          {
            "name": "ALLOW_UPDATE_OPERATION",
            "default": "false",
            "description": "Allow UPDATE statements through the execute tool."
          },
          {
            "name": "ALLOW_DELETE_OPERATION",
            "default": "false",
            "description": "Allow DELETE statements through the execute tool."
          },
          {
            "name": "MYSQL_MAX_ROWS",
            "default": "1000",
            "description": "Row cap for one read; the result is marked truncated when it is hit."
          },
          {
            "name": "MYSQL_TIMEOUT_MS",
            "default": "30000",
            "description": "Statement timeout in milliseconds; the connection is dropped on expiry."
          }
        ]
      }
    ],
    "repository": {
      "url": "https://github.com/gistrec/mcp-mysql-client",
      "source": "github"
    },
    "websiteUrl": "https://github.com/gistrec/mcp-mysql-client#readme",
    "description": "MCP server for one MySQL database: schema, read-only queries and guarded writes."
  }
}