MySQL

MySQL is an MCP server for reading and querying MySQL with schema awareness. Its connected implementation exposes 0 tools when the server starts successfully.

Add to Longwave

Source

Install elsewhere

Install MySQL

Choose a harness. These instructions start the same local MCP server shown on this page.

Claude Code

Run this in your terminal. It adds a user-scoped server; use --scope project instead if it should apply only to the current project.

terminal

claude mcp add --scope user --transport stdio --env MYSQL_HOST=YOUR_MYSQL_HOST --env MYSQL_USER=YOUR_MYSQL_USER --env MYSQL_PASS=YOUR_MYSQL_PASS mysql -- npx -y @benborla29/mcp-server-mysql

Replace each YOUR_… value with the required secret before running the command.

Claude Desktop

Open Claude Desktop → Settings → Developer → Edit Config. Add this entry to claude_desktop_config.json, save it, then fully restart Claude Desktop.

claude_desktop_config.json

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "YOUR_MYSQL_HOST",
        "MYSQL_USER": "YOUR_MYSQL_USER",
        "MYSQL_PASS": "YOUR_MYSQL_PASS"
      }
    }
  }
}

Replace each YOUR_… value in the env block with the required secret.

Codex

Run this in the Codex CLI:

terminal

codex mcp add mysql --env MYSQL_HOST=YOUR_MYSQL_HOST --env MYSQL_USER=YOUR_MYSQL_USER --env MYSQL_PASS=YOUR_MYSQL_PASS -- npx -y @benborla29/mcp-server-mysql

Codex stores the same server in ~/.codex/config.toml (or a trusted project’s .codex/config.toml):

~/.codex/config.toml

[mcp_servers.mysql]
command = "npx"
args = ["-y", "@benborla29/mcp-server-mysql"]
env = { MYSQL_HOST = "YOUR_MYSQL_HOST", MYSQL_USER = "YOUR_MYSQL_USER", MYSQL_PASS = "YOUR_MYSQL_PASS" }

Replace each YOUR_… value with the required secret.

Cursor

Add this to .cursor/mcp.json for the current project or ~/.cursor/mcp.json for all projects. Cursor resolves ${env:NAME} from your environment.

.cursor/mcp.json

{
  "mcpServers": {
    "mysql": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "${env:MYSQL_HOST}",
        "MYSQL_USER": "${env:MYSQL_USER}",
        "MYSQL_PASS": "${env:MYSQL_PASS}"
      }
    }
  }
}

OpenCode

Add this server under the mcp object in opencode.json or opencode.jsonc. You can also run opencode mcp add and follow its prompts.

opencode.json

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mysql": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "enabled": true,
      "environment": {
        "MYSQL_HOST": "{env:MYSQL_HOST}",
        "MYSQL_USER": "{env:MYSQL_USER}",
        "MYSQL_PASS": "{env:MYSQL_PASS}"
      }
    }
  }
}

OpenCode resolves each {env:NAME} reference from your environment.

What it does

MySQL MCP connects an agent to a MySQL database with its schema in reach. It is for questions about the real tables, columns and data—not a schema the agent has reconstructed from memory.

Inspect MySQL schemas and tables.
Run database queries through the MCP connection.
Use schema information when forming a query.
Pass MySQL host and credentials through environment variables.
Review the live function arguments before a database call.

Skills that ship with it

The skill is a pointer rather than a method. The server's own tool descriptions carry the detail of how to query. Longwave installs it with the server, and each name below opens the skill's source.

MySQL Point the agent at the MySQL MCP server when a task needs the database.

Questions people ask

How do I use MySQL MCP in Cursor?

Add the local MySQL server to Cursor's MCP settings and provide the database host, user and password through the server environment. Cursor can use the schema and query operations after startup.

Which MySQL MCP server should I use?

The catalog entry is a local server for schema-aware MySQL queries. Check its live launch details and required credentials before substituting a different package from a search result.

Can MySQL MCP connect to a MySQL database?

Yes. Provide the MySQL host and credentials to the local process. The process must be able to reach the database from the machine where the MCP client starts it.

Can MySQL MCP run in Docker?

Yes, if the container can reach the MySQL host and receives the required connection values. Use a database account with only the permissions the agent needs.

Can MySQL MCP run in Python?

The catalog includes a Python-oriented server launch path. Use the resolved command shown for this entry and let it manage the runtime instead of mixing it with an unrelated global Python installation.

Can MySQL MCP run SELECT queries?

The entry is for reading and querying MySQL. Check the live function schema before relying on a specific SELECT operation or query argument.

What credentials does MySQL MCP need?

It needs a MySQL host, user and password. Keep those values in the server environment and use a database account with limited permissions.

Give the agent the real MySQL schema.

Let it query the database you actually run instead of guessing from a pasted example.

Download Longwave