MySQL MCP Server

A read-only MySQL MCP server for OpenCode. Exposes a single safe_query tool that executes SELECT and SHOW queries while blocking all write operations.

Install

git clone <this-repo>
cd mysql-mcp
npm install

Configuration

Add the following to your opencode.json (or opencode.jsonc):

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "local-safe-mysql": {
      "type": "local",
      "enabled": true,
      "command": [
        "node",
        "/ABSOLUTE_PATH_TO_SCRIPT/mysql-mcp/server.js"
      ],
      "environment": {
        "DB_HOST": "HOST",
        "DB_PORT": "3306",
        "DB_USER": "USER",
        "DB_PASSWORD": "PASSWORD",
        "DB_NAME": "DBNAME"
      }
    }
  }
}

Replace the placeholder values:

Variable	Description
`ABSOLUTE_PATH_TO_SCRIPT`	Absolute path to the `mysql-mcp` directory
`HOST`	MySQL host (e.g. `localhost`)
`DB_PORT`	MySQL port (default `3306`)
`USER`	MySQL username
`PASSWORD`	MySQL password
`DBNAME`	Database name

Tool

`safe_query`

Run a read-only SQL query. Write operations (INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, REPLACE, TRUNCATE, GRANT, REVOKE, CALL, LOAD, HANDLER, RENAME) are blocked.

Input: { "sql": "SELECT * FROM users LIMIT 10" }