convez.ai
MCP Server
achmadya-dev

mcp-mysql-query

achmadya-dev/mcp-mysql-query

Ver no GitHub
InicialPluginScore · de 0 a 100

Model Context Protocol (MCP) server for MySQL to run SQL queries via stdio

Instalação

$npx convez-ai achmadya-dev/mcp-mysql-query

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
0
Forks
1
Acompanhando
0
Saúde
42%
Último commit
há 5 meses
Versão
v0.3.2
Issues abertas
0
Contribuidores
2

README

A tradução para o português deste README ainda está na fila.

@achmadya-dev/mcp-mysql-query

MCP server for MySQL. Runs a single SQL statement per tool call over stdio. Read-only by default — writes and DDL require explicit env flags.

Requirements

  • Node.js ≥ 20
  • A reachable MySQL server (local, Docker, or remote)

Install from npm

Add to Cursor Settings → MCP or .cursor/mcp.json:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@achmadya-dev/mcp-mysql-query"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Or load credentials from a file (Cursor envFile):

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@achmadya-dev/mcp-mysql-query"],
      "envFile": "/absolute/path/to/.env"
    }
  }
}

Develop from source

git clone https://github.com/achmadya-dev/mcp-mysql-query.git
cd mcp-mysql-query
pnpm install
pnpm run build
pnpm test

Open the repo root in Cursor. You need a reachable MySQL instance — set connection env in .cursor/mcp.json or via envFile:

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": ["${workspaceFolder}/dist/index.js"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Environment variables

Connection

VariableDefaultDescription
MYSQL_HOSTlocalhostMySQL host
MYSQL_PORT3306Port
MYSQL_USER(empty)Username
MYSQL_PASSWORD(empty)Password
MYSQL_DATABASE(optional)Database selected after connect
MYSQL_MAX_ROWS500Max rows returned for SELECT

Write access

Enabled when the value is true, 1, yes, or on (case-insensitive). If unset, that operation type is rejected.

VariableAllows
ALLOW_INSERT_OPERATIONINSERT, REPLACE
ALLOW_UPDATE_OPERATIONUPDATE
ALLOW_DELETE_OPERATIONDELETE
ALLOW_DDL_OPERATIONDDL (CREATE, ALTER, DROP, …)

Tools

ToolStatementsEnv flag
mysql_selectSELECT, SHOW, DESCRIBE, EXPLAIN, DESCalways on
mysql_insertINSERT, REPLACEALLOW_INSERT_OPERATION
mysql_updateUPDATEALLOW_UPDATE_OPERATION
mysql_deleteDELETEALLOW_DELETE_OPERATION
mysql_ddlDDLALLOW_DDL_OPERATION

Each tool accepts one sql string. Results are JSON text; SELECT output is capped by MYSQL_MAX_ROWS.

Behavior and security

  • One SQL statement per request (no ;-separated batches).
  • Dangerous patterns are blocked regardless of flags.
  • Read operations are always permitted.

Package scripts

pnpm run build
pnpm test
pnpm start
Ver o original no GitHub

Bom para

Relacionados